Dear UiPathers I have to go through an Excel spreedsheet and enter some numbers into a website and retrive the information from the website and paste it in another Excel spreedsheet. Below is an illustration of how the spreedsheet might look like. [image] After I read the cells and enter them on…

@nmjvk , In that case, Could you create index variables for both For Each Row In Datatable and For Each Activities. Let them be named as i & j. Then in the Write Cell Activity you could use the Below Expression in the Range Property and check if it works : Excel.Sheet("Ark1").Cell(UiPath.Excel.He…

How to write to the same Excel cells as the original Excel spreedsheet

Help Studio

nmjvk (Nmjvk) January 9, 2023, 9:13am 8

Nevermind, I got it working now. I forgot to re assign j to be -1 in the for each row in datatable.

Thank you for your help. I will accept your solution!

Have a great day forward

1 Like

Topic		Replies	Views
How to write a data to the excel columns which has two tables Help	2	720	January 31, 2020
How to write cell in the next row? Help studio	11	4564	March 8, 2023
How to write to next empty cell on excel? Studio datatable , excel , activities , question	6	4577	March 8, 2020
Write variable in excell and next in other cell .. so it won't overwrite Learning Hub datatable , excel	5	953	July 4, 2020
How to Iterate Cell in Excel? Help datatable , activities , studio	5	990	July 5, 2019

How to write to the same Excel cells as the original Excel spreedsheet

Related topics