Essential XlsIO supports exporting data from worksheet to data tables and CLR objects including DataTable and DynamicObjects. Different exporting options for exporting data to DataTable called are also supported in XlsIO facilitating customized import.
Steps to export data from an Excel file to DataTable programmatically:
By executing the program, you will get the DataTable as follows.
Know more about Essential XlsIO through the , where you can find supported features like and in DataTable, appending multiple records to worksheet using , exporting worksheet into with respective code examples.
Starting with v16.2.0.x, if you reference Syncfusion assemblies from trial setup or from the NuGet feed, include a license key in your projects. Refer to to learn about generating and registering Syncfusion license key in your application to use the components without trail message.
This page will automatically be redirected to the sign-in page in 10 seconds.