Append excel with collection

[ravikumarj023]

Hi,

Please help me out.

In my excel if there is some rows and in a collection there is some other rows and columns are same in the excel and collection so i want my collection to append the excel.

Example:

Input1:
View attachment 1582718751628.png

Input2:
View attachment 1582718874346.png



I want output to save in excel as below pic:

View attachment 1582718986300.png


Thanks

 

[naveedraza]

first get the number of rows from your existing file using the action "Get Number of Rows" from Excel VBO, next in "Write Collection" action input give the cell reference as "A" & the get number of rows output + 1 , next include column as False