File operation with step-by-step example

In this module, we are going to operate on Excel file. The following are the methods that are frequently used with an Excel file:

• Read cell
• Write cell
• Read range
• Write range
• Append range

Once you get familiar with these methods, it will become very easy for you to use other methods too.

Read cell

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:

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

Note

It is a good practice to use the Excel application scope when using Excel activities inside our project.

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