Definition and Usage
This Read from Excel worksheet command is used to read content from an Excel sheet. After reading the content and saving it as a variable, the variable can then be used for other automated steps.
Note: A Read from Excel worksheet command must to used with a Launch Excel command.
Parameters Values
Set parameters
Parameter | Description |
Excel object | Select an Excel object. |
Read from | Specify to read from cell/ row/ column/ range. |
Row number | Specify the row of the target cell. Enter a non-zero integer or a letter. 1 means the first row and -1 means the last row. |
Column number | Specify the column of the target cell. Enter a non-zero integer or a letter. 1 means the first column and -1 means the last column. |
Sheet name (optional) | Enter the name of the worksheet. If empty, the current active sheet will be selected. |
Save data as | Save data as a variable. |
Error handling
Parameter | Description |
When error occurs | Specify the action to proceed when an error occurs. |
Example
This workflow will open the Task.xls file, read the content of cell A1 from SheetA in the excel file and save the content as a variable.