Write Range Activity not working for Large volume of Data

Hi All,
I am getting a system error when trying to write a large data Data table to excel using Write Range Activity. Especially if the file size will be around 22MB+ then write range is throwing system error. When I tried to reduce the data size then it works. But unfortunately I need the full data table in one file so that the aggregation can happen.

Can you please advise if any better solution to handle the large excel file?
Thanks,
Sarayu

Hi @sarayu

Which write range you are using , excel or workbook activitiy ?

Regards,

Nived N :robot:

Happy Automation :slight_smile::slight_smile:

Hi Nived,
I am using excel.

Thanks,
Sarayu

Hi @sarayu kindly check this one

Can u share the screenshot of that write range?

Hope it helps you

Nived N :robot:

Happy Automation :slight_smile:

2 Likes

Hi Nived,
I tried the write range in excel application scope as per the link provided by you and it seems working. I will test further with some larger file but time being it’s working fine with 22MB.
Thanks a lot for your quick help.
Regards,
Sarayu

1 Like

Hi @sarayu

So earlier u had used workbook write range activity?