Open Excel file as DataReader

Provides a DataReader for reading a forward-only stream of rows from an Excel sheet.

Properties

Name	Type	Description
Title	Optional	The title of the action.
File contents	Required	The contents of the file, provided as either a stream or a byte array.
Sheet name	Optional	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	Optional	The row number of the first row to read. If the worksheet has a header row, `Data start row` is typically `2`
Column mapping	Required	Defines the mapping between Excel column letters and business object property names.
Reader variable name	Optional	The name of the variable you can use to reference the DataReader in other actions.

Columns can be mapped automatically by using the "Map from sample file" option.

This video shows how to export data to an Excel file, and send it as an email attachment using Microsoft 365 Outlook.