All you need to do in order to To write data to a file is toperform the following actions:
...
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 some certain employees, their age and their salary. Below are the execution Execution script and the parameter script for such an example .are represented below:
| Code Block |
|---|
|
include "SER/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 |
|---|
| title | paramScriptparams.sil |
|---|
|
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"); |