Excel Data
The Excel output node appends the selected variables as a row to an Excel workbook (.xlsx). It is the CSV output
with a spreadsheet as its file, see CSV Data for the selection of folder, file name and variables.
Configuration​
- Select the folder and enter a file name that ends in
.xlsx, e.g.orders.xlsx. The format follows the ending: with.csvthe same node writes a CSV file. - Enter the sheet to append to. It is created if it does not exist; empty means the first sheet.
- Select the variables that become columns, and the names of the columns.
How a row is written​
- The first row of the sheet is the header. A new workbook or sheet gets the column names as its header.
- A value is put into the column of the same name, not the same position. You may move columns around in Excel, the next row still lands in the right one.
- A name the header does not have becomes a new column at the right; older rows stay empty there.
- A column that has no value in this row stays empty.
- Every value is written as text:
007keeps its zeros, a phone number stays as it is, and a text starting with=is not run as a formula.
Limits​
- Appending reads and writes the whole workbook, because the file format has no append. A workbook larger than 20 MB is not appended to (the node takes the activity error edge). Use a CSV file for a log that grows without end.
- Rows that arrive at the same time are written one after the other.
- A file that is not a workbook (for example a CSV file that was renamed) is never overwritten: the node takes the activity error edge, and the application log names the file.
- The old
.xlsformat and.xlsm(macros) are not written as a workbook: with these endings the node writes CSV text. Use.xlsx. - Sheet names have at most 31 characters and none of
: \ / ? * [ ].
Reading it again​
A workflow with an Excel input and follow switched on wakes when this node appended a row. Together they form a pipeline between two workflows.