PHPExcel_Shared_OLERead Class Reference

Collaboration diagram for PHPExcel_Shared_OLERead:

Public Member Functions
	read ($sFileName)
	Read the file. More...
	getStream ($stream)
	Extract binary stream data. More...

Data Fields
const	IDENTIFIER_OLE = IDENTIFIER_OLE
const	BIG_BLOCK_SIZE = 0x200
const	SMALL_BLOCK_SIZE = 0x40
const	PROPERTY_STORAGE_BLOCK_SIZE = 0x80
const	SMALL_BLOCK_THRESHOLD = 0x1000
const	NUM_BIG_BLOCK_DEPOT_BLOCKS_POS = 0x2c
const	ROOT_START_BLOCK_POS = 0x30
const	SMALL_BLOCK_DEPOT_BLOCK_POS = 0x3c
const	EXTENSION_BLOCK_POS = 0x44
const	NUM_EXTENSION_BLOCK_POS = 0x48
const	BIG_BLOCK_DEPOT_BLOCKS_POS = 0x4c
const	SIZE_OF_NAME_POS = 0x40
const	TYPE_POS = 0x42
const	START_BLOCK_POS = 0x74
const	SIZE_POS = 0x78
	$wrkbook = null
	$summaryInformation = null
	$documentSummaryInformation = null

Private Member Functions
	_readData ($bl)
	Read a standard stream (by joining sectors using information from SAT) More...
	_readPropertySets ()
	Read entries in the directory stream. More...

Static Private Member Functions
static	_GetInt4d ($data, $pos)
	Read 4 bytes of data at specified position. More...

Private Attributes
	$data = ''

Detailed Description

Definition at line 31 of file OLERead.php.

Member Function Documentation

_GetInt4d()

static PHPExcel_Shared_OLERead::_GetInt4d (   $data,   $pos  )

staticprivate

Read 4 bytes of data at specified position.

Parameters

string	$data
int	$pos

Returns

int

Definition at line 302 of file OLERead.php.

        {
                // FIX: represent numbers correctly on 64-bit system
                // http://sourceforge.net/tracker/index.php?func=detail&aid=1487372&group_id=99160&atid=623334
                // Hacked by Andreas Rehm 2006 to ensure correct result of the <<24 block on 32 and 64bit systems
                $_or_24 = ord($data[$pos + 3]);
                if ($_or_24 >= 128) {
                        // negative number
                        $_ord_24 = -abs((256 - $_or_24) << 24);
                } else {
                        $_ord_24 = ($_or_24 & 127) << 24;
                }
                return ord($data[$pos]) | (ord($data[$pos + 1]) << 8) | (ord($data[$pos + 2]) << 16) | $_ord_24;
        }

References $data.

Referenced by _readData(), _readPropertySets(), getStream(), and read().

Here is the caller graph for this function:

_readData()

PHPExcel_Shared_OLERead::_readData (   $bl )

private

Read a standard stream (by joining sectors using information from SAT)

Parameters

int

$bl

Sector ID where the stream starts

Returns

string Data for standard stream

Definition at line 220 of file OLERead.php.

        {
                $block = $bl;
                $data = '';
 
                while ($block != -2)  {
                        $pos = ($block + 1) * self::BIG_BLOCK_SIZE;
                        $data .= substr($this->data, $pos, self::BIG_BLOCK_SIZE);
                        $block = self::_GetInt4d($this->bigBlockChain, $block*4);
                }
                return $data;
         }

References $data, _GetInt4d(), and data.

Referenced by getStream(), and read().

Here is the call graph for this function:

Here is the caller graph for this function:

_readPropertySets()

PHPExcel_Shared_OLERead::_readPropertySets ( )

private

Read entries in the directory stream.

