Write Range Error in For Loop

[balaji.nama]

Hi Team,

I am building a code where a datatable which is an output of a filter data table activity is used within a for each row to write in an excel sheet using write range. However, after all the iterations of write range it fails “Failed setting the current sheet” instead of moving into next activity.

Regards,
Balaji Nama

[Uthraa]

Hi Balaji ,
Could you please send screenshot of the flow/error.

Thanks,
Uthraa

[balaji.nama]

For each runs through the datatable and writes 18 sheets as expected but after the last interaction it doesn’t move to next activity continues to open another sheet and since there is no data fails.

Workflow

Error received