Parse Excel

[krumal]

Hi.

What is the best practice for export excel datum to something Collection c#? 

Thanks.

[Kesavan D]

Hi Krumal, 

  

Thank you for contacting Syncfusion support. 

XlsIO has support to export worksheet data to a data table in ASP.NET & ASP.NET MVC platforms. Whereas there is a support to import from collection (ImportData()) in ASP.NET Core and no support to export to a collection. 

Online sample links: 

ASP.NET               : http://asp.syncfusion.com/demos/reporting/xlsio/Data%20Binding/ImportExportDataTable/CS/ImportExportDataTable.aspx  

                                  http://asp.syncfusion.com/demos/web/xlsio/bussinessobjects.aspx  

Regards, 

Kesavan 

[Marco Cincotti]

I agree to the your privacy policy and terms of service

[Abirami Varadharajan]

Hi Marco, 

Currently, XlsIO doesn’t have support to export worksheet data to DataTable in ASP.NET Core platform. However, a new feature will be available to Export worksheet data to Business objects or collection in our upcoming release 16.1 which is expected to be rolled out in February 2018.  

  

This feature helps to populate the business objects or model collection from an Excel document very easily.  

Please refer below documentation to know more about exporting worksheet data to data table. 

https://help.syncfusion.com/file-formats/xlsio/working-with-data#exporting-from-worksheet-to-data-table  

The documentation on export to business objects will be available online after the release of 16.1. 

Regards, 

Abirami.