How to update the status row by row in excel

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

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

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

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


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

Thanks

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.

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

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

Hi,
image

in For each row Activity
Make a counter like that


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

Thanks

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

Hi @Rounak_Kumar1 ,

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

Regards,
Lakshmi

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

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

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

Thanks,
Lakshmi

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

@Rounak_Kumar1 ,


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

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

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

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

1 Like

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