Definition at line 236 of file OLERead.php.

                                             {
                $offset = 0;
 
                // loop through entires, each entry is 128 bytes
                $entryLen = strlen($this->entry);
                while ($offset < $entryLen) {
                        // entry data (128 bytes)
                        $d = substr($this->entry, $offset, self::PROPERTY_STORAGE_BLOCK_SIZE);
 
                        // size in bytes of name
                        $nameSize = ord($d[self::SIZE_OF_NAME_POS]) | (ord($d[self::SIZE_OF_NAME_POS+1]) << 8);
 
                        // type of entry
                        $type = ord($d[self::TYPE_POS]);
 
                        // sectorID of first sector or short sector, if this entry refers to a stream (the case with workbook)
                        // sectorID of first sector of the short-stream container stream, if this entry is root entry
                        $startBlock = self::_GetInt4d($d, self::START_BLOCK_POS);
 
                        $size = self::_GetInt4d($d, self::SIZE_POS);
 
                        $name = str_replace("\x00", "", substr($d,0,$nameSize));
 
 
                        $this->props[] = array (
                                'name' => $name,
                                'type' => $type,
                                'startBlock' => $startBlock,
                                'size' => $size);
 
                        // tmp helper to simplify checks
                        $upName = strtoupper($name);
 
                        // Workbook directory entry (BIFF5 uses Book, BIFF8 uses Workbook)
                        if (($upName === 'WORKBOOK') || ($upName === 'BOOK')) {
                                $this->wrkbook = count($this->props) - 1;
                        }
                        else if ( $upName === 'ROOT ENTRY' || $upName === 'R') {
                                // Root entry
                                $this->rootentry = count($this->props) - 1;
                        }
 
                        // Summary information
                        if ($name == chr(5) . 'SummaryInformation') {
//                              echo 'Summary Information<br />';
                                $this->summaryInformation = count($this->props) - 1;
                        }
 
                        // Additional Document Summary information
                        if ($name == chr(5) . 'DocumentSummaryInformation') {
//                              echo 'Document Summary Information<br />';
                                $this->documentSummaryInformation = count($this->props) - 1;
                        }
 
                        $offset += self::PROPERTY_STORAGE_BLOCK_SIZE;
                }
 
        }

References $d, $name, $size, $type, _GetInt4d(), and PROPERTY_STORAGE_BLOCK_SIZE.

Referenced by read().

Here is the call graph for this function:

Here is the caller graph for this function:

getStream()

PHPExcel_Shared_OLERead::getStream

(

$stream

)

Extract binary stream data.

Returns

string

Definition at line 173 of file OLERead.php.

        {
                if ($stream === NULL) {
                        return null;
                }
 
                $streamData = '';
 
                if ($this->props[$stream]['size'] < self::SMALL_BLOCK_THRESHOLD) {
                        $rootdata = $this->_readData($this->props[$this->rootentry]['startBlock']);
 
                        $block = $this->props[$stream]['startBlock'];
 
                        while ($block != -2) {
                                $pos = $block * self::SMALL_BLOCK_SIZE;
                                $streamData .= substr($rootdata, $pos, self::SMALL_BLOCK_SIZE);
 
                                $block = self::_GetInt4d($this->smallBlockChain, $block*4);
                        }
 
                        return $streamData;
                } else {
                        $numBlocks = $this->props[$stream]['size'] / self::BIG_BLOCK_SIZE;
                        if ($this->props[$stream]['size'] % self::BIG_BLOCK_SIZE != 0) {
                                ++$numBlocks;
                        }
 
                        if ($numBlocks == 0) return '';
 
                        $block = $this->props[$stream]['startBlock'];
 
                        while ($block != -2) {
                                $pos = ($block + 1) * self::BIG_BLOCK_SIZE;
                                $streamData .= substr($this->data, $pos, self::BIG_BLOCK_SIZE);
                                $block = self::_GetInt4d($this->bigBlockChain, $block*4);
                        }
 
                        return $streamData;
                }
        }

References GuzzleHttp\Psr7\$stream, _GetInt4d(), _readData(), BIG_BLOCK_SIZE, data, and SMALL_BLOCK_SIZE.

Here is the call graph for this function:

read()

PHPExcel_Shared_OLERead::read

(

$sFileName

)

Read the file.

Parameters

$sFileName

string Filename

Exceptions

