How to write or append the data into the excel spreadsheet from one to another

 

There are some following steps to be follow as below:

Step 1: Launch the first excel file and read the data from it.

follow my previous blog on Read the data from Excel

Read the data from Excel Spreadsheet

Step 2: Launch the second excel file where data to be write or append

Step 3: Drag and drop the action "Get first free row on column from Excel worksheet" in that pass the arguments 

Excel instance as second excel file instance

and Column as A. 

this will produce the flow variable as %FirstFreeRowOnColumn%

Step 4: Use the loop action "For Each", in that pass the ExcelData (DataTable) extract from first excel file.

Step 5: The next action to use is "write to Excel worksheet" in that pass the values,

Excel instance as second excel file instance, 

Value to write as first row of data from first excel file, 

write mode select as on specific cell and column as A, B, C.... column where value to be written

and Row as passing the flow variable %FirstFreeRowOnColumn%

Note : Same action to be use "Write to Excel worksheet" for other next data value to write.

Step 6: Use the action "Increase variable" this is to be use for increment of the variable "%FirstFreeRowOnColumn%" at the end of the loop.

Step 7: Use the action "Close Excel" to close all the excel files.

Code Snip:


Post a Comment

0 Comments