Export GGC to Excel or XML

[Lan]

Hello,
I have GroupingGridControl form. the GGC is filled by single flat-table and user can drag-drop any column to grouping the data. the GGC also has 4 summary rows AVG,MIN,MAX,SUM for all numeric columns.

I want to export to GGC data to excel and XML.

I have seen some samples but I can''t remeber where to find them.

Any idea?
Thanks,

Lan

[Administrator]

Here is a link that has a preliminary version of a helper class that exports to excel.

http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=32139

[Lan]

I download the zip file. When I compile it, got some compile errors and I can''t figure them out.

my version is 3.2.1.0

[Administrator]

Care to post the errors?

Do you have the ExcelRw library installed?

The sample needs to have the XML data for teh ReadXml call. So, try pointing it to the data in our sample data folder.

	ReadXml(this.dataSet11, @"C:\Program Files\Syncfusion\Essential Studio\3.2.1.0\Windows\Data\GDBDdata.XML");

[Lan]

I download GroupCustomersWithExportToExcel.zip and changed the reference to the new version 3.2.1.0.

Recompile it, got following compile errors.

C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(2114): ''Syncfusion.Drawing.PatternStyle'' does not contain a definition for ''DarkVertical''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(128): ''Syncfusion.ExcelRW.Implementation.FormulaUtil'' does not contain a definition for ''RegisterAdditionalAlias''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(127): ''Syncfusion.ExcelRW.Implementation.FormulaUtil'' does not contain a definition for ''RegisterAdditionalAlias''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(1019): ''Syncfusion.ExcelRW.IPageSetup'' does not contain a definition for ''IsSummaryRowBelow''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(333): ''Syncfusion.ExcelRW.IStyle'' does not contain a definition for ''NumberFormatIndex''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(2173): ''Syncfusion.ExcelRW.IWorksheet'' does not contain a definition for ''GetColumnWidthInPixels''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(2153): ''Syncfusion.ExcelRW.IWorksheet'' does not contain a definition for ''GetRowHeightInPixels''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(1482): ''Syncfusion.ExcelRW.IWorksheet'' does not contain a definition for ''SetColumnWidth''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(930): ''Syncfusion.ExcelRW.IWorksheet'' does not contain a definition for ''SetColumnWidth''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(899): ''Syncfusion.ExcelRW.IWorksheet'' does not contain a definition for ''SetRowHeightInPixels''
C:\temp\GroupCustomersWithExportToExcel_4d92b89b\GroupCustomersWithExportToExcel\GridExcelConverterControl.cs(2108): Control cannot fall through from one case label (''case 6:'') to another

[Administrator]

Those are 3.3. properties.

You can try just commenting out the lines that give these syntax errors, or you can wait until the 3.3 library is available for download.

[Lan]

I''ll wait for the new version 3.3.
By the way, any idea when it release?

[Administrator]

All I can say is that we are actively working on it.