Get data from cells or ranges in a spreadsheet
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | Not set | |
Sheet Name sheetName | string | Optional | Not set | |
Range range | string | Optional | Not set | |
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
Read CSV
Import data from a comma-separated values file
Read Excel Cell
Read the value from a specific cell in an Excel worksheet, or the formula behind it
Read Password-Protected Excel
Open an Excel file that needs a password and read it into a table
Add Row to Sheet
Add a row of values to the end of a sheet
Append Data to Sheet
Add many rows to the end of a sheet in one step. Use Add Row to Sheet for a single row
Apply Conditional Formatting
Add a rule that keeps highlighting cells as the data changes, rather than colouring the ones that match today