How to create Datatable dynamically

I have one excel sheet as input, i want to read data from it and store it in datatables. Excel sheet can any number of sheets, it will change dynamically. i have to store each sheet data into a new datatable and the name of the datatable should be the sheet name. It will chnage dynamically depeding on the number of sheets and sheet names.

So how do i create a datatable in a dynamic way?Can anyone please help me out on this.

You can’t name datatables in Vb.Net, and therefore in UiPath as well. You can, however, create a dictionary with keys set to strings representing the sheet name and the values being datatables like this:

Processusvierge.zip (10,2 Ko)

2 Likes

Thanks a lot @Anthony_Humphries …i will go for this.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.