The following routines are meant to write values obtained via a SIL script to an Excel file, and also to configure the writing process. These routines should be used in the reporting script, after the data has been generated.
Routine | Description | Syntax |
|---|---|---|
| reporting_setupTemplate | Routine that defines the Excel template file path. | reporting_setupTemplate(templatePath [, useStreaming]) |
| reporting_setupSheet | Routine that defines a worksheet in which the data is to be written. | reporting_setupSheet(sheetName, headers, columnTypes) |
| reporting_addData | Routine that adds a bulk of data to some worksheet defined before. | reporting_addData(sheetName, data) |
| reporting_writeWorkbook | Routine that writes the Excel file and sends it back to the user. | reporting_writeWorkbook() |