Automation Action: Lookup From Excel
Lookup specific cell and cell range values from an Excel file and assign to variables.
Read specific cell and cell range values from an Excel compatible spreadsheet file and assign returned values to multiple ThinkAutomation variables.
Enter or select the Excel File Name to read.
In the Cell Assignments grid you can list one or more Cell References to read from the Excel file. For each you can specify the Worksheet. If the Worksheet is blank then the first worksheet will be used. In the Assign To column specify the ThinkAutomation variable to receive the value of the specified cell reference.
Cell References can be a single cell (eg: B12), a cell range or a Named Range/Named Cell. In Excel you can define a Name for a range or cell so that if rows/columns are inserted before it, the 'Name' still references the existing cells even though their row/column references may have changed. This is useful if you need to read a total cell where new rows are added regularly.
|Cell Reference Example|
|B12||Returns the single cell value for cell B12.|
|A1:C3||Range that includes cells from top-left cell A1 to the bottom-right cell C3.|
|A:A||Range that includes the entire column A.|
|A:C||Range that includes the entire columns from A to C.|
|1:1||Range that includes the entire row 1.|
|1:3||Range that includes the entire rows from 1 to 3.|
When a cell reference is specified that returns multiple cells, the data will be returned as CSV text, with the number of rows and columns depending on the selected range (without column headers).