I am getting the following error when trying to read a very large excel file…
RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0xE0434352
I need to read one sheet from the file, filter out certain data then write back to the same file. I will then need to append large amounts of data to the same sheet.
I have tried changing the excel package version with no luck. I am assuming it is because there is so much data. Does anyone have a solution to this?
I tried all the solutions in that thread you pinned. I am using excel application scope and it seems to be working. however, do I need excel installed in order to use application scope activities? The server this bot runs on does not have any applications installed on it.
The sheet I am working with has over 200,000 rows.