Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
337
Excel workbook name
posted

Hi,

We just upgrade the infragisitss version from 8 to 11.  Following error through when export to using v11. please advice how to overcome these error.

"The worksheet name must be between 1 and 31 characters in length.\r\nParameter name: name"

"Infragistics2.Documents.Excel.v11.2"

"   at Infragistics.Documents.Excel.Worksheet.VerifyNameIsValid(String name, String paramName)\r\n   at Infragistics.Documents.Excel.WorksheetCollection.Add(String name)\r\n   at RAD.Utilities.InfraControls.ExportGridToExcel(Workbook objWorkBook, String WorkSheetName, UltraGrid uGrid, Boolean SaveFlag) in "

  • 44743
    Verified Answer
    posted

    It seems you have posted this question in another thread, so I will copy my answer here:

    Yes, there was a bug in older versions of the library (bug id 11149) where the worksheet name was allowed to be longer than 31 characters, which is the maximum allowed in Excel. While it was valid to write out longer names, Excel was only using the first 31 characters and ignoring the rest. So if you happened to have two unique names which matched in their first 31 characters, it would work fine in the Excel library, but Microsoft Excel would throw an error when the saved file was opened. We fixed the bug by imposing the same limit on worksheet names as Microsoft Excel.