I hope it helps you to analyze this problem.
I found a solution.
If you enter an empty range in Read Range Activity, then it works. Otherwise error occurs.
(in both cases I used the same sheet with over 11000 lines and columns from A to U)
Could you try updating your Excel activity package in case it is not the latest version?
Annoyingly this fixed my issue too. The file type I was reading was an XLS so I’m not sure if it was actually having an issue of trying to convert to XML etc. But thanks @aaydin as this is me sorted!
Did you get any updates to this? I’m also receiving this error inconsistently with the same source file.
UiPath v2020.4.1 (but there is a planned upgrade to v2020.10 later this month)
Excel Package 2.9.5
Excel sheet has 109K rows, but the Read Range of the sheet with “” is successful, but when I use Read Range with “A1:B”+lastrow (variable lastrow set via Assign), the activity errors with unexpected exit code 0xE0434352.
I’ve tried to add in a delay of 15 seconds thinking that if it was memory related, it might clear but that was inconsistently successful.
EDIT: @aaydin Thank you for your suggestion above. Based on what you provided, I removed the Read Range “A1:B”+lastrow that was giving me the issue and instead filtered the data table provided by my Read Range “” to remove the blank rows.
Hope you get the Solution, i hope you have tried several points like delays and all, So here i have few suggestions as well i mentioned below:
- First kill excel in your code using kill excel activity - “/im excel.exe /f”
2)Avoid reading excel with empty range means in “Read Range Activity” must pass any range e.g. if suppose you think that data might be “A1:M800” most of the time then try to use “A1:M10000” and the remove empty rows using data table filter
- Kill the excel again , Use the data from data table.
I am pretty much sure it will work!!
So, in case somebody comes here, and none of the other options works for him/her, let me share what worked for me since I was having the same issue:
- I think my problem was related to the fact that all those read and write activities where inside a an invoked workflow, inside a Loop. At every second iteration of the loop, the function would throw this unexpected error. The thing that worked for me was to set the Invoke workflow as Isolated. Simple but it worked. Why it worked… Only the wind knows… (Or Vb.NET developer I guess…).
If somebody is doing these reads and writes of huge excel sheets inside a loop, and facing this issue, give it a try. Please, also check what are the consequences of invoking a workflow in isolation mode in the UiPath Documentation.
Hi, in my case I had a lost cell with some special information. I deleted all rows to assure that everything apart what I want was empty and it works.
I tried empty range with a smaller dataset still I am getting the error
can you share here a screenshot of your read range activity?
Any one with some other info around this. It is a show stopper for me and I don’t like it.
Hi @vikashkumarvivek00 : I am facing the same issue. Your issue is still persists or resolved?
I have also updated all the packages related to my project but same issue persists. I have loaded an excel file of 20500 records in it and my UiPath process is creating two new columns in the same loaded excel file and calculating the column.
The following error received:
Message: Job Stopped with an Unexpected exit code 0xE0434352
Exception Type: System.Exception
I dint find any proper fix for this issue.
Thanks @kiran_bandaru1 : No problem. Thanks,
I added the extra large excel dependency and it worked for me without removing my large range.(my Excel sheets have over 50,000 lines of data)
dependency name: UiPathTeam.XLExcel.Activities
Hi @Theresa: Welcome to join UiPath community. I am also facing the same issue handling the 205K rows of excel. Pl find below the screenshot and apprise me that am I using XL Excel Activities correctly or not?
Hi! Please show me a screenshot of your dependency list. You can update your dependencies by clicking on Manage Packages. They will look similar to this:
@Theresa : Thanks a lot for your help.
Thank you @Theresa
I was also getting the below error when trying to create folders via Framework
RemoteException wrapping System.Exception: Job stopped with an unexpected exit code: 0xE0434352
I updated the UiPath.System.Activities package as per the below screenshot which resolve the issue
Hi @Theresa : Pl. find below the screenshot of the scenario I ran on excel file of 224 Columns and 205K rows . It took 10 minutes to come up with an error while writing the data into the same reading file of 224 columns:
I ran this file of 224 columns with 10,000 Rows, It perfectly works fine but when I ran on 205K rows terminates with an error exit code as mentioned in the screenshot.
try and update all the dependencies and try again