I need to write a very large data table to excel, 260k rows. I cannot use Excel application scope as the server bot will run from cannot have excel installed.
Things I have tried:
- writing to CSV then converting to xlsx (this causes the file to get corrupted and then I cannot open it)
- writing the data in chunks to excel workbook (I still get the error Job stopped with an unexpected exit code: 0xE0434352)
Does anyone have any other suggestions on what I can try?
I need the file in xlsx format as it needs to be uploaded to a location that only allows that format.