View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to create a Excel Workbook natively

I don't know much about the Excel file format, but I suspect you are writing
an xl4 format file. That file format only supported single sheet workbooks.
When excel 5 came out with Multisheet workbooks, the format was encased in
the Compound document format.

I think you would need to learn the compound document format as it is
implemented in Excel to write multisheet files.

--
Regards,
Tom Ogilvy

"Rainer Queck" wrote in message
...
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