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

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
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.

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,

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

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