I have an excel file with 93K rows . I have to append this file with data from different sources.
Issues : while using Append Range / read Range -I am getting below error :
Tried : With and Without Excel application Scope - No Help
Tried the same Exel with .xlsb - No Help
Tried Updating Binding too … - No Help
However , I noticed that there are several blank rows after the data in the Excel… I tried manually deleting the blank rows - Append Range works Fine
Question : Instead of deleting the blank rows - is there any other approach i can use to fix the process termination exception.
If No, How can i Clear all the blank rows from excel ?
As of now - have achieved it by sending Hotkey go to last row : (ctrl + shift + end and delete key)
- The Data i am working is sensitive so, cannot share the excel …
- Office Version : 14.0.7227.5000 (32 Bit)
- Uipath version : 2018.3.2 Enterprise edition.