Appended range does not start at first column

Hi, I am new to UiPath and RPA. I am using append range within the process of copying excel sheet in multiple excel workbook to a template workbook. I am trying to append the data inside the excel sheet after copying to the specified template workbook sheet but the appended data does not start at first column.

Or will it be better if I append it after copying process is completed?


1 Like

Hi, can you share a screenshot of what should be the correct excel sheet?

try Check AddHeader

1 Like

Hi, you can use ā€œWrite Rangeā€ activity after all the copying is done and you can specify the exact cell where the data is to be written. Hope this helps!

1 Like

By definition ā€˜Append Rangeā€™ activity adds data starting from the end of the excel sheet.

What you can do:
If you are going to append in a loop you need to empty the datatable of already added rows (i.e. while appending in excel datatable should contain only new rows)
or you can append only once after the loop with full datatable.

1 Like

So in other wordsā€¦ I canā€™t use ā€˜Append Rangeā€™ activity if I have a customized template for Data Table as destination?

Hi, Iā€™ve attempted ā€˜Write Rangeā€™ activity but It seem to overwrite the data table while it is looping. Would appreciate if you have an example on how to write it under the data table while in the loop. Thank you

1 Like

Yes, write range does overwrite any pre-existing data. Please check these links to see if they solve your issue:

2 Likes

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