You are here

Home » API reference » Loft Data Grids 6.2 » Excel5.php » PHPExcel_Writer_Excel5

private function PHPExcel_Writer_Excel5::_writeDocumentSummaryInformation in Loft Data Grids 6.2

Same name and namespace in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5.php \PHPExcel_Writer_Excel5::_writeDocumentSummaryInformation()

* Build the OLE Part for DocumentSummary Information *

Return value

string

1 call to PHPExcel_Writer_Excel5::_writeDocumentSummaryInformation()
PHPExcel_Writer_Excel5::save in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5.php
* Save PHPExcel to file * *

File

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

Class

PHPExcel_Writer_Excel5
PHPExcel_Writer_Excel5

Code

private function _writeDocumentSummaryInformation() {

  // offset: 0; size: 2; must be 0xFE 0xFF (UTF-16 LE byte order mark)
  $data = pack('v', 0xfffe);

  // offset: 2; size: 2;
  $data .= pack('v', 0x0);

  // offset: 4; size: 2; OS version
  $data .= pack('v', 0x106);

  // offset: 6; size: 2; OS indicator
  $data .= pack('v', 0x2);

  // offset: 8; size: 16
  $data .= pack('VVVV', 0x0, 0x0, 0x0, 0x0);

  // offset: 24; size: 4; section count
  $data .= pack('V', 0x1);

  // offset: 28; size: 16; first section's class id: 02 d5 cd d5 9c 2e 1b 10 93 97 08 00 2b 2c f9 ae
  $data .= pack('vvvvvvvv', 0xd502, 0xd5cd, 0x2e9c, 0x101b, 0x9793, 0x8, 0x2c2b, 0xaef9);

  // offset: 44; size: 4; offset of the start
  $data .= pack('V', 0x30);

  // SECTION
  $dataSection = array();
  $dataSection_NumProps = 0;
  $dataSection_Summary = '';
  $dataSection_Content = '';

  // GKPIDDSI_CODEPAGE: CodePage
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0x1,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0x2,
    ),
    // 2 byte signed integer
    'data' => array(
      'data' => 1252,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_CATEGORY : Category
  if ($this->_phpExcel
    ->getProperties()
    ->getCategory()) {
    $dataProp = $this->_phpExcel
      ->getProperties()
      ->getCategory();
    $dataSection[] = array(
      'summary' => array(
        'pack' => 'V',
        'data' => 0x2,
      ),
      'offset' => array(
        'pack' => 'V',
      ),
      'type' => array(
        'pack' => 'V',
        'data' => 0x1e,
      ),
      'data' => array(
        'data' => $dataProp,
        'length' => strlen($dataProp),
      ),
    );
    $dataSection_NumProps++;
  }

  // GKPIDDSI_VERSION :Version of the application that wrote the property storage
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0x17,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0x3,
    ),
    'data' => array(
      'pack' => 'V',
      'data' => 0xc0000,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_SCALE : FALSE
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0xb,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0xb,
    ),
    'data' => array(
      'data' => false,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_LINKSDIRTY : True if any of the values for the linked properties have changed outside of the application
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0x10,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0xb,
    ),
    'data' => array(
      'data' => false,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_SHAREDOC : FALSE
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0x13,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0xb,
    ),
    'data' => array(
      'data' => false,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_HYPERLINKSCHANGED : True if any of the values for the _PID_LINKS (hyperlink text) have changed outside of the application
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0x16,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0xb,
    ),
    'data' => array(
      'data' => false,
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_DOCSPARTS
  // MS-OSHARED p75 (2.3.3.2.2.1)
  // Structure is VtVecUnalignedLpstrValue (2.3.3.1.9)
  // cElements
  $dataProp = pack('v', 0x1);
  $dataProp .= pack('v', 0x0);

  // array of UnalignedLpstr
  // cch
  $dataProp .= pack('v', 0xa);
  $dataProp .= pack('v', 0x0);

  // value
  $dataProp .= 'Worksheet' . chr(0);
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0xd,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0x101e,
    ),
    'data' => array(
      'data' => $dataProp,
      'length' => strlen($dataProp),
    ),
  );
  $dataSection_NumProps++;

  // GKPIDDSI_HEADINGPAIR
  // VtVecHeadingPairValue
  // cElements
  $dataProp = pack('v', 0x2);
  $dataProp .= pack('v', 0x0);

  // Array of vtHeadingPair
  // vtUnalignedString - headingString
  // stringType
  $dataProp .= pack('v', 0x1e);

  // padding
  $dataProp .= pack('v', 0x0);

  // UnalignedLpstr
  // cch
  $dataProp .= pack('v', 0x13);
  $dataProp .= pack('v', 0x0);

  // value
  $dataProp .= 'Feuilles de calcul';

  // vtUnalignedString - headingParts
  // wType : 0x0003 = 32 bit signed integer
  $dataProp .= pack('v', 0x300);

  // padding
  $dataProp .= pack('v', 0x0);

  // value
  $dataProp .= pack('v', 0x100);
  $dataProp .= pack('v', 0x0);
  $dataProp .= pack('v', 0x0);
  $dataProp .= pack('v', 0x0);
  $dataSection[] = array(
    'summary' => array(
      'pack' => 'V',
      'data' => 0xc,
    ),
    'offset' => array(
      'pack' => 'V',
    ),
    'type' => array(
      'pack' => 'V',
      'data' => 0x100c,
    ),
    'data' => array(
      'data' => $dataProp,
      'length' => strlen($dataProp),
    ),
  );
  $dataSection_NumProps++;

  // 		4 	Section Length
  //		4 	Property count
  //		8 * $dataSection_NumProps (8 =  ID (4) + OffSet(4))
  $dataSection_Content_Offset = 8 + $dataSection_NumProps * 8;
  foreach ($dataSection as $dataProp) {

    // Summary
    $dataSection_Summary .= pack($dataProp['summary']['pack'], $dataProp['summary']['data']);

    // Offset
    $dataSection_Summary .= pack($dataProp['offset']['pack'], $dataSection_Content_Offset);

    // DataType
    $dataSection_Content .= pack($dataProp['type']['pack'], $dataProp['type']['data']);

    // Data
    if ($dataProp['type']['data'] == 0x2) {

      // 2 byte signed integer
      $dataSection_Content .= pack('V', $dataProp['data']['data']);
      $dataSection_Content_Offset += 4 + 4;
    }
    elseif ($dataProp['type']['data'] == 0x3) {

      // 4 byte signed integer
      $dataSection_Content .= pack('V', $dataProp['data']['data']);
      $dataSection_Content_Offset += 4 + 4;
    }
    elseif ($dataProp['type']['data'] == 0xb) {

      // Boolean
      if ($dataProp['data']['data'] == false) {
        $dataSection_Content .= pack('V', 0x0);
      }
      else {
        $dataSection_Content .= pack('V', 0x1);
      }
      $dataSection_Content_Offset += 4 + 4;
    }
    elseif ($dataProp['type']['data'] == 0x1e) {

      // null-terminated string prepended by dword string length
      // Null-terminated string
      $dataProp['data']['data'] .= chr(0);
      $dataProp['data']['length'] += 1;

      // Complete the string with null string for being a %4
      $dataProp['data']['length'] = $dataProp['data']['length'] + (4 - $dataProp['data']['length'] % 4 == 4 ? 0 : 4 - $dataProp['data']['length'] % 4);
      $dataProp['data']['data'] = str_pad($dataProp['data']['data'], $dataProp['data']['length'], chr(0), STR_PAD_RIGHT);
      $dataSection_Content .= pack('V', $dataProp['data']['length']);
      $dataSection_Content .= $dataProp['data']['data'];
      $dataSection_Content_Offset += 4 + 4 + strlen($dataProp['data']['data']);
    }
    elseif ($dataProp['type']['data'] == 0x40) {

      // Filetime (64-bit value representing the number of 100-nanosecond intervals since January 1, 1601)
      $dataSection_Content .= $dataProp['data']['data'];
      $dataSection_Content_Offset += 4 + 8;
    }
    else {

      // Data Type Not Used at the moment
      $dataSection_Content .= $dataProp['data']['data'];
      $dataSection_Content_Offset += 4 + $dataProp['data']['length'];
    }
  }

  // Now $dataSection_Content_Offset contains the size of the content
  // section header
  // offset: $secOffset; size: 4; section length
  // 		+ x  Size of the content (summary + content)
  $data .= pack('V', $dataSection_Content_Offset);

  // offset: $secOffset+4; size: 4; property count
  $data .= pack('V', $dataSection_NumProps);

  // Section Summary
  $data .= $dataSection_Summary;

  // Section Content
  $data .= $dataSection_Content;
  return $data;
}