Append range

This is used to add more data into an existing Excel file. The data will be appended to the end.

  1. Drag and drop the Flowchart activity on the main Designer window. Also, drag and drop the Excel application scope inside the Flowchart activity. Connect it to the Start node.

The Append Range activity requires a data table. In this program, we are going to use another sample Excel file, which has some raw data. Then, we will read this Excel file and append the data to another Excel file.

First, we have to read its contents:

  1. Drag and drop the Read Range activity inside the Excel application scope activity. The Read Range activity produces a data table. We have to receive this data table in order to consume it. Create a data table variable and specify it in the Output property of the Read Range activity:
  1. Drag and drop the Append Range activity inside the Excel application scope activity. Specify the Excel file path in the Append Range activity (in which we want to append the data). Also, specify the data table (which is generated by the Read Range activity):

That's it. Press F5 to see the result:

 

We can clearly see that the data has been appended successfully to the Excel sheet.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.224.33.107