This is used to read the value of a cell from an Excel file. We have a sample Excel file that we will use in this example:
Suppose we have to read the value of the B3 cell:
- Drag and drop a Flowchart activity on the main Designer panel. Also, drag and drop an Excel application scope inside the Flowchart. Connect it to the Start node. Double click on Excel application scope.
It is a good practice to use the Excel application scope when using Excel activities inside our project.
- Drag and drop the Read Cell activity inside the Excel application scope activity. Specify the range value in the cell text box of the Read Cell activity. Create a variable of type string to hold the result produced by the Read Cell activity. In our case, we have created a Result variable. Specify the Output property of the Read Cell activity by providing the variable's name that we have created:
- Drag and drop a Message box activity inside the Excel application scope activity and specify the string variable's name (which we created earlier) in the expression box of the Message box activity.
That's it. Press F5 to see the result.