View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rainer Queck Rainer Queck is offline
external usenet poster
 
Posts: 3
Default 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