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.

It is a good...