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. Image for the cookie policy date

Export GGC to Excel or XML

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

7 Replies

AD Administrator Syncfusion Team August 3, 2005 09:06 AM

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


LA Lan August 3, 2005 02:17 PM

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


AD Administrator Syncfusion Team August 3, 2005 02:34 PM

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");


LA Lan August 3, 2005 02:57 PM

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


AD Administrator Syncfusion Team August 3, 2005 03:56 PM

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.


LA Lan August 4, 2005 08:54 AM

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


AD Administrator Syncfusion Team August 4, 2005 09:57 AM

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

Loader.
Live Chat Icon For mobile
Up arrow icon