I would like to paste data from one excel file to another. Two conditions have to be fulfilled.
- Data already existing should not be overwritten. Therfore I will use the “Append Range” activity
- The Data pasted into the excel file should not be filled in column A-C, instead to B-D. Means it should start in column B. I do not know how to solve this.
Completely new to UiPath
For this case you can first read the target excel file (where you are going to paste the copied values) then find the row count(dt.rows.count) into a count variable, then for paste the values using write range activity by mentioning the cells like(“B”(count+2).ToString).
Hope you got my logic.
Welcome to the community
can you share the sample data so that it was more clear to help you