Get data from cells or ranges in a spreadsheet
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | — |
Range range | string | Optional | — | — |
First Row as Headers hasHeaders | boolean | Optional | true | — |
Output Variable outputVariable | variable | Optional | ExcelData | — |
Output
ExcelDataDataTableData read from Excel worksheet
RowsArrayColumnsArrayRowCountNumber
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Auto Fill Range
Fill a source cell's formula or value across a range, adjusting relative references like dragging the Excel fill handle. Absolute references (with $) stay pinned.
Close Excel Workbook
Save and close the Excel file
Convert Excel to PDF
Export the workbook (or a single sheet) to PDF, preserving layout, charts, and conditional formatting.
Create New Excel WorkSheet
Add a new blank sheet to the workbook
Create Pivot Table
Create a summary table to analyze data
Delete Excel WorkSheet
Remove a sheet from an Excel workbook