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

let us know if this works for you.