private function PHPExcel_Writer_Excel5_Worksheet::_writeObjPicture 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::_writeObjPicture()

* Store the OBJ record that precedes an IMDATA record. This could be generalise * to support other Excel objects. * *

Parameters

integer $colL Column containing upper left corner of object: * @param integer $dxL Distance from left side of cell * @param integer $rwT Row containing top left corner of object * @param integer $dyT Distance from top of cell * @param integer $colR Column containing lower right corner of object * @param integer $dxR Distance from right of cell * @param integer $rwB Row containing bottom right corner of object * @param integer $dyB Distance from bottom of cell

1 call to PHPExcel_Writer_Excel5_Worksheet::_writeObjPicture()

PHPExcel_Writer_Excel5_Worksheet::_positionImage in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php

* Calculate the vertices that define the position of the image as required by * the OBJ record. * * +------------+------------+ * | A | B | * +-----+------------+------------+ * | |(x1,y1) | | * | 1 …

File

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

Class

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_Worksheet

Code

private function _writeObjPicture($colL, $dxL, $rwT, $dyT, $colR, $dxR, $rwB, $dyB) {
  $record = 0x5d;

  // Record identifier
  $length = 0x3c;

  // Bytes to follow
  $cObj = 0x1;

  // Count of objects in file (set to 1)
  $OT = 0x8;

  // Object type. 8 = Picture
  $id = 0x1;

  // Object ID
  $grbit = 0x614;

  // Option flags
  $cbMacro = 0x0;

  // Length of FMLA structure
  $Reserved1 = 0x0;

  // Reserved
  $Reserved2 = 0x0;

  // Reserved
  $icvBack = 0x9;

  // Background colour
  $icvFore = 0x9;

  // Foreground colour
  $fls = 0x0;

  // Fill pattern
  $fAuto = 0x0;

  // Automatic fill
  $icv = 0x8;

  // Line colour
  $lns = 0xff;

  // Line style
  $lnw = 0x1;

  // Line weight
  $fAutoB = 0x0;

  // Automatic border
  $frs = 0x0;

  // Frame style
  $cf = 0x9;

  // Image format, 9 = bitmap
  $Reserved3 = 0x0;

  // Reserved
  $cbPictFmla = 0x0;

  // Length of FMLA structure
  $Reserved4 = 0x0;

  // Reserved
  $grbit2 = 0x1;

  // Option flags
  $Reserved5 = 0x0;

  // Reserved
  $header = pack("vv", $record, $length);
  $data = pack("V", $cObj);
  $data .= pack("v", $OT);
  $data .= pack("v", $id);
  $data .= pack("v", $grbit);
  $data .= pack("v", $colL);
  $data .= pack("v", $dxL);
  $data .= pack("v", $rwT);
  $data .= pack("v", $dyT);
  $data .= pack("v", $colR);
  $data .= pack("v", $dxR);
  $data .= pack("v", $rwB);
  $data .= pack("v", $dyB);
  $data .= pack("v", $cbMacro);
  $data .= pack("V", $Reserved1);
  $data .= pack("v", $Reserved2);
  $data .= pack("C", $icvBack);
  $data .= pack("C", $icvFore);
  $data .= pack("C", $fls);
  $data .= pack("C", $fAuto);
  $data .= pack("C", $icv);
  $data .= pack("C", $lns);
  $data .= pack("C", $lnw);
  $data .= pack("C", $fAutoB);
  $data .= pack("v", $frs);
  $data .= pack("V", $cf);
  $data .= pack("v", $Reserved3);
  $data .= pack("v", $cbPictFmla);
  $data .= pack("v", $Reserved4);
  $data .= pack("v", $grbit2);
  $data .= pack("V", $Reserved5);
  $this
    ->_append($header . $data);
}