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

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?

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.

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

let us know if this works for you.

1 Like