Class PHPExcel_Writer_Excel5_Parser
PHPExcel_Writer_Excel5_Parser
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Writer/Excel5/Parser.php
public
|
|
public
|
|
public
mixed
|
|
public
|
|
public
mixed
|
|
public
string
|
#
_convertFunction( string $token, integer $num_args )
Convert a function to a ptgFunc or ptgFuncVarV depending on the number of args that it takes. |
public
|
#
_convertRange2d( string $range, integer $class = 0 )
Convert an Excel range such as A1:D4 to a ptgRefV. |
public
mixed
|
#
_convertRange3d( string $token )
Convert an Excel 3d range such as "Sheet1!A1:D4" or "Sheet1:Sheet2!A1:D4" to a ptgArea3d. |
public
string
|
#
_convertRef2d( string $cell )
Convert an Excel reference such as A1, $B2, C$3 or $D$4 to a ptgRefV. |
public
mixed
|
#
_convertRef3d( string $cell )
Convert an Excel 3d reference such as "Sheet1!A1" or "Sheet1:Sheet2!A1" to a ptgRef3d. |
public
string
|
|
public
string
|
#
_packExtRef( string $ext_ref )
Convert the sheet name part of an external reference, for example "Sheet1" or "Sheet1:Sheet2", to a packed structure. |
public
mixed
|
#
_getRefIndex( string $ext_ref )
Look up the REF index that corresponds to an external sheet name (or range). If it doesn't exist yet add it to the workbook's references array. It assumes all sheet names given must exist. |
public
integer
|
#
_getSheetIndex( string $sheet_name )
Look up the index that corresponds to an external sheet name. The hash of sheet names is updated by the addworksheet() method of the PHPExcel_Writer_Excel5_Workbook class. |
public
|
#
setExtSheet( string $name, integer $index )
This method is used to update the array of sheet names. It is called by the addWorksheet() method of the PHPExcel_Writer_Excel5_Workbook class. |
public
array
|
|
public
array
|
#
_rangeToPackedRange( string $range )
pack() row range into the required 3 or 4 byte format. Just using maximum col/rows, which is probably not the correct solution |
public
array
|
#
_cellToRowcol( string $cell )
Convert an Excel cell reference such as A1 or $B2 or C$3 or $D$4 to a zero indexed row and column number. Also returns two (0,1) values to indicate whether the row or column are relative references. |
public
|
|
public
mixed
|
|
public
mixed
|
|
public
mixed
|
#
_condition( )
It parses a condition. It assumes the following rule: Cond -> Expr [(">" | "<") Expr] |
public
mixed
|
#
_expression( )
It parses a expression. It assumes the following rule: Expr -> Term [("+" | "-") Term] -> "string" -> "-" Term : Negative value -> "+" Term : Positive value -> Error code |
public
array
|
#
_parenthesizedExpression( )
This function just introduces a ptgParen element in the tree, so that Excel doesn't get confused when working with a parenthesized formula afterwards. |
public
mixed
|
|
public
mixed
|
|
public
mixed
|
|
public
array
|
#
_createTree( mixed $value, mixed $left, mixed $right )
Creates a tree. In fact an array which may have one or two arrays (sub-trees) as elements. |
public
string
|
#
toReversePolish( array $tree = array() )
Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack). The following tree: |
string |
REGEX_SHEET_TITLE_UNQUOTED
|
#
'[^\*\:\/\\\\\?\[\]\+\-\% \\\'\^\&\<\>\=\,\;\#\(\)\"\{\}]+'
|
string |
REGEX_SHEET_TITLE_QUOTED
|
#
'(([^\*\:\/\\\\\?\[\]\\\'])+|(\\\'\\\')+)+'
|
public
integer
|
$_current_char
The index of the character we are currently looking at |
|
public
string
|
$_current_token
The token we are working on. |
|
public
string
|
$_formula
The formula to parse |
|
public
string
|
$_lookahead
The character ahead of the current char |
|
public
string
|
$_parse_tree
The parse tree to be generated |
|
public
array
|
$_ext_sheets
Array of external sheets |
|
public
array
|
$_references
Array of sheet references in the form of REF structures |