PHPExcel_Reader_Exception

Definition at line 76 of file OLERead.php.

        {
                // Check if file exists and is readable
                if(!is_readable($sFileName)) {
                        throw new PHPExcel_Reader_Exception("Could not open " . $sFileName . " for reading! File does not exist, or it is not readable.");
                }
 
                // Get the file identifier
                // Don't bother reading the whole file until we know it's a valid OLE file
                $this->data = file_get_contents($sFileName, FALSE, NULL, 0, 8);
 
                // Check OLE identifier
                if ($this->data != self::IDENTIFIER_OLE) {
                        throw new PHPExcel_Reader_Exception('The filename ' . $sFileName . ' is not recognised as an OLE file');
                }
 
                // Get the file data
                $this->data = file_get_contents($sFileName);
 
                // Total number of sectors used for the SAT
                $this->numBigBlockDepotBlocks = self::_GetInt4d($this->data, self::NUM_BIG_BLOCK_DEPOT_BLOCKS_POS);
 
                // SecID of the first sector of the directory stream
                $this->rootStartBlock = self::_GetInt4d($this->data, self::ROOT_START_BLOCK_POS);
 
                // SecID of the first sector of the SSAT (or -2 if not extant)
                $this->sbdStartBlock = self::_GetInt4d($this->data, self::SMALL_BLOCK_DEPOT_BLOCK_POS);
 
                // SecID of the first sector of the MSAT (or -2 if no additional sectors are used)
                $this->extensionBlock = self::_GetInt4d($this->data, self::EXTENSION_BLOCK_POS);
 
                // Total number of sectors used by MSAT
                $this->numExtensionBlocks = self::_GetInt4d($this->data, self::NUM_EXTENSION_BLOCK_POS);
 
                $bigBlockDepotBlocks = array();
                $pos = self::BIG_BLOCK_DEPOT_BLOCKS_POS;
 
                $bbdBlocks = $this->numBigBlockDepotBlocks;
 
                if ($this->numExtensionBlocks != 0) {
                        $bbdBlocks = (self::BIG_BLOCK_SIZE - self::BIG_BLOCK_DEPOT_BLOCKS_POS)/4;
                }
 
                for ($i = 0; $i < $bbdBlocks; ++$i) {
                          $bigBlockDepotBlocks[$i] = self::_GetInt4d($this->data, $pos);
                          $pos += 4;
                }
 
                for ($j = 0; $j < $this->numExtensionBlocks; ++$j) {
                        $pos = ($this->extensionBlock + 1) * self::BIG_BLOCK_SIZE;
                        $blocksToRead = min($this->numBigBlockDepotBlocks - $bbdBlocks, self::BIG_BLOCK_SIZE / 4 - 1);
 
                        for ($i = $bbdBlocks; $i < $bbdBlocks + $blocksToRead; ++$i) {
                                $bigBlockDepotBlocks[$i] = self::_GetInt4d($this->data, $pos);
                                $pos += 4;
                        }
 
                        $bbdBlocks += $blocksToRead;
                        if ($bbdBlocks < $this->numBigBlockDepotBlocks) {
                                $this->extensionBlock = self::_GetInt4d($this->data, $pos);
                        }
                }
 
                $pos = 0;
                $this->bigBlockChain = '';
                $bbs = self::BIG_BLOCK_SIZE / 4;
                for ($i = 0; $i < $this->numBigBlockDepotBlocks; ++$i) {
                        $pos = ($bigBlockDepotBlocks[$i] + 1) * self::BIG_BLOCK_SIZE;
 
                        $this->bigBlockChain .= substr($this->data, $pos, 4*$bbs);
                        $pos += 4*$bbs;
                }
 
                $pos = 0;
                $sbdBlock = $this->sbdStartBlock;
                $this->smallBlockChain = '';
                while ($sbdBlock != -2) {
                        $pos = ($sbdBlock + 1) * self::BIG_BLOCK_SIZE;
 
                        $this->smallBlockChain .= substr($this->data, $pos, 4*$bbs);
                        $pos += 4*$bbs;
 
                        $sbdBlock = self::_GetInt4d($this->bigBlockChain, $sbdBlock*4);
                }
 
                // read the directory stream
                $block = $this->rootStartBlock;
                $this->entry = $this->_readData($block);
 
                $this->_readPropertySets();
        }

