We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Exporting dataset to excel file

Thread ID:

Created:

Updated:

Platform:

Replies:

56083 Feb 8,2007 11:39 PM Feb 2,2012 11:36 AM ASP.NET Web Forms (Classic) 5
loading
Tags: XlsIO
Nipun Tamrakar
Asked On February 8, 2007 11:39 PM

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 [Syncfusion]
Replied On February 9, 2007 04:43 AM

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
Replied On February 9, 2007 06:42 AM

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

Thank you
Nipun

Melba Winshia [Syncfusion]
Replied On February 10, 2007 05:04 AM

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


Johan GONTRAND
Replied On January 30, 2012 06:05 AM

Samples are unavailable...


Sridhar [Syncfusion]
Replied On February 2, 2012 11:36 AM

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


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;