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. ...