I have large macro enabled excel of size 70 MB and I wanted to perform below actions on it -
- Delete all rows from existing sheet
- Paste new fresh data in same sheet
- Save and close excel
When uipath try to save excel in excel scope application it takes lot of time(more than 1 hours) just to save and close file. I tried many things to perform above steps using macros and uipath activities like delete range and save workbook, excel as database etc. But I couldn’t get any perfect solution to optimise excel save and close time.
Kindly help me how can I work with such large amount of data and large excel size with uipath.
Thanks in advance.