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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Grid/Excel export error

Thread ID:





83096 Jun 23,2009 08:23 PM UTC Jun 26,2009 06:05 PM UTC WinForms 4
Tags: GridControl
Administrator [Syncfusion]
Asked On June 23, 2009 08:23 PM UTC

This post might be better placed in the XlsIO forum, but anyways...Any idea why some (but not all) users of our application might be getting this error?

Message: There was an error creating the excel spreadsheet C:\TEMP\gvtemp1.xls. Maximum number of extended formats exceeded.

at Syncfusion.XlsIO.Implementation.Collections.ExtendedFormatsCollection.Add(ExtendedFormatImpl format)
at Syncfusion.XlsIO.Implementation.WorkbookImpl.RegisterExtFormat(ExtendedFormatImpl format)
at Syncfusion.XlsIO.Implementation.CellStyle.EndUpdate()
at Syncfusion.XlsIO.Implementation.ExtendedFormatWrapper.set_BottomBorderLineStyle(ExcelLineStyle value)
at Syncfusion.XlsIO.Implementation.BorderImpl.set_LineStyle(ExcelLineStyle value)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyBorder(GridBorder cellBorder, IBorder rangeBorder)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyBorders(GridStyleInfo gridCell, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyStyle(GridStyleInfo gridStyle, IRange destRange)
at Syncfusion.GridExcelConverter.GridExcelConverterBase.CopyStyles(GridModel grid, Int32 iRow, Int32 iColumn, GridStyleInfo gridCell, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridCellToExcel(GridModel grid, Int32 iRow, Int32 iColumn, IRange range)
at Syncfusion.GridExcelConverter.GridExcelConverterControl.GridToExcel(GridModel grid, IWorksheet sheet, ConverterOptions options)

Lingaraj S [Syncfusion]
Replied On June 24, 2009 12:32 PM UTC

Hi Mark,

Thank you for your interest in Syncfusion product.

I am afraid that I was not able to reproduce the issue in ExcelConverter, when the GridControl has been exported to Excel. Also I have created a simple sample to test this issue and it is available in the following link.

This sample shows how to Export the GridControl to Excel using GridExcelConverter.

Please let me know if still face the issue, it could be helpful reproduce the steps in the above sample.

Lingaraj S.

Administrator [Syncfusion]
Replied On June 24, 2009 03:53 PM UTC

I understand how to export from a grid to excel. It has been working great, but for some reason 1 of our users gets that error.
I definitely don't expect anyone to be able to repro the error, but can you tell me what the error means?
What does "Maximum number of extended formats exceeded." mean?


Lingaraj S [Syncfusion]
Replied On June 25, 2009 08:56 AM UTC

Hi Mark,

Thank you for the update.

I am able to see the issue in GridControl ExcelExport in version When the GridControl has been exported with large number of rows and more column header. This issue has been fixed in our latest version. Please upgrade to our latest version 7.2.037.

Please let me know if you have any other concerns.

Lingaraj S.

Administrator [Syncfusion]
Replied On June 26, 2009 06:05 PM UTC

That's great! Thanks for the feedback.


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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