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. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Exporting Grid Grouping Control to Excel

Thread ID:

Created:

Updated:

Platform:

Replies:

71585 Feb 6,2008 03:49 PM UTC Feb 7,2008 03:05 PM UTC WinForms 1
loading
Tags: GridControl
Bill Langlais
Asked On February 6, 2008 03:49 PM UTC

I am trying to figure out how to export a Grid Grouping Control to excel in Syncfusion 5.1. I have searched around the forums and what I find seems to be based on version 6.0. Is it possible to export the data to Excel in Version 5.0 and if so how?

Thanks

Bill Langlais


haneefm [Syncfusion]
Replied On February 7, 2008 03:05 PM UTC

Hi Bill,

The Excel export browser sample demonstrates the conversion of contents in a GridGroupingControl to an xls file. The Exporting of a GridGroupingControl has two options: one converts the entire contents in the grid while the other converts only the visible contents in the grid.

XlsIO libraries are used to convert the grid contents to excel. The dlls that these depend on are Syncfusion.XlsIO.Base and Syncfusion.GridConverter.Windows.

Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl converter = new
Syncfusion.GroupingGridExcelConverter.GroupingGridExcelConverterControl();
converter.GroupingGridToExcel(this.gridGroupingControl1,
saveFileDialog.FileName,Syncfusion.GridExcelConverter.ConverterOptions.Default);

The above code converts the entire contents in the grid. The code to export the visible or expanded records or groups alone is given below.

converter.GroupingGridToExcel(this.gridGroupingControl1, saveFileDialog.FileName,
Syncfusion.GridExcelConverter.ConverterOptions.Visible);

Here is a path.
[instal drive]\Syncfusion\Essential Studio\[Version]\Windows\Grid.Grouping.Windows\Samples\Serialization\Excel Export

Sample : Excel Export.zip

Best Regards,
Haneef


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.

Warning Icon 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.Close Icon

;