phpbar.de logo

Mailinglisten-Archive

[php] Excel-Ausgabe

[php] Excel-Ausgabe

Cyrill Schumacher php_(at)_phpcenter.de
Mon, 14 May 2001 11:03:19 +0200


> Gut. Und wie bekomme ich Daten aus einer Excel Datei, die genau
> mit diesen Funktionen erstellt wurde wieder heraus ?

mit dieser beschreibung

#########################################
MICROSOFT EXCEL FILE FORMAT
Microsoft Excel is a popular spreadsheet.  It uses a file format called BIFF
(Binary
File Format).  There are many types of BIFF records.  Each has a 4 byte
header.  The
first two bytes are an opcode that specifies the record type.  The second
two bytes
specify record length.  Header values are stored in byte-reversed form (less
significant
byte first).  The rest of the record is the data itself (Figure 2-1).
Figure 2-1.  BIFF record header.
                 |  Record Header    |  Record Body
Byte Number      |  0    1    2    3 |  0    1   ...
                -----------------------------------
Record Contents  | XX | XX | XX | XX | XX | XX | ...
                -----------------------------------
                | opcode   | length  | data

Each X represents a hexadecimal digit
Two X's form a byte.  The least significant (low) byte of the opcode is byte
0 and the
most significant (high) byte is byte 1.  Similarly, the low byte of the
record length
field is byte 2 and the high byte is byte 3.

BOF (Beginning of File)
The first record in every spreadsheet is always of the BOF type (Figure
2-2).
Figure 2-2.  BOF record.
           |  Record Header    |    Record Body    |
Byte       |  0    1    2    3 |  0    1    2    3 |
           -----------------------------------------
Contents   | 09 | 00 | 04 | 00 | 02 | 00 | 10 | 00 |
           -----------------------------------------
           | opcode  | length  | version |  file   |
           |         |         |  number |  type   |
The first two bytes, arranged with the low byte first, show that the opcode
for BOF is
09h.  The second two bytes indicate that the record body is 4 bytes long.
The first two
##############################

Wer die ganze SPEC (45KB) haben möchte, bitte eine PM an mich und
ich schicke sie zu.

kiri




php::bar PHP Wiki   -   Listenarchive