Create an Excel spreadsheet report

Set up and configure output to Microsoft® Excel™ from your reporting application. This option is useful if you want to perform custom calculations in Excel.

Note: Excel reports, as output from Genero Report Writer, do not print at high quality. If you require high-fidelity printing, use one of the other output options, such as SVG.

The report output can be sent to an Excel spreadsheet by passing the string "XLS" or "XLSX" to the function fgl_report_selectDevice. First, you should configure the report output using the fgl_report_configureXLSDevice or fgl_report_configureXLSXDevice functions.

This code fragment illustrates the functions enabling Excel output:

...
CALL fgl_report_configureXLSXDevice (
   NULL,  #fromPage INTEGER,
   NULL,  #toPage INTEGER,
   NULL,  #removeWhitespace INTEGER,
   NULL,  #ignoreRowAlignment INTEGER,
   NULL,  #ignoreColumnAlignment INTEGER,
   NULL,  #removeBackgroundImages INTEGER,
   TRUE ) #mergePages BOOLEAN
CALL fgl_report_selectDevice("XLSX")
...