Read Excel file into Dataset

[Phani Neelankantham]

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

[Administrator]

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