I am exporting a few data tables into one worksheet each within an excel workbook.
Before starting the export I create a dummy sheet, then add all the required sheets and then remove the dummy sheet from the workbook.
Now when I try to save the workbook i get an error
SheetIndex property has bad value or not all sheets saved to storage
at Syncfusion.ExcelRW.Parser.Biff_Records.BoundSheetRecord.UpdateOffsets(ArrayList records)
at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName, ExcelSaveType saveType)
at Syncfusion.ExcelRW.Implementation.WorkbookImpl.SaveAs(String FileName)
The name of the dummy sheet is a guid.
If I dont remove the dummy sheet then the workbook is saved successfully.
Please can you help to resolve this error?
ADAdministrator Syncfusion Team June 21, 2005 09:08 AM
Sorry for the delay in getting back to you.
This was a bug in version 126.96.36.199 but it has been fixed in patches released after 188.8.131.52.
Please create a Direc-Trac incident so that I can send you the download link to the patch which includes the fix.
>please can someone respond to this.
RTRishi TandonJune 26, 2005 11:32 PM
As requested, I have opened a direct-trac incident, 19573.
ADAdministrator Syncfusion Team June 30, 2005 05:22 AM
The incident has been updated with the link to the fix.
>As requested, I have opened a direct-trac incident, 19573.