Clearing Worksheets Collection

After I create a Workbook object I immediately clear the worksheets to get rid of any default worksheets. Workbook.Worksheets.Clear() I then run my code that will add one or more new sheets. When I attempt to save my workbook I am getting the following error. I have played with ActiveSheets and ActiveSheetsIndex and it looks like even though I cleared my worksheets the Workbook still thinks the ActiveSheet is "Sheet1". I have tried calling SetActiveSheet after adding new woksheets with the same result. Is this a bug or something I am dpoing wrong? .NET Stack Trace: [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at System.ThrowHelper.ThrowArgumentOutOfRangeException(ExceptionArgument argument, ExceptionResource resource) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.Excel2007Serializator.SerializeWorksheet(XmlWriter writer, Worksheet sheet, Stream streamStart, Stream streamConFormats, Dictionary`2 hashXFIndexes) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.WorksheetDataHolder.SerializeWorksheetPart(Worksheet sheet, Dictionary`2 hashNewXFIndexes) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.WorksheetDataHolder.SerializeWorksheet(Worksheet sheet, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveWorksheet(Worksheet sheet, String itemName, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveSheet(BaseSheet sheet, String itemName, RelationCollection relations, String workbookPath, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveSheets(RelationCollection relations, String workbookItemName, Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveWorkbookPart(Dictionary`2 hashNewXFIndexes, Dictionary`2 cacheFiles) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveWorkbook(FileSaveType saveAsType) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveDocument(FileSaveType saveType) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveDocument(Stream stream, FileSaveType saveType) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.XmlSerialization.FileDataHolder.SaveDocument(String filename, FileSaveType saveType) [18/04/25@14:55:12.662-0400] P-007412 T-018456 1 4GL ORS_ERR at ComponentPro.Excel.Workbook.SaveAs(String FileName, FileSaveType saveType, ExcelVersion version)

I downloaded 7.0.21 and code that was working before no longer works. the following was being used to add a style. oStyle = poWorkbook.Styles.Add ("ORS_Date", poWorkbook.Styles [0] ). oStyle.NumberFormat = "mm/dd/yyyy". oStyle.HorizontalAlignment = ExcelHAlign.HAlignCenter. oStyle.WrapText = TRUE. oStyle.FONT.FontName = "Arial". oStyle.FONT.Bold = FALSE. oStyle.Font.Size = 10. As soon as I reference 'Font' I get the error System.MissingMethodException: Method 'ComponentPro.Excel.Style.get_Font' not found.

Where do I get RC version 7.0?

Please use our RC version 7.0 which we sent you in the email. That one addresses several issues related to sheet. Please let us know if you have any issues.