- English (United States)
Use the Read Cell activity to read the values in Excel cells. The Read Range activity reads the entire sheet data, while reading the value of a single cell is the Read Cell activity.
If the cell contains a function, the result is read, not the function that is read.
Suppose you have the following sheet. Let’s look at an example of reading the date in B2. In fact, B2 contains the functional expression “= TODAY()”.
1 Open Excel in the Excel Application Scope activity.
2 Place a Read Cell activity within the Excel Application Scope activity.
3 Set the properties of the Read Cell activity.
|Cell||Specify the cell address.|
|SheetName||Specify the sheet name.|
|Result|| Specify a variable to hold the read value.
The variable specified here specifies a variable of type Generic Value.
Robot execution result
What is displayed is the result of the function execution, not the function.