REGEX_SHEET_TITLE_UNQUOTED
REGEX_SHEET_TITLE_UNQUOTED = '[^\*\:\/\\\\\?\[\]\+\-\% \\\'\^\&\<\>\=\,\;\#\(\)\"\{\}]+'
PHPExcel_Writer_Excel5_Parser
_convertFunction(string $token, integer $num_args) : string
Convert a function to a ptgFunc or ptgFuncVarV depending on the number of args that it takes.
| string | $token | The name of the function for convertion to ptg value. |
| integer | $num_args | The number of arguments the function receives. |
The packed ptg for the function
_getRefIndex(string $ext_ref) : mixed
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.
| string | $ext_ref | The name of the external reference |
The reference index in packed() format on success
_getSheetIndex(string $sheet_name) : integer
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.
| string | $sheet_name | Sheet name |
The sheet index, -1 if the sheet was not found
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.
| string | $name | The name of the worksheet being added |
| integer | $index | The index of the worksheet being added |
_rangeToPackedRange(string $range) : array
pack() row range into the required 3 or 4 byte format.
Just using maximum col/rows, which is probably not the correct solution
| string | $range | The Excel range to be packed |
Array containing (row1,col1,row2,col2) in packed() format
_cellToRowcol(string $cell) : array
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.
| string | $cell | The Excel cell reference in A1 format. |
_createTree(mixed $value, mixed $left, mixed $right) : array
Creates a tree. In fact an array which may have one or two arrays (sub-trees) as elements.
| mixed | $value | The value of this node. |
| mixed | $left | The left array (sub-tree) or a final node. |
| mixed | $right | The right array (sub-tree) or a final node. |
A tree
toReversePolish(array $tree = array()) : string
Builds a string containing the tree in reverse polish notation (What you would use in a HP calculator stack).
The following tree:
+ / \ 2 3
produces: "23+"
The following tree:
+ / \ 3 * / \ 6 A1
produces: "36A1*+"
In fact all operands, functions, references, etc... are written as ptg's
| array | $tree | The optional tree to convert. |
The tree in reverse polish notation