Add a row and a column After the last row and last column

Hi All,

I Have Multiple Excel Files. In this, I want to add a column and a row after the last column and last row. In every file the range is dynamic.

Thanks & Regards,
Om Prasad

Hello @omprasad,

You can first fetch the row count using counter variable inside for each then you can use insert row.
And Same for column.

3 Likes

Hi @omprasad

You can do a read range on those excel sheets and get the data to a datatable. Now add a column to the datatable using add datatable column activity. You can also add rows to the same datatable using add data row activity without looping.

Once you do, write the data back to the excel sheet using write range.

Its much faster and efficient too

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.