| @@ 903-911 (lines=9) @@ | ||
| 900 | /** |
|
| 901 | * Write Internal SUPBOOK record |
|
| 902 | */ |
|
| 903 | private function _writeSupbookInternal() |
|
| 904 | { |
|
| 905 | $record = 0x01AE; // Record identifier |
|
| 906 | $length = 0x0004; // Bytes to follow |
|
| 907 | ||
| 908 | $header = pack("vv", $record, $length); |
|
| 909 | $data = pack("vv", $this->_phpExcel->getSheetCount(), 0x0401); |
|
| 910 | return $this->writeData($header . $data); |
|
| 911 | } |
|
| 912 | ||
| 913 | /** |
|
| 914 | * Writes the Excel BIFF EXTERNSHEET record. These references are used by |
|
| @@ 1179-1189 (lines=11) @@ | ||
| 1176 | * |
|
| 1177 | * @return string |
|
| 1178 | */ |
|
| 1179 | private function _writeCountry() |
|
| 1180 | { |
|
| 1181 | $record = 0x008C; // Record identifier |
|
| 1182 | $length = 4; // Number of bytes to follow |
|
| 1183 | ||
| 1184 | $header = pack('vv', $record, $length); |
|
| 1185 | /* using the same country code always for simplicity */ |
|
| 1186 | $data = pack('vv', $this->_country_code, $this->_country_code); |
|
| 1187 | //$this->_append($header . $data); |
|
| 1188 | return $this->writeData($header . $data); |
|
| 1189 | } |
|
| 1190 | ||
| 1191 | /** |
|
| 1192 | * Write the RECALCID record |
|
| @@ 1196-1207 (lines=12) @@ | ||
| 1193 | * |
|
| 1194 | * @return string |
|
| 1195 | */ |
|
| 1196 | private function _writeRecalcId() |
|
| 1197 | { |
|
| 1198 | $record = 0x01C1; // Record identifier |
|
| 1199 | $length = 8; // Number of bytes to follow |
|
| 1200 | ||
| 1201 | $header = pack('vv', $record, $length); |
|
| 1202 | ||
| 1203 | // by inspection of real Excel files, MS Office Excel 2007 writes this |
|
| 1204 | $data = pack('VV', 0x000001C1, 0x00001E667); |
|
| 1205 | ||
| 1206 | return $this->writeData($header . $data); |
|
| 1207 | } |
|
| 1208 | ||
| 1209 | /** |
|
| 1210 | * Stores the PALETTE biff record. |
|
| @@ 1644-1652 (lines=9) @@ | ||
| 1641 | * |
|
| 1642 | * @param integer $count The number of external sheet references in this worksheet |
|
| 1643 | */ |
|
| 1644 | private function _writeExterncount($count) |
|
| 1645 | { |
|
| 1646 | $record = 0x0016; // Record identifier |
|
| 1647 | $length = 0x0002; // Number of bytes to follow |
|
| 1648 | ||
| 1649 | $header = pack("vv", $record, $length); |
|
| 1650 | $data = pack("v", $count); |
|
| 1651 | $this->_append($header . $data); |
|
| 1652 | } |
|
| 1653 | ||
| 1654 | /** |
|
| 1655 | * Writes the Excel BIFF EXTERNSHEET record. These references are used by |
|