Open Excel file as DataReader
Provides a DataReader for reading a forward-only stream of rows from an Excel sheet.
Properties
| Name | Required | Description |
|---|---|---|
| Title | No | The title of the action. |
| File contents | Yes | The contents of the file, provided as either a stream or a byte array. |
| Sheet name | No | The name of the sheet(s) from which to read data. If you don't specify anything, data is read from the first sheet in the file. When specifying multiple sheets, use a semicolon to separate sheet names. In the rare case that a sheet name contains a semicolon, use square brackets around the sheet name. |
| Data start row | No | The row number of the first row to read. If the worksheet has a header row, Data start row is typically 2 |
| Column mapping | Yes | Defines the mapping between Excel column letters and business object property names. |
| Reader variable name | No | The name of the variable you can use to reference the DataReader in other actions. |
Automatic column mapping
Columns can be mapped automatically by using the "Map from sample file" option.
Excel: Videos / Getting started
Send email with Microsoft 365 Outlook
This video shows how to export data to an Excel file, and send it as an email attachment using Microsoft 365 Outlook.