How to update the status row by row in excel

Learning & Development Programs Automation Starter
1

Hi all,

Facing difficulty in updating the excel. If row1 is processed column status thats needs to be updated as “Downloaded”.
Assign: Exception has been thrown by the target of an invocation.
What changes i need to do.
Column status is present in excel.

Thanks & Regards,
Lakshmi

1 Like
2

Hey,
please let me know are you using Reframework or Normally you can using?
Thanks

3

Hi,
Normally using not using re framework.
Thanks,
Lakshmi

4

you can use Use write cell Activity
and write cell and follow this

image
image816×332 14.4 KB

In write cell
in cell you can write
“A”+(counter+2).tostring

Thanks

5

The error is returned likely due to your variable not having a value or is different from the expectated value.

Could you elaborate on the process? Perhaps send a screenshot or two.

6

hi @Mads_Commerou
image
Status column needs to be updated as “Downloaded”, after processing of each row that row needs to be updated as “Downloaded”.
I tried above write cell that is also giving blank data not updating.

Thanks,
lakshmi

7

Hi,
Please show me the workflow (Property)of write cell and for each row
thanks,
Rounak

8

Hi,
image

9

in For each row Activity
Make a counter like that

image
image820×297 16 KB

then put in write cell activity
“FZ”+(Counter+2).tostring
I think your column is FZ
Try it

Thanks

10

Hey,
Please let me know,
Is it working or not as you expected
Thanks

11

Hi @Rounak_Kumar1 ,

ok.
I will try and post here. Now i lost connection on my system.
Thanks a lot.

Regards,
Lakshmi

12

Hi @Rounak_Kumar1 ,

Its writing “downloaded”.
If error occured in between “downloaded” is not writing.
Say 10 records are there in 5th record occured no data stored in excel.
image
What changes i need to do.
Thanks,
Lakshmi

13

Keep In try catch activity and and In Catch block You can keep Write cell Activity as same and you can write "No data Available ". So it will update

Thanks

14

Hi,
image
Above this i’ve if activity to downloaded the file. Error occured and data not written blank.

Thanks,
Lakshmi

15

Do one thing Don’t use try catch
Use IF else condition in For each row
You have to give condition like If there is data then write cell(downloaded") else Write cell( “No Data”).
I think it will work
Thanks

16

@Rounak_Kumar1 ,

image
image1054×83 5.54 KB

this is my sample file if 211500 is processing and Status is downloaded, for next row in between system hanged or error ocured in that time the status column is blank through out.
I think i can’t give if condition.
Thanks,
Lakshmi

17

then In for each row you can keep Try catch activity and In Try Block you keep write cell(“downloaded”) and in Catch Block keep
write cell(“Error Occured”). Now it will work. you have to just copy that write cell and keep in Catch Block
and Let me know

Thanks,
Rounak

18

image
Is this correct Exception i have given exception
Regards,
lakshmi

19

Not Like that
Follow this workflow
Main.xaml (7.3 KB)
Thanks

1 Like
20

Have you got the Expected output
Please accept the solution,
Thanks