...
reporting_setupSheet(sheetName, headers, columnTypes, [headerRowsNo]);
Description:
| Excerpt |
|---|
Adds extra parameters to the internal setup configuration created with the reporting_setupTemplate routine. |
...
Parameter name | Type | Required | Description |
|---|---|---|---|
sheetName | string | Yes | The worksheet name. The worksheet should exist in the template file, otherwise an exception will be thrown. |
| headers | string [] | Yes | This parameter controls the names of the column headers for the data written in the Excel sheet. If empty, the first line already found in the current sheet will be left unmodified. |
| columnTypes | number [] | Yes | This parameter controls the types of each column for the data written in the Excel sheet. If empty, all columns will be written as text. The encodings are as follows:
|
| headerRowsNo | number | No | The number of rows of the already defined header (available since 1.5.4/1.6.4) |
Return type:
The returned value has no meaning.
...