Read the value from a specific cell in an Excel worksheet, or the formula behind it
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Sheet Name sheetName | string | Optional | — | — |
Cell cell | string | Required | — | — |
Read the Formula, Not the Answer readFormula | boolean | Optional | false | Gives back =SUM(B1:B9) rather than 42. Empty for a cell holding a plain value |
Output Variable outputVariable | variable | Optional | CellValue | — |
Output
CellValueStringValue from the cell
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Read CSV
Import data from a comma-separated values file
Read Excel
Get data from cells or ranges in a spreadsheet
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