Read Excel to Dataset Activity
The Read Excel to Dataset activity processes a specified Excel file, converting its data into a structured dataset. This enables subsequent manipulation and analysis of the Excel content within the automation workflow.
| Field | Description | Requirement |
|---|---|---|
| Excel Name | The reference name of an already opened or created Excel file. | Required |
| New Dataset Name | The unique reference name assigned to the dataset created by this activity. | Required |
| Sheet Name | The name of the specific sheet within the Excel file to process. If left blank, the first sheet is processed by default. | Optional |
| Range | The specific range of cells (e.g., A1:C5) within the sheet from which to retrieve data. | Optional |
| Has Header | Indicates whether the first row of the selected range contains column headings. Set to true if headers are present. | Optional |
| Include Formatted Text | If true, formatted text from Excel cells is extracted and included in an additional column within the dataset. | Optional |
Action Types & Examples
Dataset Output
- Format:
Dataset object - Example Result:
newDataset
Implementation Examples
Field Setup - Excel Name: ${newExcel} - New Dataset Name: newDataset - Sheet Name: Sheet1 - Range: A1:C5 - Has Header: true - Include Formatted Text: true
Execution Parameters
Technical Notes
Ensure the specified Excel file is not open or locked by another process during execution to prevent access errors. For large Excel files, consider optimizing the range or processing in chunks to manage memory usage effectively.