How define Syncfusion.XlsIO Exporting from Worksheet to Data Table

[jeff]

Hi,

I try to use XlsIO export to Datatable in C#, How to define first row & column ?

Thanks

[Prakash Kumar D]

Hi jeff, 

 

Thank you for contacting Syncfusion support. 

 

You can export worksheets data into a DataTable with the specified row and column by using the following code snippet 

 

Code Snippet:  

 

 

sheet.ExportDataTable(1, 1, 10, 10, ExcelExportDataTableOptions.ColumnNames); 

 

To know more about this, kindly refer the ExportDataTable API reference link 

 

Regards, 

Prakash Kumar