XLS_BIFF8
XLS_BIFF8 = 1536
PHPExcel_Reader_Excel5
This class uses http://sourceforge.net/projects/phpexcelreader/parseXL
$_readFilter : \PHPExcel_Reader_IReadFilter
PHPExcel_Reader_IReadFilter instance
$_phpExcel : \PHPExcel
Workbook to be returned by the reader.
$_phpSheet : \PHPExcel_Worksheet
Worksheet that is currently being built by the reader.
$_rc4Key : \PHPExcel_Reader_Excel5_RC4
The current RC4 decryption object
setReadDataOnly(boolean $pValue = FALSE) : \PHPExcel_Reader_IReader
Set read data only Set to true, to advise the Reader only to read data values for cells, and to ignore any formatting information.
Set to false (the default) to advise the Reader to read both data and formatting for cells.
| boolean | $pValue |
getIncludeCharts() : boolean
Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook.
Note that a ReadDataOnly value of false overrides, and charts won't be read regardless of the IncludeCharts value. If false (the default) it will ignore any charts defined in the workbook file.
setIncludeCharts(boolean $pValue = FALSE) : \PHPExcel_Reader_IReader
Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook.
Note that a ReadDataOnly value of false overrides, and charts won't be read regardless of the IncludeCharts value. Set to false (the default) to discard charts.
| boolean | $pValue |
setLoadSheetsOnly(mixed $value = NULL) : \PHPExcel_Reader_IReader
Set which sheets to load
| mixed | $value | This should be either an array of worksheet names to be loaded, or a string containing a single worksheet name. If NULL, then it tells the Reader to read all worksheets in the workbook |
setLoadAllSheets() : \PHPExcel_Reader_IReader
Set all sheets to load Tells the Reader to load all worksheets from the workbook.
getReadFilter() : \PHPExcel_Reader_IReadFilter
Read filter
setReadFilter(\PHPExcel_Reader_IReadFilter $pValue) : \PHPExcel_Reader_IReader
Set read filter
| \PHPExcel_Reader_IReadFilter | $pValue |
load(string $pFilename) : \PHPExcel
Loads PHPExcel from file
| string | $pFilename |
_readFilepass()
FILEPASS
This record is part of the File Protection Block. It contains information about the read/write password of the file. All record contents following this record will be encrypted.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
The decryption functions and objects used from here on in are based on the source of Spreadsheet-ParseExcel: http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel/
_makeKey( $block, $valContext) : \PHPExcel_Reader_Excel5_RC4
Make an RC4 decryptor for the given block
| $block | ||
| $valContext |
_readDateMode()
DATEMODE
This record specifies the base date for displaying date values. All dates are stored as count of days past this base date. In BIFF2-BIFF4 this record is part of the Calculation Settings Block. In BIFF5-BIFF8 it is stored in the Workbook Globals Substream.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readFormat()
FORMAT
This record contains information about a number format. All FORMAT records occur together in a sequential list.
In BIFF2-BIFF4 other records referencing a FORMAT record contain a zero-based index into this list. From BIFF5 on the FORMAT record contains the index itself that will be used by other records.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readXf()
XF - Extended Format
This record contains formatting information for cells, rows, columns or styles. According to http://support.microsoft.com/kb/147732 there are always at least 15 cell style XF and 1 cell XF. Inspection of Excel files generated by MS Office Excel shows that XF records 0-14 are cell style XF and XF record 15 is a cell XF We only read the first cell style XF and skip the remaining cell style XF records We read all cell XF records.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readSheet()
SHEET
This record is located in the Workbook Globals Substream and represents a sheet inside the workbook. One SHEET record is written for each sheet. It stores the sheet name and a stream offset to the BOF record of the respective Sheet Substream within the Workbook Stream.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readDefinedName()
DEFINEDNAME
This record is part of a Link Table. It contains the name and the token array of an internal defined name. Token arrays of defined names contain tokens with aberrant token classes.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readRk()
Read RK record This record represents a cell that contains an RK value (encoded integer or floating-point value). If a floating-point value cannot be encoded to an RK value, a NUMBER record will be written. This record replaces the record INTEGER written in BIFF2.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_readString() : string
Read a STRING record from current stream position and advance the stream pointer to next record This record is used for storing result from FORMULA record when it is a string, and it occurs directly after the FORMULA record
The string contents as UTF-8
_readLabel()
Read LABEL record This record represents a cell that contains a string. In BIFF8 it is usually replaced by the LABELSST record.
Excel still uses this record, if it copies unformatted text cells to the clipboard.
-- "OpenOffice.org's Documentation of the Microsoft Excel File Format"
_getSplicedRecordData() : array
Reads a record from current position in data stream and continues reading data as long as CONTINUE records are found. Splices the record data pieces and returns the combined string as if record data is in one piece.
Moves to next current position in data stream to start of next record different from a CONtINUE record
_getFormulaFromStructure(string $formulaStructure, string $baseCell = 'A1') : string
Convert formula structure into human readable Excel formula like 'A3+A5*5'
| string | $formulaStructure | The complete binary data for the formula |
| string | $baseCell | Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas |
Human readable formula
_getFormulaFromData(string $formulaData, string $additionalData = '', string $baseCell = 'A1') : string
Take formula data and additional data for formula and return human readable formula
| string | $formulaData | The binary data for the formula itself |
| string | $additionalData | Additional binary data going with the formula |
| string | $baseCell | Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas |
Human readable formula
_createFormulaFromTokens(array $tokens, array $additionalData) : string
Take array of tokens together with additional data for formula and return human readable formula
| array | $tokens | |
| array | $additionalData | Additional binary data going with the formula |
Human readable formula
_readBIFF8CellAddressB(string $cellAddressStructure, string $baseCell = 'A1') : string
Reads a cell address in BIFF8 for shared formulas. Uses positive and negative values for row and column to indicate offsets from a base cell section 3.3.4
| string | $cellAddressStructure | |
| string | $baseCell | Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas |
_readBIFF8CellRangeAddressB(string $subData, string $baseCell = 'A1') : string
Reads a cell range address in BIFF8 for shared formulas. Uses positive and negative values for row and column to indicate offsets from a base cell section 3.3.4
| string | $subData | |
| string | $baseCell | Base cell |
Cell range address
_readSheetRangeByRefIndex(integer $index) : string|false
Get a sheet range like Sheet1:Sheet3 from REF index Note: If there is only one sheet in the range, one gets e.g Sheet1 It can also happen that the REF structure uses the -1 (FFFF) code to indicate deleted sheets, in which case an PHPExcel_Reader_Exception is thrown
| integer | $index |
_readUnicodeString(string $subData, integer $characterCount) : array
Read Unicode string with no string length field, but with known character count this function is under construction, needs to support rich text, and Asian phonetic settings OpenOffice.org's Documentation of the Microsoft Excel File Format, section 2.5.3
| string | $subData | |
| integer | $characterCount |