Excel 2000 with OWC 11

[Stefan Hirtbach]

Hi,
I wrote a small program in C#, using OWC11, that fills data in an excelsheet
and save it to disk as xls-file (using the Export-function).
It works well with Office 2003 but i've got problems using the file in
Office 2002 and 2000. It seems that the exported file is in an XML-file and
not an native Excel-file. Is it possible to generate a native File to use it
with 2000 and 2002, or have I to grade down to OWC10?

BTW: How do I color cells and add macros in an Spreadsheet

Thanks in advance
Stefan

---Code---
OWC11.SpreadsheetClass xlsheet = new OWC11.SpreadsheetClass();
xlsheet.Cells[1,1] = "A";
xlsheet.Export("test.xls",OWC11.SheetExportActionEnum.ssExportActionNone,
OWC11.SheetExportFormat.ssExportAsAppropriate);

 

[Lynn Johnson]

Starting with OWC10 (XP) the native export format became XML which means whoever utilizes the export file must have Office XP which is the first version to support XML as a native input format. You should be able to read this file with Excel 2002 (XP) but certainly not in Excel 2000

OWC does not support macros. You color cells using the object model of OWC the same way you would do it in Excel. You use the .Cells function such as this: SS.Worksheets("Sheetname").Cells(Row, Col).Interior.Color = "Red