EXCEL Writer Task
Write XLS Task create a writer for a new Excel file. Once created, multiple calls to any writers using this file will append rows to specified sheet.
Output file path
Output file path is the complete path where the XLS file resulting from this task will be saved.
Note: If the file already exist, the file will be overwritten.
Sheet name
Enter a headline to your new sheet. All data are written in this form.
Headers
The first rows of your sheet are defined like headers. You need to enter a name in headers.
Rows
Enter your data like a list of values representing a row.
Close on end task
This parameter will flush and close writer.
Trigger OK Port
select "Always" or "On close".