For my process, I need to read lines from an excel file, filter it, then append it to another excel file.
However, the excel files I’m working with have >100,000 lines, which causes UiPath to crash when it gets to Read/Append Range.
I am trying to split the Read and Append activities into 20,000 line chunks to prevent crashing.
But when I split the Read Range, only the first Read Range will have the headers, subsequent Read Ranges won’t have headers.
Does anything have a good way to do this?
Could anybody shed some light if the reading excel in chunks could be done using UiPath or should it be done using custom code? If it could be done using Uipath, could you please share a sample workflow? Your help will be greatly appreciated.