I need to write a very large data table variable to an Excel spreadsheet. I cannot use excel application scope because I don’t have excel installed where the bot will be running from. When I use the workbook activity I get the error that the bot stopped unexpectedly. Most likely due to the size as I had the same issue with reading but was able to use the custom activity linked below to read.
I recommend you to write data table make chunks of it and then append in excel file
Here I am sharing a link where user are reading large number of data from excel through chunks
but its reverse will be helpful in your case.