Docs For Class PHPExcel_ReferenceHelper

static method getInstance [line 50]

static PHPExcel_ReferenceHelper getInstance(
)

Get an instance of this class

Tags:

access:

public

[ Top ]

constructor __construct [line 61]

PHPExcel_ReferenceHelper __construct(
)

Create a new PHPExcel_ReferenceHelper

Tags:

access:

protected

[ Top ]

method insertNewBefore [line 72]

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

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

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

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

[ Top ]

method updateNamedFormulas [line 422]

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

void __clone(
)

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

Tags:

throws:	Exception
access:	public

[ Top ]

Class: PHPExcel_ReferenceHelper

Class Overview

Author(s):

Copyright:

Methods

Class Details

Tags:

Class Methods

static method getInstance [line 50]

Tags:

constructor __construct [line 61]

Tags:

method insertNewBefore [line 72]

Tags:

Parameters:

method updateCellReference [line 398]

Tags:

Parameters:

method updateFormulaReferences [line 343]

Tags:

Parameters:

method updateNamedFormulas [line 422]

Tags:

Parameters:

method __clone [line 528]

Tags: