what is different between datatable.import and datatable.importsheet?
If excel file has 7 sheets, if we use import method, then all the 7 sheets are imported into runtime datatable or not.
what is different between datatable.import and datatable.importsheet?
If excel file has 7 sheets, if we use import method, then all the 7 sheets are imported into runtime datatable or not.
DataTable.Import = Imports the specified Microsoft Excel file to the run-time Data Table.
DataTable.ImportSheet = Imports a sheet of a specified file to a specified sheet in the run-time Data Table. The data in the imported sheet replaces the data in the destination sheet
If excel file has 7 sheets, if we use import method, then all the 7 sheets are imported into the runtime datatable
You are right.
But when we are using datatable.import method, then first 2 sheets only imported into the runtime datatable. NOT ALL THE SHEETS.
hai Raj,
yes, for me while using Datatable.Import only first sheet value is getting imported.
Thanks
Deepa