REGEX_SHEET_TITLE_UNQUOTED
REGEX_SHEET_TITLE_UNQUOTED = '[^\*\:\/\\\\\?\[\]\+\-\% \\\'\^\&\<\>\=\,\;\#\(\)\"\{\}]+'
PHPExcel_Writer_Excel5_Parser
Copyright (c) 2006 - 2015 PHPExcel
This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
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 |
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
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
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