We have an existing Excel file and we are going to use it in our project:
- Drag and drop the Flowchart activity on the main Designer window. Also, drag and drop the Excel application scope inside the Flowchart.
- Double-click on the Excel application scope. You have to specify the path of your workbook/Excel file. Drag and drop the Read Range activity from the Activities panel inside the Excel application scope.
The Read Range activity will read the entire Excel sheet. We also have the option of specifying our range. Create a variable of type data table and specify it in the Output property of the Read Range activity. This variable will receive the data table produced by the Read Range activity:
- Drag and drop the Output Data Table activity inside the Excel application scope activity. Now, we have to specify two properties of the Output Data Table activity: the Data Table property and the text property. The Data Table property of the Output Data Table activity is used to convert the Data Table into string format.
The text property is used to supply its value in a string format. We have to receive this value in order to consume it. For this, let us create a variable of type string. Give it a meaningful name:
- Drag and drop a Message box activity inside the Excel application scope activity. Also, specify the string variable's name that we created earlier inside the Message box activity.
That's it. Press F5 to see the result. A window displaying the Excel file data will pop up.