The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
ADAdministrator 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