private function PHPExcel_Writer_Excel5_Workbook::_writeExternsheet in Loft Data Grids 6.2

Same name and namespace in other branches

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

* Writes the Excel BIFF EXTERNSHEET record. These references are used by * formulas. NAME record is required to define the print area and the repeat * rows and columns. * * A similar method is used in Worksheet.php for a slightly different purpose. * *

Parameters

string $sheetname Worksheet name:

1 call to PHPExcel_Writer_Excel5_Workbook::_writeExternsheet()

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

* Write the EXTERNCOUNT and EXTERNSHEET records. These are used as indexes for * the NAME records.

File

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

Class

PHPExcel_Writer_Excel5_Workbook

PHPExcel_Writer_Excel5_Workbook

Code

private function _writeExternsheet($sheetname) {
  $record = 0x17;

  // Record identifier
  $length = 0x2 + strlen($sheetname);

  // Number of bytes to follow
  $cch = strlen($sheetname);

  // Length of sheet name
  $rgch = 0x3;

  // Filename encoding
  $header = pack("vv", $record, $length);
  $data = pack("CC", $cch, $rgch);
  $this
    ->_append($header . $data . $sheetname);
}