nåfTlWNlˆÒrßnöØ ¼ÑºÓæq$«ôÂ³¬*Ç‡0Y‹µâ8i(?[<À‹«c“S…Ï&CØ¥‹ânÿ6›Å$MœÃ½yì#|ýM@2DÃoÅÌ4W±9ì.º§ª R"Ö”òáüˆ|ŒßáôøØñ)YÆ?"#¸X„âb¡ÞgqÆuÄ‘örŠd®úrâ.HÖ9![&Åõ£f³Vgn&aIõµËÒöYƒu ÐÁ0M¼ÙÇ³¢{œÖïãmâéÂYÅ²ó±g ¤[üLf‚$áK§‡GröJºsÚØfå]ZV¦hgr¨P>×Ù´Kˆ=3¨Í®ô V¶t²*¬€ßaT9M›Ù?Í—‚UÕÌèo÷f Çs«Ø%ñÇá‡§ÄÔkÓæ0ú„Ö”òáüˆ|ŒßáôøØñ)YÆ?"#¸X„âb¡tB²´RÞËÐª`RÍ ¾9‡À"yÃ÷¬‚ð àMY>ânÿ6›Å$MœÃ½yì#|ýêÊ½òVj9q¢Ÿ ˆMN_vÎú!SdáLGDÑt#Þ—ÿlÎøµú¤"Û\¯)Aþø äóç=¶-Œf0—¢Ú‡}kêÃ©ÑÆ]Dõ÷4F¼·–´týø—Ð³UYŸùLlŽÂ°§Õs5"º²ƒâyBAž¾¨,ñÔ£Àhº@ÞöØ ¼ÑºÓæq$«ôÂ³¬*¦åØAÓª}©²#”¢Ê O9¨S¬“”u(MÆÓ¿qÜ@|/O›”eh1*Ø©¾ìzÍ°nêðËÞËÕ0½·“ñ?Í|JöÜÉ–Ù ××OŠO†Ci¡Á¾ÝheLcèG»e¹–M¯ÒãQŒúÜª…sƒDNq·@ö"FÕ…^”ÉOvÛ¤Â¬AÿÂÂIßUM .ëõ@ö"FÕ…^”ÉOvÛ¤Â±ŽC??EP§xRcç‹¨ 7JÀã6jô§Ë”Q5¢®hg ‡¥øôpi.ælX‚óŽ³B·†9§÷2è@ÎCÐùŽè—‰rmÌÝ³²D~¨9¨¿ánš3k~¡o2ò³¦YØïtÍiÎç‰ód@Õã¤¦&SJ¿×”¦nñ6½´ÍµÚ/º*òýúìÚ á«~Aá:U„â®Õ0»Y|ªƒò»â%Yg p˜Mèúg€áOGeH=ÖÝùÄÀ‰úþcn]3…K F¤”±¼aÚ4E¬vdV°ÁN øˆ»gnœ\I£%°4„Oœ··ç>ž‡j!øºÎÐâýõ‹·‘„9(S‚QÔxF¬`€n˜ë9¼%IÕ€›Ïmjm› ;‡Io‹n_e-ÞŒøòåößùàXí D{Úî šîu“žbÁË&\«±RÄ$òêk¤Lˆ?ÉªšZé; ÁyfjÊb¹æJ˜‰ºMõh7kŸÿÒ=jÁ·´U‘=bÅ_;.-Ù ƒÞš5–äqQ¤ñA¸ 8=ÅdMJÆ‡ái=ïøµRNPEá@:r!6Û"†Ä®[B1–<©yR€™S¾•,³%Q›þºœ¡ÏÐ[ÙzsÈ«J¬ÆÆƒÃAØÎ_WíNž( Û²#qà`Á†¿dã|Ô§1ÝsâUÑ×Äß’kîð*BeUÔíqòs®Íç.èÀ§YD‰RÐ/*“—r3ÁB‘”®‚úÓ<Ê¿*“u³rô„½ä› tÜÏñ5è!ý“£÷¿¡Rö7‹ÿ{|š¡É½Â÷vþjrc{â—ù¬ä¯^:Î‚Ké×´L¡Àz‰|LG¿¡:eànDËNÒ7Þ,á’·P]V Î&€@9¬V ¡Þ3²õá4µ/‘”®‚úÓ<Ê¿*“u³rô„½ä› tÜÏñ5è!ý“£÷¿¡Rö7‹ÿ{|šâ[ÐúŽòi»ý)HÿnÎjÄJ¾(mYÂvýnè4zÅnªÅ$öd}Ÿ°Ñ+å‡B iÀ[?…¹®b¦>½Z±’éPd}fÒäuÔÅ»†À—åËûY”£l½iÆrô„½ä› tÜÏñ5è!>]VùÒÐ$oØÝ´r ³— ËÈjÙË|èß ¤¶tFëL¬Ui‡´&è©Â[GröJºsÚØfå]ZV¦hgr¨P>×Ù´Kˆ=3¨Í®özÓ•Ú€b\{¿ß:¿uã;<îfÉÇ,2x&«òJˆPXÙÕ1y¯¾`ÁAìGûÅT¿Yøb0H/Nráw_1Åj*¸!l<ÃmÔëo=e¬q¨U¼™;Èê¢ºJ:“¾ÔÖâø×‹zÆzê¦îž•¬Ò°ˆpØŒ:K¨2(ÆÝ¾-HÄë¦ØýÉÌ©±}kT‡í#LØ€™È›ÝÔÝ+!êÖÆñðÃ—4Ç3“=b™«jsm7M å‡—— ôn*¦ÑÙ@.–ê-®sòÖ°cd4ju†ÓùaìøãŠÐºM¤9‡§»†9½^ß1OóxË²7EðNÂ†‡GS7½¢ g²r¤Ó·.i¶§˜%šgNÀ×é7Cº-oÊÌ Î`üQ²Ôâbè/nÝ°U^›h”û˜4Dà`ÏD[ëX,›¾D]R¾pèíŒÁ7ð±Ê#ëTèÌÆ-õ6ÐËÉöDEDÕpÍ8R!µqÒ'>mñz†"éŠ¯]¸3Ž¹§¬$~E;v1ˆNz èMÄ_ ¸! MÚö`F<èöiŽ•1ƒ|âÒBç=Û•î‚%ÒŸ»ƒ¯b2‰dø x§%bAsØ~=Ô¡›~¨ÇæïÂ•èØÂ–³©ú1&ƒôËÇüUÓ'uÁs EMÚ ¶öŠ"µrxä6z¤sÏÂßvÇó8Ú€°)uE¤¦Ï×¶àö¬àhJ^àŒ}·JwiºõŒº÷Ê–×‹§/;#+ä†ŽîC2]7 ”tçê‚0®¯>7K (‘ìµáŽL¦¥dSò}¬|Ï>· ýºwDâ†¦a o%ŸUéYÆþÖ.H‚a3³|ö¿ŠPÈKSÎì¨òm\MÍ£xn–•jƒå’ÆCÈÍšÑ(3„ò˜ÝHØ >CY^Ê@ÇâŽÊþPÒ}Ž{Ã¶B“=)~®{yÁãkÁ”lõÅþ¸ƒ\KKŽûŠQ¥ÊùØ"TOTÇ|£aüXx½ÎEÎ-ô_½ˆoö¨Ö ÷OxÚyàð×4ºªåÉæWª—ºPƒ¢“ö9åÜ´æ~‰ØC—yáã5fŠ,œËü·¾ÞßMd? üOÝ:WÆH òyÒW‰SmØ¥»"8eæ‹®opnY˜{VÎÈ~ÍÎT//kPc9’iŸ8»c6žÄ°™CeP‹ðÚ7¶jÎ½,%Gcv/whBe7xô‚0–Æâ®SÌ)p°{§>vlŸ…\+VAjFÊq¸C×–ÑG—ä.ã¤+&›g#0ÆëÈ»]¦mþ³áDp#«àå/ï”¼ÞÜgÂ-;Sv§ße¼žsÿILÖôÿœ]‹r²©¡ÝÄ¡`ûG™Á3âñp(Â-Å/0s»²âóãÔ‚»4[>"¤J×5‹ô*'êBV±sÎf…HéíXìªé«dc^È*Ý_ÓÂÁûÓ½çwÜoªlMåÆ?ªqlç#ßú~ó§3)¢RIJ"w… ÿ¶V‚oB~íí§ïÿ¶ÿª,~t|<ç"ëæì±Q(Þ'BcgŒíS]·\W!IÉ±îCöÍ¢D2¨?Ps0‡Hœ †€KÍqªÆç³‘D“éžÚÐ$èÜî-hqjLeÍ‘”Çþ¼“®JAê¨ “Œr¼LSQi×Ü _’Öw§I”oÂ×´±ä)þÉãëð]é^ÒríOZ]Í(¹–žâ(|±^º¸–ö«¶éaqhE1~}Âíˆô¢qÍ±¨a0ÝíÉ«ñ«Ðdfûø½è™4'h~{áwŒ(¾uëkÎ>hbº÷V x×YMQ."Ì s7®^Ùâo9Ù~d5jqÅº%rTÀé ÌâŸÆpÒ%e_j|Ç¨GÓBLÊž¾âò[Ó<¿»CÖïL4Ñì¶¡RÐZ5Zæá{à8K²º´qw¤Þå¶26Jð!«^ÅEï{’¼ðû‡ƒ]wØµùØIC3Ð“;NÜ`ÕâîÕZúù¬sÚúJB’J*jÛ]6.S_°ÕülÁe(—¬·ÈCÙBy€ûn¾þ•ó%í¦œË8P‘íÀ8£ÚBÒœmý1Á.E^¹™$îÈ!wÚ?t˜¼¯µN%)Ÿ*MÛt5â.þõ}º(3Ýb»õv¹^‡PmàŽÀÇ@ÁØÝú*ÚUdETë‡4‚)›Þ3!MEæšp#NOù·ÒóÍEãóõêw¤»ß®§)í°o¶r’Ôbädv që5] ×Ø(t;0‘ÿvV>¿¦@O£üÞ5¥Ðú—:-Ž'¤¨^p ºKêªó‘zxïˆ-u)uþ*LMm~±è¯‘uÈìÄSv2údzsÂ‚,%±óRóYŒ*ïù€qSÑ¬M_DÖ‡îTü]Ðpos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read DggContainer record (Drawing Group Container). */ private function readDggContainer(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // record is a container, read contents $dggContainer = new DggContainer(); $this->applyAttribute('setDggContainer', $dggContainer); $reader = new self($dggContainer); $reader->load($recordData); } /** * Read Dgg record (Drawing Group). */ private function readDgg(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read BstoreContainer record (Blip Store Container). */ private function readBstoreContainer(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // record is a container, read contents $bstoreContainer = new BstoreContainer(); $this->applyAttribute('setBstoreContainer', $bstoreContainer); $reader = new self($bstoreContainer); $reader->load($recordData); } /** * Read BSE record. */ private function readBSE(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance $recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // add BSE to BstoreContainer $BSE = new BSE(); $this->applyAttribute('addBSE', $BSE); $BSE->setBLIPType($recInstance); // offset: 0; size: 1; btWin32 (MSOBLIPTYPE) //$btWin32 = ord($recordData[0]); // offset: 1; size: 1; btWin32 (MSOBLIPTYPE) //$btMacOS = ord($recordData[1]); // offset: 2; size: 16; MD4 digest //$rgbUid = substr($recordData, 2, 16); // offset: 18; size: 2; tag //$tag = Xls::getUInt2d($recordData, 18); // offset: 20; size: 4; size of BLIP in bytes //$size = Xls::getInt4d($recordData, 20); // offset: 24; size: 4; number of references to this BLIP //$cRef = Xls::getInt4d($recordData, 24); // offset: 28; size: 4; MSOFO file offset //$foDelay = Xls::getInt4d($recordData, 28); // offset: 32; size: 1; unused1 //$unused1 = ord($recordData[32]); // offset: 33; size: 1; size of nameData in bytes (including null terminator) $cbName = ord($recordData[33]); // offset: 34; size: 1; unused2 //$unused2 = ord($recordData[34]); // offset: 35; size: 1; unused3 //$unused3 = ord($recordData[35]); // offset: 36; size: $cbName; nameData //$nameData = substr($recordData, 36, $cbName); // offset: 36 + $cbName, size: var; the BLIP data $blipData = substr($recordData, 36 + $cbName); // record is a container, read contents $reader = new self($BSE); $reader->load($blipData); } /** * Read BlipJPEG record. Holds raw JPEG image data. */ private function readBlipJPEG(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance $recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; $pos = 0; // offset: 0; size: 16; rgbUid1 (MD4 digest of) //$rgbUid1 = substr($recordData, 0, 16); $pos += 16; // offset: 16; size: 16; rgbUid2 (MD4 digest), only if $recInstance = 0x46B or 0x6E3 if (in_array($recInstance, [0x046B, 0x06E3])) { //$rgbUid2 = substr($recordData, 16, 16); $pos += 16; } // offset: var; size: 1; tag //$tag = ord($recordData[$pos]); ++$pos; // offset: var; size: var; the raw image data $data = substr($recordData, $pos); $blip = new Blip(); $blip->setData($data); $this->applyAttribute('setBlip', $blip); } /** * Read BlipPNG record. Holds raw PNG image data. */ private function readBlipPNG(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance $recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; $pos = 0; // offset: 0; size: 16; rgbUid1 (MD4 digest of) //$rgbUid1 = substr($recordData, 0, 16); $pos += 16; // offset: 16; size: 16; rgbUid2 (MD4 digest), only if $recInstance = 0x46B or 0x6E3 if ($recInstance == 0x06E1) { //$rgbUid2 = substr($recordData, 16, 16); $pos += 16; } // offset: var; size: 1; tag //$tag = ord($recordData[$pos]); ++$pos; // offset: var; size: var; the raw image data $data = substr($recordData, $pos); $blip = new Blip(); $blip->setData($data); $this->applyAttribute('setBlip', $blip); } /** * Read OPT record. This record may occur within DggContainer record or SpContainer. */ private function readOPT(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance $recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; $this->readOfficeArtRGFOPTE($recordData, $recInstance); } /** * Read TertiaryOPT record. */ private function readTertiaryOPT(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance //$recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read SplitMenuColors record. */ private function readSplitMenuColors(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read DgContainer record (Drawing Container). */ private function readDgContainer(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // record is a container, read contents $dgContainer = new DgContainer(); $this->applyAttribute('setDgContainer', $dgContainer); $reader = new self($dgContainer); $reader->load($recordData); } /** * Read Dg record (Drawing). */ private function readDg(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read SpgrContainer record (Shape Group Container). */ private function readSpgrContainer(): void { // context is either context DgContainer or SpgrContainer $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // record is a container, read contents $spgrContainer = new SpgrContainer(); if ($this->object instanceof DgContainer) { // DgContainer $this->object->setSpgrContainer($spgrContainer); } elseif ($this->object instanceof SpgrContainer) { // SpgrContainer $this->object->addChild($spgrContainer); } $reader = new self($spgrContainer); $reader->load($recordData); } /** * Read SpContainer record (Shape Container). */ private function readSpContainer(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // add spContainer to spgrContainer $spContainer = new SpContainer(); $this->applyAttribute('addChild', $spContainer); // move stream pointer to next record $this->pos += 8 + $length; // record is a container, read contents $reader = new self($spContainer); $reader->load($recordData); } /** * Read Spgr record (Shape Group). */ private function readSpgr(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read Sp record (Shape). */ private function readSp(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance //$recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read ClientTextbox record. */ private function readClientTextbox(): void { // offset: 0; size: 2; recVer and recInstance // bit: 4-15; mask: 0xFFF0; recInstance //$recInstance = (0xFFF0 & Xls::getUInt2d($this->data, $this->pos)) >> 4; $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read ClientAnchor record. This record holds information about where the shape is anchored in worksheet. */ private function readClientAnchor(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); $recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; // offset: 2; size: 2; upper-left corner column index (0-based) $c1 = Xls::getUInt2d($recordData, 2); // offset: 4; size: 2; upper-left corner horizontal offset in 1/1024 of column width $startOffsetX = Xls::getUInt2d($recordData, 4); // offset: 6; size: 2; upper-left corner row index (0-based) $r1 = Xls::getUInt2d($recordData, 6); // offset: 8; size: 2; upper-left corner vertical offset in 1/256 of row height $startOffsetY = Xls::getUInt2d($recordData, 8); // offset: 10; size: 2; bottom-right corner column index (0-based) $c2 = Xls::getUInt2d($recordData, 10); // offset: 12; size: 2; bottom-right corner horizontal offset in 1/1024 of column width $endOffsetX = Xls::getUInt2d($recordData, 12); // offset: 14; size: 2; bottom-right corner row index (0-based) $r2 = Xls::getUInt2d($recordData, 14); // offset: 16; size: 2; bottom-right corner vertical offset in 1/256 of row height $endOffsetY = Xls::getUInt2d($recordData, 16); $this->applyAttribute('setStartCoordinates', Coordinate::stringFromColumnIndex($c1 + 1) . ($r1 + 1)); $this->applyAttribute('setStartOffsetX', $startOffsetX); $this->applyAttribute('setStartOffsetY', $startOffsetY); $this->applyAttribute('setEndCoordinates', Coordinate::stringFromColumnIndex($c2 + 1) . ($r2 + 1)); $this->applyAttribute('setEndOffsetX', $endOffsetX); $this->applyAttribute('setEndOffsetY', $endOffsetY); } /** * @param mixed $value */ private function applyAttribute(string $name, $value): void { if (method_exists($this->object, $name)) { $this->object->$name($value); } } /** * Read ClientData record. */ private function readClientData(): void { $length = Xls::getInt4d($this->data, $this->pos + 4); //$recordData = substr($this->data, $this->pos + 8, $length); // move stream pointer to next record $this->pos += 8 + $length; } /** * Read OfficeArtRGFOPTE table of property-value pairs. * * @param string $data Binary data * @param int $n Number of properties */ private function readOfficeArtRGFOPTE($data, $n): void { $splicedComplexData = substr($data, 6 * $n); // loop through property-value pairs for ($i = 0; $i < $n; ++$i) { // read 6 bytes at a time $fopte = substr($data, 6 * $i, 6); // offset: 0; size: 2; opid $opid = Xls::getUInt2d($fopte, 0); // bit: 0-13; mask: 0x3FFF; opid.opid $opidOpid = (0x3FFF & $opid) >> 0; // bit: 14; mask 0x4000; 1 = value in op field is BLIP identifier //$opidFBid = (0x4000 & $opid) >> 14; // bit: 15; mask 0x8000; 1 = this is a complex property, op field specifies size of complex data $opidFComplex = (0x8000 & $opid) >> 15; // offset: 2; size: 4; the value for this property $op = Xls::getInt4d($fopte, 2); if ($opidFComplex) { $complexData = substr($splicedComplexData, 0, $op); $splicedComplexData = substr($splicedComplexData, $op); // we store string value with complex data $value = $complexData; } else { // we store integer value $value = $op; } if (method_exists($this->object, 'setOPT')) { $this->object->setOPT($opidOpid, $value); } } } }