Create Excel file as byte array
Creates an Excel file from a DataTable or DataReader and serializes it as a byte array.
Properties
| Name | Type | Description |
|---|---|---|
| Title | Optional | The title of the action. |
| Source | Required | Specifies the source of the data, which can either be a DataTable or DataReader. |
| Sheet name | Optional | Specifies a worksheet name. |
| Column mapping | Optional | Defines the mapping between Excel column letters and business object property names. |
| Worksheet formatting options | Optional | Specifies detailed formatting options. |
| Byte array variable name | Optional | The name of the variable you can use to reference the byte array in other actions. |
| Description | Optional | Additional notes or comments about the action or configuration. |
Returns
Returns the Excel file serialized as a byte array
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.