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.

Export GGC to Excel or XML

Thread ID:





32546 Aug 3,2005 09:35 AM Aug 4,2005 10:57 AM Windows Forms 7
Tags: GridControl
Asked On August 3, 2005 09:35 AM

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 [Syncfusion]
Replied On August 3, 2005 10: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

Replied On August 3, 2005 03: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

Administrator [Syncfusion]
Replied On August 3, 2005 03: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\\Windows\Data\GDBDdata.XML");

Replied On August 3, 2005 03:57 PM

I download GroupCustomersWithExportToExcel.zip and changed the reference to the new version 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 [Syncfusion]
Replied On August 3, 2005 04: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.

Replied On August 4, 2005 09:54 AM

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

Administrator [Syncfusion]
Replied On August 4, 2005 10:57 AM

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


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.