PHPExcel classes
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 - 2013 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

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"

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

 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
 

$_externalBooks : array
 

$_externalNames : array
 

$_formats : array
 

$_frozen : boolean

See WINDOW2 record.

 

$_isFitToPages : boolean

See SHEETPR record.

 

$_mapCellStyleXfIndex : array
 

$_mapCellXfIndex : array
 

$_objFonts : array
 

$_objs : array

One OBJ record contributes with one entry.

 

$_palette : array
 

$_phpExcel : \PHPExcel
 

$_phpSheet : \PHPExcel_Worksheet
 

$_pos : integer
 

$_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

 

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