Skip to main content

Excel Data

The Excel input node reads the rows of an Excel workbook (.xlsx) into the variables of your workflow, one row each time the node is entered. It is the CSV input with a spreadsheet as its file: everything about Available variables, the data identifier and the decisions next and end reached works the same way, see CSV Data.

Configuration​

  1. Select the file, a workbook in your file storage.
  2. Enter the sheet if the data is not on the first sheet. The name is not case sensitive.
  3. Select the columns that become variables. The first row of the sheet is the header, it names the columns.

What to know​

  • Values arrive as text, as Excel shows them: a date is the formatted date, a number the formatted number.
  • Rows without any value are skipped.
  • Only the .xlsx format is supported, not the old .xls.
  • With follow switched on the node waits at the end for more rows, like tail -f for a CSV file. Together with the Excel output of another workflow this makes a pipeline.