How to create a Excel Workbook natively
Hi,
I started writing me a Excel Exporter. Up to now I can generate a simple worksheet as an xls file that opens nicely with Excel. Here the records I write up to now:
SheetBof //Identifier:= $809 type $10 Worksheet
RKValue(1) // Identifier:= $27E
......
RKValue(n) // Identifier:= $27E
SheetEof // Identifier:= $0A
As I said, that works nicely. But now I would like to create a Excel Workbook that holds a couple of Sheets. I thought this would work some how like :
WorkbookBof //$809 type $100 Workbook globals
SheetOffset
SheetHeader
SheetBof //Identifier:= $809 type $10 Worksheet
RKValue(1) // Identifier:= $27E
......
RKValue(n) // Identifier:= $27E
SheetEof // Identifier:= $0A
WorkbookEof
But the generated File can not be read by Excel. I know that the given information is not engough to tell where the problem is located exactly, but is the "way" the right one, or am I missing some important records?
Thanks for hints
Rainer
|