Excel Writer
The Excel Writer component allows you to write data into an Excel file (.xlsx).
To use it, specify the columns first by using the Columns
input. Then add rows by using the Rows
input. When you are done adding rows, use the Release
input to write the Excel file.
If you have configured Split at row
to a number higher than 0
the file will be written each time the number of rows are equal to the configured value. To write the last lines, you need to trigger the Release
input.
Configuration
Inputs | Outputs
Use this input to create headers in the sheet. A valid input must be an object containing the columns
key (array). This array is populated with objects containing the header
and key
keys and accepts only the following types: null
, string
, number
, boolean
and Date
.
Example: The headers will be Name1 and Name2. You need to use the keys for the headers when adding rows.
{
"columns": [
{
"header": "Name1",
"key": "name1"
},
{
"header": "Name2",
"key": "name2"
}
]
}