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.

How to Export data in excel from Group Data Grid

Thread ID:

Created:

Updated:

Platform:

Replies:

131833 Jul 29,2017 10:39 AM Aug 18,2017 12:45 AM Windows Forms 8
loading
Tags: GridGroupingControl
Deepak
Asked On July 29, 2017 10:39 AM

Hello
We are using Visual Studio 2008.during working we made use of GridGrouping Control but its not providing facility to export data in excel.

Arulpriya Ramalingam [Syncfusion]
Replied On July 31, 2017 06:46 AM

Hi Deepak,  
  
Thanks for your interest in Syncfusion products.  
  
The GridGroupingControl have the support to export the data from Grid to Excel and it can be achieved by using GroupingGridExcelConverter class. To avail this support , please ensure to add Syncfusion.GridConverter.Windows.dll in your project. Please make use of below UG link and sample,  
  
Code snippet  
  
  
GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl();  
// Export the contents of the Grid to Excel  
converter.GroupingGridToExcel(this.gridGroupingControl1, "Grid.xls", ConverterOptions.Visible);  
  
  
  
Dashboard sample link: <Install Location>\Syncfusion\EssentialStudio\<Product version>\Windows\Grid.Grouping.Windows\Samples\Exporting\Excel Export Demo\cs  

The GridGroupingControl have support to export the grid to PDF and Word also. Please refer to the below UG link and samples,  
  
  
Dashboard sample link: <Install Location>\Syncfusion\EssentialStudio\<Product version>\Windows\Grid.Grouping.Windows\Samples\Exporting  
  
Regards,  
Arulpriya  


Arulpriya Ramalingam [Syncfusion]
Replied On July 31, 2017 06:46 AM

Hi Deepak,  
  
Thanks for your interest in Syncfusion products.  
  
The GridGroupingControl have the support to export the data from Grid to Excel and it can be achieved by using GroupingGridExcelConverter class. To avail this support , please ensure to add Syncfusion.GridConverter.Windows.dll in your project. Please make use of below UG link and sample,  
  
Code snippet  
  
  
GroupingGridExcelConverterControl converter = new GroupingGridExcelConverterControl();  
// Export the contents of the Grid to Excel  
converter.GroupingGridToExcel(this.gridGroupingControl1, "Grid.xls", ConverterOptions.Visible);  
  
  
  
Dashboard sample link: <Install Location>\Syncfusion\EssentialStudio\<Product version>\Windows\Grid.Grouping.Windows\Samples\Exporting\Excel Export Demo\cs  

The GridGroupingControl have support to export the grid to PDF and Word also. Please refer to the below UG link and samples,  
  
  
Dashboard sample link: <Install Location>\Syncfusion\EssentialStudio\<Product version>\Windows\Grid.Grouping.Windows\Samples\Exporting  
  
Regards,  
Arulpriya  


Deepak
Replied On August 8, 2017 10:03 AM

First of all i would like to say thank you to give me positive response.i tried all these things but still problem in same.


Arulpriya Ramalingam [Syncfusion]
Replied On August 9, 2017 08:23 AM

Hi Deepak,     
   
Thanks for your update.   
   
We have analyzed your scenario, but unfortunately we were unable to reproduce the issue at our end. Please ensure that the Syncfusion.GridConverter.Windows.dll assembly and Syncfusion.GridConverter.Windows name space are included in your project. Please provide the below details that will help us to provide a proper solution at the earliest:  
  
  • The Syncfusion EssentialStudio product version.
  • Code customization of exporting which you have tried or if possible provide the simple sample with issue reproducible.
  • Details of exceptions/issue if any you faced.
   
Regards,   
Arulpriya   


Deepak
Replied On August 15, 2017 12:50 PM

Hi Deepak,     
   
Thanks for your update.   
   
We have analyzed your scenario, but unfortunately we were unable to reproduce the issue at our end. Please ensure that the Syncfusion.GridConverter.Windows.dll assembly and Syncfusion.GridConverter.Windows name space are included in your project. Please provide the below details that will help us to provide a proper solution at the earliest:  
  
  • The Syncfusion EssentialStudio product version.
  • Code customization of exporting which you have tried or if possible provide the simple sample with issue reproducible.
  • Details of exceptions/issue if any you faced.
   
Regards,   
Arulpriya   


1.The Syncfusion EssentialStudio product version is 14.4.0.15

2.Code customization of exporting which you have tried or if possible provide the simple sample with issue reproducible

Dim converter As New GroupingGridExcelConverterControl()

converter.ExportBorders = True

converter.ExportImage = True

converter.GroupingGridToExcel(Me.LSTFEEREGISTER, "FileName.xls", ConverterOptions.Default)

3.Details of exceptions/issue if any you faced

 GroupingGridExcelConverterControl() is not valid function


Arulpriya Ramalingam [Syncfusion]
Replied On August 16, 2017 11:58 AM

Hi Deepak, 
 
Thanks for your update. 
 
We have tried to reproduce the reported issue at our end. We suspect that the reported issue occurred due the assemblies are not referred properly. Please refer to the attached video and sample and confirm us that whether the issue occurred in the attached sample. 
 
Ensure to add the below details in your project. 
  • Syncfusion.GridConverter.Windows.dll, Syncfusion.XlsIO.Base.dll assemblies.
  • Namespaces:
    • using Syncfusion.XlsIO;
    • using Syncfusion.GroupingGridExcelConverter;
  • Ensure that whether the assemblies are referred properly as in below image.
 
 
 
 
Note: 
If still the issue is occurred, please provide us with your work sample. It would be more helpful for us to provide the exact solution at the earliest. 
 
Regards, 
Arulpriya 


Deepak
Replied On August 17, 2017 07:32 AM

Thank you for Quick Reply.i am checking this and reverting you ASAP.


Arulpriya Ramalingam [Syncfusion]
Replied On August 18, 2017 12:45 AM

Hi Deepak, 
 
Thanks for your update. 
 
We will wait, until we hear back from you. 
 
Regards, 
Arulpriya 


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.

;