tzeg6@T+ f,c>o⌻wRW/ ‹KgMzPny\F7nXoāKJg EB? Cez>^^$/fЁ1. ?c6ir;*{4N;@a-ɉ53j`?<:A0׶,)ՈGsB =- lN i|E2ZyCFaj^{u->3CS._51/0uO;%*iJ Ѫ. ^1)I/x0@pT,%RbUX%txPG[< ϴXxWSP|8G0\p7v I&K:h n;'; 0kx8{aiS43ݑսuE_vs+y* ORrO5Ick=<1I F &ޑ䘗kpbq&0Bw̱1HL`H$־H$IIS0NSO}%bۗCF*Yu^̏My4Z4}hp/ &hj+o33q>ϡ*jތ,ssw` >X!S-4 SA-}aAt+w)/1ww)2xjAS2Rw`qN< `u:*́ o:*'d}׳ ֗ӣ/WbnTpp?QsCamvD `lc7`tYR RqnZZX,i+ޱyPP/aJт0 m^K\V=$X0sۑ*{˥80Q%נ'L# @^R8hJX `9u4YbTg.5*'}6O  T ׃9'jRYy^c8nn&,`\f8nn&,`\f=}M*>c}dr1Hz Zع4i {N#QdeݩDRwcxx1UИ Mc2+SXzA@$k׉k\h2Fi7T ZܐǛ-$ %RYp<&tԓRIsgiDn/U Ǿ}BhYTe /cnoˆv>eE>AUbt9FX2qwemXO1P! vp#ZP왲;X7W״M|j\3_ϳƣC,}Ԇ*!Ú0&+TՂ|) =݉ȰK~PwGr]3wLSQu@埒=&?} <XPJ3|Mz~6B cDz̈́h)ӆ)Fʶp?.8(@CRIsgiDnNJБL"Q:a4 4 X6ݷt   pT.l1#B`@Qã5՝Rot=e$YV6mW]Ew6׈lkllh<_`m"|H|bd">;]߉E[5|=" O` ͘#%=NiHG}/xQ瑄&XL׎g:tٛahqOV+wJ#_]LmOhm#+5e.c3B[cyK\U{r?V2A&)C4确guj{CfT,i$݈ nLfBmr kYwLBU C,%_~ ik7JoFP>eNC]$ (eԔS !gmT~qArs cDz̈́Lhs\@>vMG$YytNYp N[CּUjV}:q"9ӝ V-_GX3b̧ 39.S#yySH, J-yCnI:T hýqf\ nUҲZy[>!oSGZ=s}_o m$߀8&Es{e 3j1Rr1A"f<~٧k>)$9O|@B $+`+VQS 8vupuER3 6CvADzD. V>(EW9"x9b)6WJPzϖF0s_]9 _(I pK^_"'w l!?Gy[~sU?]R`qi&vq2& .g,gӄl #ي!UK,)3ɑvՏ3Jt:fWE hj&Hbٟ֫1*z6%t%Hm/,i$݈ nLfBmr kYwLBU C,%_~ ik7JoFP>eNC]Ts~-x79׺};ZB #v GxvDYhY2hXAF"<jW#*c:%>;Rq([VarGD_d"Z|!bO fة8g-ɋ%z$!gqmt7*YפHtʾGCNy)'eۧ`pⶖE%er-open"> JAMA For an m-by-n matrix A with m >= n, the singular value decomposition is an m-by-n orthogonal matrix U, an n-by-n diagonal matrix S, and an n-by-n orthogonal matrix V so that A = U*S*V'
  •  JAMA Pythagorean Theorem: a = 3 b = 4 r = sqrt(square(a) + square(b)) r = 5 r = sqrt(a^2 + b^2) without under/overflow
  •  PHPExcel
    • Back to top  

    PHPExcel_Reader_Excel5

    This class uses http://sourceforge.net/projects/phpexcelreader/parseXL

    category PHPExcel
    package PHPExcel_Reader_Excel5
    copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

     Methods

    Read 16-bit unsigned integer

    _GetInt2d(string $data, int $pos) : int
    Static

    Parameters

    $data

    string

    $pos

    int

    Returns

    int

    Read 32-bit signed integer

    _GetInt4d(string $data, int $pos) : int
    Static

    Parameters

    $data

    string

    $pos

    int

    Returns

    int

    Create a new PHPExcel_Reader_Excel5 instance

    __construct() 

    Can the current PHPExcel_Reader_IReader read the file?

    canRead(string $pFilename) : boolean

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    boolean

    Read charts in workbook? If this is true, then the Reader will include any charts that exist in the workbook.

    getIncludeCharts() : boolean
    Inherited

    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.

    inherited_from \PHPExcel_Reader_Abstract::getIncludeCharts()

    Returns

    boolean

    Get which sheets to load Returns either an array of worksheet names (the list of worksheets that should be loaded), or a null indicating that all worksheets in the workbook should be loaded.

    getLoadSheetsOnly() : mixed
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::getLoadSheetsOnly()

    Returns

    mixed

    Read data only? If this is true, then the Reader will only read data values for cells, it will not read any formatting information.

    getReadDataOnly() : boolean
    Inherited

    If false (the default) it will read data and formatting.

    inherited_from \PHPExcel_Reader_Abstract::getReadDataOnly()

    Returns

    boolean

    Read filter

    getReadFilter() : \PHPExcel_Reader_IReadFilter
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::getReadFilter()

    Returns

    \PHPExcel_Reader_IReadFilter

    Return worksheet info (Name, Last Column Letter, Last Column Index, Total Rows, Total Columns)

    listWorksheetInfo(string $pFilename) 

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Reads names of the worksheets from a file, without parsing the whole file to a PHPExcel object

    listWorksheetNames(string $pFilename) 

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Loads PHPExcel from file

    load(string $pFilename) : \PHPExcel

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    \PHPExcel

    Set read charts in workbook Set to true, to advise the Reader to include any charts that exist in the workbook.

    setIncludeCharts(boolean $pValue) : \PHPExcel_Reader_IReader
    Inherited

    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.

    inherited_from \PHPExcel_Reader_Abstract::setIncludeCharts()

    Parameters

    $pValue

    boolean

    Returns

    \PHPExcel_Reader_IReader

    Set all sheets to load Tells the Reader to load all worksheets from the workbook.

    setLoadAllSheets() : \PHPExcel_Reader_IReader
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::setLoadAllSheets()

    Returns

    \PHPExcel_Reader_IReader

    Set which sheets to load

    setLoadSheetsOnly(mixed $value) : \PHPExcel_Reader_IReader
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::setLoadSheetsOnly()

    Parameters

    $value

    mixed

    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

    Returns

    \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.

    setReadDataOnly(boolean $pValue) : \PHPExcel_Reader_IReader
    Inherited

    Set to false (the default) to advise the Reader to read both data and formatting for cells.

    inherited_from \PHPExcel_Reader_Abstract::setReadDataOnly()

    Parameters

    $pValue

    boolean

    Returns

    \PHPExcel_Reader_IReader

    Set read filter

    setReadFilter(\PHPExcel_Reader_IReadFilter $pValue) : \PHPExcel_Reader_IReader
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::setReadFilter()

    Parameters

    $pValue

    \PHPExcel_Reader_IReadFilter

    Returns

    \PHPExcel_Reader_IReader

    Open file for reading

    _openFile(string $pFilename) : resource
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::_openFile()

    Parameters

    $pFilename

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    resource

    _GetIEEE754() 

    _GetIEEE754($rknum) 
    Static

    Parameters

    $rknum

    Convert UTF-8 string to string surounded by double quotes.

    _UTF8toExcelDoubleQuoted(string $value) : string
    Static

    Used for explicit string tokens in formulas. Example: hello"world --> "hello""world"

    Parameters

    $value

    string

    UTF-8 encoded string

    Returns

    string

    Take array of tokens together with additional data for formula and return human readable formula

    _createFormulaFromTokens(array $tokens, array $additionalData) : string

    Parameters

    $tokens

    array

    $additionalData

    array

    Additional binary data going with the formula

    Returns

    stringHuman readable formula

    Convert string to UTF-8.

    _decodeCodepage(string $string) : string

    Only used for BIFF5.

    Parameters

    $string

    string

    Returns

    string

    Get UTF-8 string from (compressed or uncompressed) UTF-16 string

    _encodeUTF16(string $string, bool $compressed) : string
    Static

    Parameters

    $string

    string

    $compressed

    bool

    Returns

    string

    Reads first 8 bytes of a string and return IEEE 754 float

    _extractNumber(string $data) : float
    Static

    Parameters

    $data

    string

    Binary string that is at least 8 bytes long

    Returns

    float

    Take formula data and additional data for formula and return human readable formula

    _getFormulaFromData(string $formulaData, string $additionalData, string $baseCell) : string

    Parameters

    $formulaData

    string

    The binary data for the formula itself

    $additionalData

    string

    Additional binary data going with the formula

    $baseCell

    string

    Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas

    Returns

    stringHuman readable formula

    Convert formula structure into human readable Excel formula like 'A3+A5*5'

    _getFormulaFromStructure(string $formulaStructure, string $baseCell) : string

    Parameters

    $formulaStructure

    string

    The complete binary data for the formula

    $baseCell

    string

    Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas

    Returns

    stringHuman readable formula

    Fetch next token from binary formula data

    _getNextToken(string $formulaData, string $baseCell) : array

    Parameters

    $formulaData

    string

    Formula data

    $baseCell

    string

    Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    array

    Reads a record from current position in data stream and continues reading data as long as CONTINUE records are found.

    _getSplicedRecordData() : array

    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

    Returns

    array

    _includeCellRangeFiltered() 

    _includeCellRangeFiltered($cellRangeAddress) 

    Parameters

    $cellRangeAddress

    Use OLE reader to extract the relevant data streams from the OLE file

    _loadOLE(string $pFilename) 

    Parameters

    $pFilename

    string

    Make an RC4 decryptor for the given block

    _makeKey($block, $valContext) : \PHPExcel_Reader_Excel5_RC4
    var

    Block for which to create decrypto
    var

    MD5 context state

    Parameters

    $block

    $valContext

    Returns

    \PHPExcel_Reader_Excel5_RC4

    Map border style OpenOffice documentation: 2.5.11

    _mapBorderStyle(int $index) : string
    Static

    Parameters

    $index

    int

    Returns

    string

    Map built-in color to RGB value

    _mapBuiltInColor(int $color) : array
    Static

    Parameters

    $color

    int

    Indexed color

    Returns

    array

    Map color array from BIFF8 built-in color index

    _mapColor(int $subData) : array
    Static

    Parameters

    $subData

    int

    Returns

    array

    Map color array from BIFF5 built-in color index

    _mapColorBIFF5(int $subData) : array
    Static

    Parameters

    $subData

    int

    Returns

    array

    Map error code, e.g.

    _mapErrorCode(int $subData) : string
    Static

    '#N/A'

    Parameters

    $subData

    int

    Returns

    string

    Get fill pattern from index OpenOffice documentation: 2.5.12

    _mapFillPattern(int $index) : string
    Static

    Parameters

    $index

    int

    Returns

    string

    _parseRichText() 

    _parseRichText($is) 

    Parameters

    $is

    Reads a cell range address in BIFF5 e.g.

    _readBIFF5CellRangeAddressFixed(string $subData) : string

    'A2:B6' or 'A1' always fixed range section 2.5.14

    Parameters

    $subData

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    string

    Read BIFF5 cell range address list section 2.5.15

    _readBIFF5CellRangeAddressList(string $subData) : array

    Parameters

    $subData

    string

    Returns

    array

    Reads a cell address in BIFF8 e.g.

    _readBIFF8CellAddress(string $cellAddressStructure) : string

    'A2' or '$A$2' section 3.3.4

    Parameters

    $cellAddressStructure

    string

    Returns

    string

    Reads a cell address in BIFF8 for shared formulas.

    _readBIFF8CellAddressB(string $cellAddressStructure, string $baseCell) : string

    Uses positive and negative values for row and column to indicate offsets from a base cell section 3.3.4

    Parameters

    $cellAddressStructure

    string

    $baseCell

    string

    Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas

    Returns

    string

    Reads a cell range address in BIFF8 e.g.

    _readBIFF8CellRangeAddress(string $subData) : string

    'A2:B6' or '$A$2:$B$6' there are flags indicating whether column/row index is relative section 3.3.4

    Parameters

    $subData

    string

    Returns

    string

    Reads a cell range address in BIFF8 for shared formulas.

    _readBIFF8CellRangeAddressB(string $subData, string $baseCell) : string

    Uses positive and negative values for row and column to indicate offsets from a base cell section 3.3.4

    Parameters

    $subData

    string

    $baseCell

    string

    Base cell

    Returns

    stringCell range address

    Reads a cell range address in BIFF8 e.g.

    _readBIFF8CellRangeAddressFixed(string $subData) : string

    'A2:B6' or 'A1' always fixed range section 2.5.14

    Parameters

    $subData

    string

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    string

    Read BIFF8 cell range address list section 2.5.15

    _readBIFF8CellRangeAddressList(string $subData) : array

    Parameters

    $subData

    string

    Returns

    array

    read BIFF8 constant value which may be 'Empty Value', 'Number', 'String Value', 'Boolean Value', 'Error Value' section 2.5.7 returns e.g.

    _readBIFF8Constant(string $valueData) : array
    Static

    array('value' => '5', 'size' => 9)

    Parameters

    $valueData

    string

    Returns

    array

    read BIFF8 constant value array from array data returns e.g.

    _readBIFF8ConstantArray(string $arrayData) : array
    Static

    array('value' => '{1,2;3,4}', 'size' => 40} section 2.5.8

    Parameters

    $arrayData

    string

    Returns

    array

    Read BLANK record

    _readBlank() 

    Read BOF

    _readBof() 

    Read BOOLERR record This record represents a Boolean value or error value cell.

    _readBoolErr() 

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read BOTTOMMARGIN record

    _readBottomMargin() 

    Read byte string (16-bit string length) OpenOffice documentation: 2.5.2

    _readByteStringLong(string $subData) : array

    Parameters

    $subData

    string

    Returns

    array

    Read byte string (8-bit string length) OpenOffice documentation: 2.5.2

    _readByteStringShort(string $subData) : array

    Parameters

    $subData

    string

    Returns

    array

    CODEPAGE

    _readCodepage() 

    This record stores the text encoding used to write byte strings, stored as MS Windows code page identifier.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read COLINFO record

    _readColInfo() 

    Read color

    _readColor(int $color, array $palette, $version) : array
    Static

    Parameters

    $color

    int

    Indexed color

    $palette

    array

    Color palette

    $version

    Returns

    arrayRGB color value, example: array('rgb' => 'FF0000')

    Read a free CONTINUE record.

    _readContinue() 

    Free CONTINUE record may be a camouflaged MSODRAWING record When MSODRAWING data on a sheet exceeds 8224 bytes, CONTINUE records are used instead. Undocumented. In this case, we must treat the CONTINUE record as a MSODRAWING record

    Read DATAVALIDATION record

    _readDataValidation() 

    Read DATAVALIDATIONS record

    _readDataValidations() 

    DATEMODE

    _readDateMode() 

    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"

    Read DEFCOLWIDTH record

    _readDefColWidth() 

    Reads a general type of BIFF record.

    _readDefault() 

    Does nothing except for moving stream pointer forward to next record.

    Read DEFAULTROWHEIGHT record

    _readDefaultRowHeight() 

    DEFINEDNAME

    _readDefinedName() 

    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"

    Read additional document summary information

    _readDocumentSummaryInformation() 

    Read EXTERNNAME record.

    _readExternName() 

    Read EXTERNSHEET record

    _readExternSheet() 

    Read EXTERNALBOOK record

    _readExternalBook() 

    FILEPASS

    _readFilepass() 

    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/

    Read a FONT record

    _readFont() 

    Read FOOTER record

    _readFooter() 

    FORMAT

    _readFormat() 

    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"

    Read FORMULA record + perhaps a following STRING record if formula result is a string This record contains the token array and the result of a formula cell.

    _readFormula() 

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read HCENTER record

    _readHcenter() 

    Read HEADER record

    _readHeader() 

    Read HORIZONTALPAGEBREAKS record

    _readHorizontalPageBreaks() 

    Read HYPERLINK record

    _readHyperLink() 

    Read IMDATA record

    _readImData() 

    Read LABEL record This record represents a cell that contains a string.

    _readLabel() 

    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"

    Read LABELSST record This record represents a cell that contains a string.

    _readLabelSst() 

    It replaces the LABEL record and RSTRING record used in BIFF2-BIFF5.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read LEFTMARGIN record

    _readLeftMargin() 

    MERGEDCELLS

    _readMergedCells() 

    This record contains the addresses of merged cell ranges in the current sheet.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read MSODRAWING record

    _readMsoDrawing() 

    Read MSODRAWINGGROUP record

    _readMsoDrawingGroup() 

    Read MULBLANK record This record represents a cell range of empty cells.

    _readMulBlank() 

    All cells are located in the same row

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read MULRK record This record represents a cell range containing RK value cells.

    _readMulRk() 

    All cells are located in the same row.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    The NOTE record specifies a comment associated with a particular cell.

    _readNote() 

    In Excel 95 (BIFF7) and earlier versions, this record stores a note (cell note). This feature was significantly enhanced in Excel 97.

    Read NUMBER record This record represents a cell that contains a floating-point value.

    _readNumber() 

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    Read OBJ record

    _readObj() 

    OBJECTPROTECT

    _readObjectProtect() 

    Read PLV Record(Created by Excel2007 or upper)

    _readPageLayoutView() 

    Read PAGESETUP record

    _readPageSetup() 

    Read PALETTE record

    _readPalette() 

    Read PANE record

    _readPane() 

    PASSWORD - Sheet protection (hashed) password (BIFF2 through BIFF8)

    _readPassword() 

    Read PRINTGRIDLINES record

    _readPrintGridlines() 

    PROTECT - Sheet protection (BIFF2 through BIFF8) if this record is omitted, then it also means no sheet protection

    _readProtect() 

    Extract RGB color OpenOffice.org's Documentation of the Microsoft Excel File Format, section 2.5.4

    _readRGB(string $rgb) : array
    Static

    Parameters

    $rgb

    string

    Encoded RGB value (4 bytes)

    Returns

    array

    Read RANGEPROTECTION record Reading of this record is based on Microsoft Office Excel 97-2000 Binary File Format Specification, where it is referred to as FEAT record

    _readRangeProtection() 

    Read record data from stream, decrypting as required

    _readRecordData(string $data, int $pos, $len) : string

    Parameters

    $data

    string

    Data stream to read from

    $pos

    int

    Position to start reading from

    $len

    Returns

    stringRecord data

    Read RIGHTMARGIN record

    _readRightMargin() 

    Read RK record This record represents a cell that contains an RK value (encoded integer or floating-point value).

    _readRk() 

    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"

    ROW

    _readRow() 

    This record contains the properties of a single row in a sheet. Rows and cells in a sheet are divided into blocks of 32 rows.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    SCENPROTECT

    _readScenProtect() 

    Read SCL record

    _readScl() 

    Read SELECTION record.

    _readSelection() 

    There is one such record for each pane in the sheet.

    Read a SHAREDFMLA record.

    _readSharedFmla() 

    This function just stores the binary shared formula in the reader, which usually contains relative references. These will be used to construct the formula in each shared formula part after the sheet is read.

    SHEET

    _readSheet() 

    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"

    Read SHEETLAYOUT record.

    _readSheetLayout() 

    Stores sheet tab color information.

    Read SHEETPR record

    _readSheetPr() 

    Read SHEETPROTECTION record (FEATHEADR)

    _readSheetProtection() 

    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

    _readSheetRangeByRefIndex(int $index) : string | false

    Parameters

    $index

    int

    Exceptions

    \PHPExcel_Reader_Exception

    Returns

    stringfalse

    SST - Shared String Table

    _readSst() 

    This record contains a list of all strings used anywhere in the workbook. Each string occurs only once. The workbook uses indexes into the list to reference the strings.

    -- "OpenOffice.org's Documentation of the Microsoft Excel File Format"

    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

    _readString() : string

    Returns

    stringThe string contents as UTF-8

    Read STYLE record

    _readStyle() 

    Read summary information

    _readSummaryInformation() 

    The TEXT Object record contains the text associated with a cell annotation.

    _readTextObject() 

    Read TOPMARGIN record

    _readTopMargin() 

    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

    _readUnicodeString(string $subData, int $characterCount) : array
    Static

    Parameters

    $subData

    string

    $characterCount

    int

    Returns

    array

    Extracts an Excel Unicode long string (16-bit string length) OpenOffice documentation: 2.5.3 this function is under construction, needs to support rich text, and Asian phonetic settings

    _readUnicodeStringLong(string $subData) : array
    Static

    Parameters

    $subData

    string

    Returns

    array

    Extracts an Excel Unicode short string (8-bit string length) OpenOffice documentation: 2.5.3 function will automatically find out where the Unicode string ends.

    _readUnicodeStringShort(string $subData) : array
    Static

    Parameters

    $subData

    string

    Returns

    array

    Read VCENTER record

    _readVcenter() 

    Read VERTICALPAGEBREAKS record

    _readVerticalPageBreaks() 

    Read WINDOW2 record

    _readWindow2() 

    XF - Extended Format

    _readXf() 

    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"

    _readXfExt() 

    _readXfExt() 

    Convert UTF-16 string in compressed notation to uncompressed form.

    _uncompressByteString(string $string) : string
    Static

    Only used for BIFF8.

    Parameters

    $string

    string

    Returns

    string

    Verify RC4 file password

    _verifyPassword($password, $docid, $salt_data, $hashedsalt_data, $valContext) : bool
    var

    Password to check
    var

    Document id
    var

    Salt data
    var

    Hashed salt data
    var

    &$valContext Set to the MD5 context of the value

    Parameters

    $password

    $docid

    $salt_data

    $hashedsalt_data

    $valContext

    Returns

    boolSuccess

     Properties

     

    $_fileHandle 
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::$$_fileHandle
     

    $_includeCharts : boolean
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::$$_includeCharts
     

    $_loadSheetsOnly : array
    Inherited

    If null, then all worksheets will be loaded.

    inherited_from \PHPExcel_Reader_Abstract::$$_loadSheetsOnly
     

    $_readDataOnly : boolean
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::$$_readDataOnly
     

    $_readFilter : \PHPExcel_Reader_IReadFilter
    Inherited
    inherited_from \PHPExcel_Reader_Abstract::$$_readFilter
     

    $_cellNotes : array
     

    $_codepage : string

    Only important for BIFF5 (Excel 5.0 - Excel 95) For BIFF8 (Excel 97 - Excel 2003) this will always have the value 'UTF-16LE'

     

    $_data : string

    (Includes workbook globals substream as well as sheet substreams)

     

    $_dataSize : int
     

    $_definedname : array
     

    $_documentSummaryInformation : string
     

    $_drawingData : string
     

    $_drawingGroupData : string
     

    $_encryption : int
     

    $_encryptionStartPos : int
     

    $_externalBooks : array
     

    $_externalNames : array
     

    $_formats : array
     

    $_frozen : boolean

    See WINDOW2 record.

     

    $_isFitToPages : boolean

    See SHEETPR record.

     

    $_mapCellStyleXfIndex : array
     

    $_mapCellXfIndex : array
     

    $_md5Ctxt : string
     

    $_objFonts : array
     

    $_objs : array

    One OBJ record contributes with one entry.

     

    $_palette : array
     

    $_phpExcel : \PHPExcel
     

    $_phpSheet : \PHPExcel_Worksheet
     

    $_pos : integer
     

    $_rc4Key : \PHPExcel_Reader_Excel5_RC4
     

    $_rc4Pos : int
     

    $_ref : array

    Only applies to BIFF8.

     

    $_sharedFormulaParts : array

    One FORMULA record contributes with one value if it refers to a shared formula.

     

    $_sharedFormulas : array

    One SHAREDFMLA record contributes with one value.

     

    $_sheets : array
     

    $_sst : array

    Only applies to BIFF8.

     

    $_summaryInformation : string
     

    $_textObjects : array

    One TXO record corresponds with one entry.

     

    $_userDefinedProperties : string
     

    $_version : int
     

    $_xfIndex : int

     Constants

     

    MS_BIFF_CRYPTO_NONE

    MS_BIFF_CRYPTO_NONE 
     

    MS_BIFF_CRYPTO_RC4

    MS_BIFF_CRYPTO_RC4 
     

    MS_BIFF_CRYPTO_XOR

    MS_BIFF_CRYPTO_XOR 
     

    REKEY_BLOCK

    REKEY_BLOCK 
     

    XLS_BIFF7

    XLS_BIFF7 
     

    XLS_BIFF8

    XLS_BIFF8 
     

    XLS_Type_ARRAY

    XLS_Type_ARRAY 
     

    XLS_Type_BLANK

    XLS_Type_BLANK 
     

    XLS_Type_BOF

    XLS_Type_BOF 
     

    XLS_Type_BOOLERR

    XLS_Type_BOOLERR 
     

    XLS_Type_BOTTOMMARGIN

    XLS_Type_BOTTOMMARGIN 
     

    XLS_Type_CODEPAGE

    XLS_Type_CODEPAGE 
     

    XLS_Type_COLINFO

    XLS_Type_COLINFO 
     

    XLS_Type_CONTINUE

    XLS_Type_CONTINUE 
     

    XLS_Type_DATAVALIDATION

    XLS_Type_DATAVALIDATION 
     

    XLS_Type_DATAVALIDATIONS

    XLS_Type_DATAVALIDATIONS 
     

    XLS_Type_DATEMODE

    XLS_Type_DATEMODE 
     

    XLS_Type_DBCELL

    XLS_Type_DBCELL 
     

    XLS_Type_DEFAULTROWHEIGHT

    XLS_Type_DEFAULTROWHEIGHT 
     

    XLS_Type_DEFCOLWIDTH

    XLS_Type_DEFCOLWIDTH 
     

    XLS_Type_DEFINEDNAME

    XLS_Type_DEFINEDNAME 
     

    XLS_Type_DIMENSION

    XLS_Type_DIMENSION 
     

    XLS_Type_EOF

    XLS_Type_EOF 
     

    XLS_Type_EXTERNALBOOK

    XLS_Type_EXTERNALBOOK 
     

    XLS_Type_EXTERNNAME

    XLS_Type_EXTERNNAME 
     

    XLS_Type_EXTERNSHEET

    XLS_Type_EXTERNSHEET 
     

    XLS_Type_EXTSST

    XLS_Type_EXTSST 
     

    XLS_Type_FILEPASS

    XLS_Type_FILEPASS 
     

    XLS_Type_FONT

    XLS_Type_FONT 
     

    XLS_Type_FOOTER

    XLS_Type_FOOTER 
     

    XLS_Type_FORMAT

    XLS_Type_FORMAT 
     

    XLS_Type_FORMULA

    XLS_Type_FORMULA 
     

    XLS_Type_HCENTER

    XLS_Type_HCENTER 
     

    XLS_Type_HEADER

    XLS_Type_HEADER 
     

    XLS_Type_HORIZONTALPAGEBREAKS

    XLS_Type_HORIZONTALPAGEBREAKS 
     

    XLS_Type_HYPERLINK

    XLS_Type_HYPERLINK 
     

    XLS_Type_IMDATA

    XLS_Type_IMDATA 
     

    XLS_Type_INDEX

    XLS_Type_INDEX 
     

    XLS_Type_LABEL

    XLS_Type_LABEL 
     

    XLS_Type_LABELSST

    XLS_Type_LABELSST 
     

    XLS_Type_LEFTMARGIN

    XLS_Type_LEFTMARGIN 
     

    XLS_Type_MERGEDCELLS

    XLS_Type_MERGEDCELLS 
     

    XLS_Type_MSODRAWING

    XLS_Type_MSODRAWING 
     

    XLS_Type_MSODRAWINGGROUP

    XLS_Type_MSODRAWINGGROUP 
     

    XLS_Type_MULBLANK

    XLS_Type_MULBLANK 
     

    XLS_Type_MULRK

    XLS_Type_MULRK 
     

    XLS_Type_NOTE

    XLS_Type_NOTE 
     

    XLS_Type_NUMBER

    XLS_Type_NUMBER 
     

    XLS_Type_OBJ

    XLS_Type_OBJ 
     

    XLS_Type_OBJECTPROTECT

    XLS_Type_OBJECTPROTECT 
     

    XLS_Type_PAGELAYOUTVIEW

    XLS_Type_PAGELAYOUTVIEW 
     

    XLS_Type_PAGESETUP

    XLS_Type_PAGESETUP 
     

    XLS_Type_PALETTE

    XLS_Type_PALETTE 
     

    XLS_Type_PANE

    XLS_Type_PANE 
     

    XLS_Type_PASSWORD

    XLS_Type_PASSWORD 
     

    XLS_Type_PRINTGRIDLINES

    XLS_Type_PRINTGRIDLINES 
     

    XLS_Type_PROTECT

    XLS_Type_PROTECT 
     

    XLS_Type_RANGEPROTECTION

    XLS_Type_RANGEPROTECTION 
     

    XLS_Type_RIGHTMARGIN

    XLS_Type_RIGHTMARGIN 
     

    XLS_Type_RK

    XLS_Type_RK 
     

    XLS_Type_ROW

    XLS_Type_ROW 
     

    XLS_Type_SCENPROTECT

    XLS_Type_SCENPROTECT 
     

    XLS_Type_SCL

    XLS_Type_SCL 
     

    XLS_Type_SELECTION

    XLS_Type_SELECTION 
     

    XLS_Type_SHAREDFMLA

    XLS_Type_SHAREDFMLA 
     

    XLS_Type_SHEET

    XLS_Type_SHEET 
     

    XLS_Type_SHEETLAYOUT

    XLS_Type_SHEETLAYOUT 
     

    XLS_Type_SHEETPR

    XLS_Type_SHEETPR 
     

    XLS_Type_SHEETPROTECTION

    XLS_Type_SHEETPROTECTION 
     

    XLS_Type_SST

    XLS_Type_SST 
     

    XLS_Type_STRING

    XLS_Type_STRING 
     

    XLS_Type_STYLE

    XLS_Type_STYLE 
     

    XLS_Type_TOPMARGIN

    XLS_Type_TOPMARGIN 
     

    XLS_Type_TXO

    XLS_Type_TXO 
     

    XLS_Type_UNKNOWN

    XLS_Type_UNKNOWN 
     

    XLS_Type_VCENTER

    XLS_Type_VCENTER 
     

    XLS_Type_VERTICALPAGEBREAKS

    XLS_Type_VERTICALPAGEBREAKS 
     

    XLS_Type_WINDOW2

    XLS_Type_WINDOW2 
     

    XLS_Type_XF

    XLS_Type_XF 
     

    XLS_Type_XFEXT

    XLS_Type_XFEXT 
     

    XLS_WorkbookGlobals

    XLS_WorkbookGlobals 
     

    XLS_Worksheet

    XLS_Worksheet