Shapes

Files and EDI

Create Excel

Builds an Excel workbook from all records, ready to attach or upload.

Nodes › FilesOpen in Neblex
Good for
Spreadsheet reports
Role
Works on the records in a flow
Find it in
Nodes › Files

When to use it

  • Business users want a spreadsheet.
  • A partner exchange requires .xlsx files.

Reach for something else when

Create fileWhen CSV, JSON or text is enough.

Example

Every Monday, export last week's orders to a workbook and email it to finance.

  1. Schedule
  2. Postgres
  3. Create Excel
  4. Gmail

How it works

Settings
Worksheet name [Sheet1]; File name [export.xlsx], placeholders allowed.
Output
One record {filename, contentType, rows, columns, bytes, contentBase64}, ready for an email attachment or file upload step.
More in the guide

Add it to a flow

  1. Open the flow from Build › Workflows.
  2. Open Nodes and find Create Excel under Files, or search for it. Click it or drag it onto the canvas.
  3. Drag from the previous step's output handle to its input, then open its settings with ✎ Edit.
  4. Run the flow and click the step to see the records it received and produced.

More in Files and EDI

Create fileBuilds one CSV, JSON or text file from all records.Nodes › FilesRead fileReads a CSV, JSON or text file carried on a record back into records.Nodes › FilesRead EDIReads ANSI X12 or UN/EDIFACT documents into a structure you can map.Nodes › FilesBuild EDIBuilds EDI text from a structure, ready to send to a partner.Nodes › FilesValidate EDIChecks an EDI document's envelope and required business segments.Nodes › FilesAcknowledge EDIBuilds the functional acknowledgment (997, 999 or CONTRL) to send back to the partner.Nodes › Files