private function PHPExcel_Writer_Excel5_Worksheet::_writeExternsheet in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php \PHPExcel_Writer_Excel5_Worksheet::_writeExternsheet()

* Writes the Excel BIFF EXTERNSHEET record. These references are used by * formulas. A formula references a sheet name via an index. Since we store a * reference to all of the external worksheets the EXTERNSHEET index is the same * as the worksheet index. * *

Parameters

string $sheetname The name of a external worksheet:

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php, line 1703

Class

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_Worksheet

Code

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

  // Record identifier
  // References to the current sheet are encoded differently to references to
  // external sheets.
  //
  if ($this->_phpSheet
    ->getTitle() == $sheetname) {
    $sheetname = '';
    $length = 0x2;

    // The following 2 bytes
    $cch = 1;

    // The following byte
    $rgch = 0x2;

    // Self reference
  }
  else {
    $length = 0x2 + strlen($sheetname);
    $cch = strlen($sheetname);
    $rgch = 0x3;

    // Reference to a sheet in the current workbook
  }
  $header = pack("vv", $record, $length);
  $data = pack("CC", $cch, $rgch);
  $this
    ->_append($header . $data . $sheetname);
}