Output
Export Excel
Writes the incoming rows to an Excel .xlsx file in a folder you choose and passes the rows on unchanged.
When to use it
Use it when someone will open the result in Excel and you want a real workbook rather than a CSV.
In a pipeline
SQL Server DatabaseFilter RowsExport Excel
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| File Name (without extension) | text | Yes | export |
| Output Directory | text | Yes | Server folder, e.g. exports (inside your workspace or an allowed folder) |
Example
Weekly report as a workbook
- File Name (without extension)=weekly_report
- Output Directory=exports/reports
| Region | Orders | Revenue |
|---|---|---|
| North | 12 | 4300 |
| South | 7 | 2150 |
| Region | Orders | Revenue |
|---|---|---|
| North | 12 | 4300 |
| South | 7 | 2150 |
The workbook holds a single worksheet named Data, with the column names in the first row.
Worth knowing
- There are no delimiter or encoding options here, because the format handles both itself.
- Numbers stay numbers in the sheet, so totals and charts in Excel work without re-typing values.
- Columns whose names start with two underscores are internal and are left out.