Looping Report To Spreadsheet

This is an example of a report snippet that may be printed to spreadsheet. This is very useful for outputting information from many database fields to a simple file that may be read and processed by a variety of programs.

When printing to spreadsheet it is necessary to add < to each field code to trim white space from the field data printed to the spreadsheet.

This is an example of a Client loop that prints all Debtor information. Each debtor's information is printed on a single line in the spreadsheet.

@cl
@cl.de
@no line feed
@de.fi<, @de.na<, @de.ad<, @de.a1<, @de.ao<, @de.ci<, @de.st<, @de.zi<, @de.cou<,
@de.do<,@de.dl<, @de.ss<, @de.ho<, @de.he<, @de.po<, @de.we<, @de.ce<,
@de.cex<,
@de.ot<, @de.oe<, @de.poe<, @de.u1<, @de.u2<, @de.su<, @de.ch<, @de.de<,
@de.sta<,
@de.pr<, @de.pa<, @de.cl<,
@de.ac<
@ line feed

@cl.de
@cl

Aside from this, any other cell formatting is performed in your spreadsheet application.

When you print to spreadsheet, Collect! creates a *.csv file, a simple, comma-separated ASCII text file readable by numerous applications.

See Also

- Report Sample to view sample reports and letters
- Report Topics Index for a list of all report and letter topics