Paste Excel Data from one while to column B in another file

Help Activities
, ,
1

Hi all,

I would like to paste data from one excel file to another. Two conditions have to be fulfilled.

  1. Data already existing should not be overwritten. Therfore I will use the “Append Range” activity
  2. 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
2

Hello Leon.

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.

3

Hi @lo86

Welcome to the community

can you share the sample data so that it was more clear to help you