Writing to the right in each column in excel

Help Forum
1

Looking to take data that we have, and writing in to the right of each column. B1,C1,D1 ETC.

2

Hi @brady.olson
Welcome to forum, could u please elaborate ur question well?

3

Example Excel
Example Excel1936×1048 119 KB

Yes of course, we are looking to populate each column with data that we have taken from another excel. Then write it to this excel that is in the picture. We want UI Path to be able to just continue moving to the right for each column to write the data.

4

Hi @brady.olson
U can try this appraoch

Read the excel (where u need to add the column) and store in dt1

Read the excel (from where u need to take the column values) and store in dt2

Now use add data column activity to add column which u need to add in dt1

Now use loop to iterate through each row of dt2 and add in required column of dt1

Try that apparoch

Regards,
Nived N

5

it sounds like data should be appended on existing excel by horizontaly move

in that case:

  • calculate from existing excel(where to write) the current last filled Column - OffsetLetter
  • calculate next OffsetLetterNext = OffsetLetter + 1
  • use it when writing data with write range within the range field like OffsetLetterNext & “1”
6

Thank you I will try both!

7

Thank you I will try both of these!

1 Like
8

Correct, looking to have the data appended on the existing excel that we already have. And adding it to the right of every column that we already have. What is written as your solution doesn’t a whole lot of sense. How do we get the OffsetLetter? For example, our last filled column is column B, then how do we get the offsetletter? I know that getting the next offset letter is just: OffsetLetter + 1.

Also, how do we exactly write the data when we are already writing that data to the excel shown above.

9

Correct, looking to have the data appended on the existing excel that we already have. And adding it to the right of every column that we already have. What is written as your solution doesn’t a whole lot of sense. I am also fairly new with UI Path. Is there any easier way to explain?
Also, how do we exactly write the data when we are already writing that data to the excel shown above.

10

grafik

Writing data we use write range
grafik

Then also it is recommended to use UiPath Academy for free for getting trained on the Basics