/** * Writes Excel BIFF BOUNDSHEET record. * * @param \PHPExcel\Worksheet $sheet Worksheet name * @param integer $offset Location of worksheet BOF */ private function writeBoundSheet($sheet, $offset) { $sheetname = $sheet->getTitle(); $record = 0x85; // Record identifier // sheet state switch ($sheet->getSheetState()) { case \PHPExcel\Worksheet::SHEETSTATE_VISIBLE: $ss = 0x0; break; case \PHPExcel\Worksheet::SHEETSTATE_HIDDEN: $ss = 0x1; break; case \PHPExcel\Worksheet::SHEETSTATE_VERYHIDDEN: $ss = 0x2; break; default: $ss = 0x0; break; } // sheet type $st = 0x0; $grbit = 0x0; // Visibility and sheet type $data = pack("VCC", $offset, $ss, $st); $data .= \PHPExcel\Shared\StringHelper::UTF8toBIFF8UnicodeShort($sheetname); $length = strlen($data); $header = pack("vv", $record, $length); $this->append($header . $data); }