All you need to do in order to To write data to a file is toperform the following actions:
- set up the template using reporting_setupTemplate routine
- set up the template's sheets using reporting_setupSheet routine
- add the data to the coresponding sheet using reporting_addData routine
- write the data added to a temporary file using reporting_writeWorkbook routine
- return the file created
- set up the template using reporting_setupTemplate routine
...
The file above can be included into another SIL files by using this syntax:
| Code Block |
|---|
include "SER_funcs.incl"; |
An easy example using this file would be one that returns certain employees, their age and their salary. Execution script and the parameter script for such an example are represented below:
| Code Block | ||
|---|---|---|
| ||
include "SER_funcs.incl";
string templateFile = gadget_getSingleValue(argv, "Template file");
string sheetName = gadget_getSingleValue(argv, "Sheet name");
date startDate = gadget_getDateValue(argv, "Start Date");
//setting up headers and column types
string[] headers = {"Name", "Position", "Age", "Wage"};
number[] columnTypes = {0, 0, 1, 1};
string[] data = {"John Doe", "Developer", "30", "1300.50",
"Paul Smith", "Project Manager", "41", "2500.00",
"Simon Desharnais", "Tester", "35", "900.20"};
SheetProp sheetProp;
sheetProp.sheet = sheetName;
sheetProp.heading = headers;
sheetProp.data = data;
sheetProp.dataTypes = columnTypes;
return ser_writeDataInExcel(templateFile, true, {sheetProp}); |
| Code Block | ||
|---|---|---|
| ||
gadget_createInput("Template file", "template.xlsx", true, "Excel template file");
gadget_createInput("Sheet name", "Data", true, "Data Worksheet name in the template file");
gadget_createDatePicker("Start Date", currentDate(), true, "Choose a start date"); |