Exporting dataset to excel file

[Nipun Tamrakar]

Hello i am looking for a way to directly export a dataset or a table to an excel file.
I would really appreciate if anybody could tell me how i can export data of xml file to excel file directly.

Thank you

[Melba Winshia]

Hi Nipun,

Thanks for your interest in Syncfusion Essential XlsIO.

1)You can directly export a dataset or a table to an excel file by using ImportDataTable method. Here is the sample for your reference:

XlsIODataSet.zip

2) Please refer the following sample to export data of xml file to excel file directly.

XML.zip

Please take a look at the sample above and let me know if you have any other questions.

Regards,
Melba

[Nipun Tamrakar]

Thanks a lot Melba
Thats exactly what i was looking for.

Thank you
Nipun

[Melba Winshia]

Hi Nipun,

Thanks for the update.

Glad to know that it helps you!

Please let me know if you have any other queries.

Regards,
Melba

[Sridhar]

Hi Gontrand,

Thank you for using syncfusion products.

Please go through the online sample link for exporting the data table to an excel file by using ImportDataTable method.

http://asp.syncfusion.com/sfaspnetsamplebrowser/10.1.0.44/Web/XlsIO.Web/samples/4.0/Data%20Binding/ImportExportDataTable/CS/ImportExportDataTable.aspx

Please go through the following code snippet for exporting the XML data to an excel file by using ImportDataTable method.

Code Snippet [C#]:

private DataTable northwindDt;

//Load Data
DataSet customersDataSet = new DataSet();
customersDataSet.ReadXml(ResolveApplicationDataPath("customers.xml"), XmlReadMode.ReadSchema);
northwindDt = customersDataSet.Tables[0];

//Import method
sheet.ImportDataTable(northwindDt, true, 3, 1, -1, -1);

Please try know the above code snippet at your side and let us know if this helps you.

Please let us know if you require any further clarifications.

Regards,
Sridhar.S