Read Excel file into Dataset

I am trying to read an excel file into a dataset. Is there a straight way (a function) to do it? Or should I be doing it reading the file row to row? Thanks, Phani

1 Reply

AD Administrator Syncfusion Team March 16, 2006 11:06 AM UTC

Hi Phani, There is a built in function [IWorksheet.ExportDataTable] which would export the worksheet into a DataTable. Please refer to this sample C:\Program Files\Syncfusion\Essential Studio\4.1.0.50\Windows\XlsIO.Windows\Samples\Manipulating Data\ImportExportDataTable Best regards, Stephen. >I am trying to read an excel file into a dataset. Is there a straight way (a function) to do it? Or should I be doing it reading the file row to row? > >Thanks, >Phani

Loader.
Up arrow icon