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?
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!
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.
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
