I’m working with Excel and i found that with huge excel files (more than 200k lines) the whole process is very very slow as UI Path is saving the Excel file after each modification. Is there any solution to speedup the save process ? Save the file after writing X cells ?
If we can’t do much to speedup the process, i had an idea to write to a text file then save it once at the end of the process. I have no problem to append text to a text file but, i also would like to read a Excel range paste it into the text file and ADD more text at the end of the line.
How to do this ? I was able to write the text just below my pasted range but not beside.
Any idea ?