Docs For Class PHPExcel_ReferenceHelper

static method getInstance [line 57]

static PHPExcel_ReferenceHelper getInstance(
)

Get an instance of this class

Tags:

access:

public

[ Top ]

constructor __construct [line 68]

PHPExcel_ReferenceHelper __construct(
)

Create a new PHPExcel_ReferenceHelper

Tags:

access:

protected

[ Top ]

method insertNewBefore [line 79]

void insertNewBefore(
[int
$pBefore = 'A1'], [int
$pNumCols = 0], [int
$pNumRows = 0], [
$pSheet = null])

Insert a new column, updating all possible related data

Tags:

throws:	Exception
access:	public

Parameters:

int	$pBefore	Insert before this one
int	$pNumCols	Number of columns to insert
int	$pNumRows	Number of rows to insert
PHPExcel_Worksheet	$pSheet

[ Top ]

method updateCellReference [line 501]

string updateCellReference(
[string
$pCellRange = 'A1'], [int
$pBefore = 'A1'], [int
$pNumCols = 0], [int
$pNumRows = 0])

Update cell reference

Tags:

return:	Updated cell range
throws:	Exception
access:	public

Parameters:

string	$pCellRange	Cell range
int	$pBefore	Insert before this one
int	$pNumCols	Number of columns to increment
int	$pNumRows	Number of rows to increment

[ Top ]

method updateFormulaReferences [line 367]

string updateFormulaReferences(
[string
$pFormula = ''], [int
$pBefore = 'A1'], [int
$pNumCols = 0], [int
$pNumRows = 0], [
$sheetName = ''])

Update references within formulas

Tags:

return:	Updated formula
throws:	Exception
access:	public

Parameters:

string	$pFormula	Formula to update
int	$pBefore	Insert before this one
int	$pNumCols	Number of columns to insert
int	$pNumRows	Number of rows to insert
	$sheetName

[ Top ]

method updateNamedFormulas [line 525]

void updateNamedFormulas(
PHPExcel
$pPhpExcel, [string
$oldName = ''], [string
$newName = ''])

Update named formulas (i.e. containing worksheet references / named ranges)

Tags:

access:

public

Parameters:

PHPExcel	$pPhpExcel	Object to update
string	$oldName	Old name (name to replace)
string	$newName	New name

[ Top ]

method __clone [line 629]

void __clone(
)

__clone implementation. Cloning should not be allowed in a Singleton!

Tags:

throws:	Exception
access:	public

[ Top ]

REFHELPER_REGEXP_CELLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}\$?\d+):(\$?[a-z]{1,3}\$?\d+)'

[line 41]

[ Top ]

REFHELPER_REGEXP_CELLREF = '((\w|\'[^!]\')!)?(?<![:a-z\$])(\$?[a-z]{1,3}\$?\d+)(?=[^:!\d\'])'

[line 40]

Regular Expressions

[ Top ]

REFHELPER_REGEXP_COLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'

[line 43]

[ Top ]

REFHELPER_REGEXP_ROWRANGE = '((\w|\'[^!]\')!)?(\$?\d+):(\$?\d+)'

[line 42]

[ Top ]

Class: PHPExcel_ReferenceHelper

Class Overview

Author(s):

Copyright:

Constants

Methods

Class Details

Tags:

Class Methods

static method getInstance [line 57]

Tags:

constructor __construct [line 68]

Tags:

method insertNewBefore [line 79]

Tags:

Parameters:

method updateCellReference [line 501]

Tags:

Parameters:

method updateFormulaReferences [line 367]

Tags:

Parameters:

method updateNamedFormulas [line 525]

Tags:

Parameters:

method __clone [line 629]

Tags:

Class Constants

REFHELPER_REGEXP_CELLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}\$?\d+):(\$?[a-z]{1,3}\$?\d+)'

REFHELPER_REGEXP_CELLREF = '((\w|\'[^!]\')!)?(?<![:a-z\$])(\$?[a-z]{1,3}\$?\d+)(?=[^:!\d\'])'

REFHELPER_REGEXP_COLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'

REFHELPER_REGEXP_ROWRANGE = '((\w|\'[^!]\')!)?(\$?\d+):(\$?\d+)'

Class: PHPExcel_ReferenceHelper

Class Overview

Author(s):

Copyright:

Constants

Methods

Class Details

Tags:

Class Methods

static method getInstance [line 57]

Tags:

constructor __construct [line 68]

Tags:

method insertNewBefore [line 79]

Tags:

Parameters:

method updateCellReference [line 501]

Tags:

Parameters:

method updateFormulaReferences [line 367]

Tags:

Parameters:

method updateNamedFormulas [line 525]

Tags:

Parameters:

method __clone [line 629]

Tags:

Class Constants

REFHELPER_REGEXP_CELLRANGE = '((\w*|\'[^!]*\')!)?(\$?[a-z]{1,3}\$?\d+):(\$?[a-z]{1,3}\$?\d+)'

REFHELPER_REGEXP_CELLREF = '((\w*|\'[^!]*\')!)?(?<![:a-z\$])(\$?[a-z]{1,3}\$?\d+)(?=[^:!\d\'])'

REFHELPER_REGEXP_COLRANGE = '((\w*|\'[^!]*\')!)?(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'

REFHELPER_REGEXP_ROWRANGE = '((\w*|\'[^!]*\')!)?(\$?\d+):(\$?\d+)'

REFHELPER_REGEXP_CELLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}\$?\d+):(\$?[a-z]{1,3}\$?\d+)'

REFHELPER_REGEXP_CELLREF = '((\w|\'[^!]\')!)?(?<![:a-z\$])(\$?[a-z]{1,3}\$?\d+)(?=[^:!\d\'])'

REFHELPER_REGEXP_COLRANGE = '((\w|\'[^!]\')!)?(\$?[a-z]{1,3}):(\$?[a-z]{1,3})'

REFHELPER_REGEXP_ROWRANGE = '((\w|\'[^!]\')!)?(\$?\d+):(\$?\d+)'