Mailinglisten-Archive |
> 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