Output as Excel (PHP)

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.

To output your report as an Excel file, use the configureXLSXDevice() and selectDevice() functions:

$greRunnerObj->configureXLSXDevice (
   NULL,  #fromPage INTEGER,
   NULL,  #toPage INTEGER,
   NULL,  #removeWhitespace INTEGER,
   NULL,  #ignoreRowAlignment INTEGER,
   NULL,  #ignoreColumnAlignment INTEGER,
   NULL,  #removeBackgroundImages INTEGER,
   TRUE ); #mergePages BOOLEAN
$greRunnerObj->selectDevice('XLSX');   

For the full list of properties and methods, refer to the Genero Report Writer PHP API documentation.