Is there a limit on the number of records within a datatable using the excel write range activity? I have about 30K rows of 1 datatable and it exports perfectly by my datatable with 160K records kills the robot every time. Ps. I am using the Excel Application Scope activity.
Try using Database activities by importing that excel file as a database.
What kind of exception is it giving… Out of memory? Or the bot just stops? Please give more details.
If you have 160k records its better to use database queries, rather than moving around such a big chunk of data around.