XLS Writer
XLS Writer creates an Excel workbook (.xls format) with one sheet, named Sheet1, from the data it receives from the flow. The workbook comes out as a file you can pass to another component to send or save it.
When to use it
- Delivering in Excel a list the flow has prepared.
- Attaching to an email a sheet with data extracted by an agent.
Configuration
| Field | What it does |
|---|---|
| File Name (required) | The name of the file. The .xls extension is added if you leave it out. |
| File Content (required) | The data that makes up the file. Connect a list of data, a data item or a message. The first row holds the name of every field found and each item fills one row below it; a message goes in a text column. |
Output
File returns the Excel workbook as a file. Connect it to a component that sends or saves files.
Example
A distributor gives its team a list of orders in Excel:
- A data component prepares the list of the day’s orders.
- XLS Writer receives that list in File Content.
- The file is passed to a component that sends it to the team as an attachment.
Good practices
- Test the flow with an example and open the file before sending it to other people.
- If you need a simple table to open in Excel, Data to CSV turns a list of records into a CSV file.
Related components
- Data to CSV: turns a list of records into a CSV table.
- Excel: reads and writes data in Excel workbooks stored in OneDrive or SharePoint.