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.