private function PHPExcel_Writer_Excel5_Workbook::_writeBoundsheet in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php \PHPExcel_Writer_Excel5_Workbook::_writeBoundsheet()

* Writes Excel BIFF BOUNDSHEET record. * *

Parameters

PHPExcel_Worksheet $sheet Worksheet name: * @param integer $offset Location of worksheet BOF

1 call to PHPExcel_Writer_Excel5_Workbook::_writeBoundsheet()

PHPExcel_Writer_Excel5_Workbook::writeWorkbook in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php

* Assemble worksheets into a workbook and send the BIFF data to an OLE * storage. * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php, line 925

Class

PHPExcel_Writer_Excel5_Workbook

PHPExcel_Writer_Excel5_Workbook

Code

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_String::UTF8toBIFF8UnicodeShort($sheetname);
  $length = strlen($data);
  $header = pack("vv", $record, $length);
  $this
    ->_append($header . $data);
}