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

Help Studio
, ,
1

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.

2

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

3

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

4

Hi, did you solve this problem? Now i m facing the same situation and i couldn’t figure out