Job stopped with an unexpected exit code: 0xE0434352 When writing large excel file

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.

Hello @kasey.betts
Try this
1.Read using read CSV activity and save the result as DT,
2.Use write range activity of workbook and pass the DT, check the add headers in properties

Reading is not the problem. I can read the Excel workbook using a custom activity for large workbooks. I am getting the error when writing the updated DT to excel. I have tried write range and append range activities and get the same error