087654
December 22, 2018, 4:47pm
1
Hi there.
I’m trying to set …
read spreadsheet. (done with Read range)
copy B cell for which D column is blank.(done with Filter data table and Get row item)
paste B cell in another excel.(done with Write cell)
back to the spreadsheet and fill D cell with string “OK” where is the same row as I copy in 2. (can’t do with write cell because of Range error.)
Do it until the B cell is null or empty. (probably using assign and counter?)
I am stuck in 4 for a day… please help…
1 Like
Roboz
(Arun Kumar)
December 22, 2018, 5:57pm
2
Can be achieved by using dynamic variable (using counter) in the write cell (B + Variable) under for each loop.
megharajky
(Megharaj Yadravi)
December 23, 2018, 8:25am
3
Hello,
After reading the First excel, you have Datatable_FirstSheet
Now create an empty list L_B_CellValue
Noe for each row from DT_FirstSheet
check if D_CellValue is empty or not, if yes → add B_Value to list, and write D_Value OK (using write cell, as it is easy to trac the index here…)
Now write the list items to the new sheet.
(((* You can also try by creating the new data table with one column instead of list and write range to new sheet)))
Thanks,
Meg
087654
December 24, 2018, 1:40pm
4
Thank you @Roboz , @megharajky for your reply.
I referred the post below and tried to create new empty list but it didn’t work probably because my understanding was not enough.
The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide you in your automation journey in the UiPath ecosystem, from complex installation guides to quick tutorials, to practical business...
So, I searched again for a day and found another way in different way to solve this. It worked.
Hi - Within for loop use if condition and check [DataTableName].Rows.Count > 0 and do the operation to avoid this error
[image]
Thank you,
Nitesh
Thank you.
1 Like