References $i, _GetInt4d(), _readData(), _readPropertySets(), BIG_BLOCK_DEPOT_BLOCKS_POS, and data.

Here is the call graph for this function:

Field Documentation

$data

PHPExcel_Shared_OLERead::$data = ''

private

Definition at line 32 of file OLERead.php.

Referenced by _GetInt4d(), and _readData().

$documentSummaryInformation

PHPExcel_Shared_OLERead::$documentSummaryInformation = null

Definition at line 67 of file OLERead.php.

$summaryInformation

PHPExcel_Shared_OLERead::$summaryInformation = null

Definition at line 66 of file OLERead.php.

$wrkbook

PHPExcel_Shared_OLERead::$wrkbook = null

Definition at line 65 of file OLERead.php.

BIG_BLOCK_DEPOT_BLOCKS_POS

const PHPExcel_Shared_OLERead::BIG_BLOCK_DEPOT_BLOCKS_POS = 0x4c

Definition at line 55 of file OLERead.php.

Referenced by read().

BIG_BLOCK_SIZE

const PHPExcel_Shared_OLERead::BIG_BLOCK_SIZE = 0x200

Definition at line 38 of file OLERead.php.

Referenced by getStream().

EXTENSION_BLOCK_POS

const PHPExcel_Shared_OLERead::EXTENSION_BLOCK_POS = 0x44

Definition at line 53 of file OLERead.php.

IDENTIFIER_OLE

const PHPExcel_Shared_OLERead::IDENTIFIER_OLE = IDENTIFIER_OLE

Definition at line 35 of file OLERead.php.

NUM_BIG_BLOCK_DEPOT_BLOCKS_POS

const PHPExcel_Shared_OLERead::NUM_BIG_BLOCK_DEPOT_BLOCKS_POS = 0x2c

Definition at line 50 of file OLERead.php.

NUM_EXTENSION_BLOCK_POS

const PHPExcel_Shared_OLERead::NUM_EXTENSION_BLOCK_POS = 0x48

Definition at line 54 of file OLERead.php.

PROPERTY_STORAGE_BLOCK_SIZE

const PHPExcel_Shared_OLERead::PROPERTY_STORAGE_BLOCK_SIZE = 0x80

Definition at line 44 of file OLERead.php.

Referenced by _readPropertySets().

ROOT_START_BLOCK_POS

const PHPExcel_Shared_OLERead::ROOT_START_BLOCK_POS = 0x30

Definition at line 51 of file OLERead.php.

SIZE_OF_NAME_POS

const PHPExcel_Shared_OLERead::SIZE_OF_NAME_POS = 0x40

Definition at line 58 of file OLERead.php.

SIZE_POS

const PHPExcel_Shared_OLERead::SIZE_POS = 0x78

Definition at line 61 of file OLERead.php.

SMALL_BLOCK_DEPOT_BLOCK_POS

const PHPExcel_Shared_OLERead::SMALL_BLOCK_DEPOT_BLOCK_POS = 0x3c

Definition at line 52 of file OLERead.php.

SMALL_BLOCK_SIZE

const PHPExcel_Shared_OLERead::SMALL_BLOCK_SIZE = 0x40

Definition at line 41 of file OLERead.php.

Referenced by getStream().

SMALL_BLOCK_THRESHOLD

const PHPExcel_Shared_OLERead::SMALL_BLOCK_THRESHOLD = 0x1000

Definition at line 47 of file OLERead.php.

START_BLOCK_POS

const PHPExcel_Shared_OLERead::START_BLOCK_POS = 0x74

Definition at line 60 of file OLERead.php.

TYPE_POS

const PHPExcel_Shared_OLERead::TYPE_POS = 0x42

Definition at line 59 of file OLERead.php.

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/OLERead.php