How to convert my .Net oledb code to XAML and import in UiPath

[Amol_Deshmukh]

I have vast data available in Excel file and want to perform various action on the same using UiPath, how I can achieve that without interruption - by splitting excel data in small parts say 20,000?

[beesheep (Eduardo Bernabe Sacahui Diaz)]

Yeah, Iike if you can split the data before processing in UiPath that´d be great, if not I would suggest to try reading the table and then using *select *

here is info about working with chunks.

UI Path very slow with huge Excel file

Hello, 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…

Here is a great example to use selects from @vvaidya
Filter Excel Table - #5 by vvaidya

let us know if this works for you.