Properties

$_currentObject

$_currentObject : \PHPExcel_Cell

The currently active Cell

Type

\PHPExcel_Cell

$_currentObjectID

$_currentObjectID : string

Coordinate address of the currently active Cell

Type

string

$_currentCellIsDirty

$_currentCellIsDirty : boolean

Flag indicating whether the currently active Cell requires saving

Type

boolean

$_cellCache

$_cellCache : array

An array of cells or cell pointers for the worksheet cells held in this cache, and indexed by their coordinate address within the worksheet

Type

array — of mixed

Methods

__construct()

__construct(\PHPExcel_Worksheet  $parent) 

Initialise this new cell collection

Parameters

\PHPExcel_Worksheet $parent

The worksheet for this cell collection

getParent()

getParent() : \PHPExcel_Worksheet

Return the parent worksheet for this cell collection

Returns

\PHPExcel_Worksheet

isDataSet()

isDataSet(string  $pCoord) : boolean

Is a value set in the current PHPExcel_CachedObjectStorage_ICache for an indexed cell?

Parameters

string $pCoord

Coordinate address of the cell to check

Returns

boolean

moveCell()

moveCell(string  $fromAddress, string  $toAddress) : boolean

Move a cell object from one address to another

Parameters

string $fromAddress

Current address of the cell to move

string $toAddress

Destination address of the cell to move

Returns

boolean

updateCacheData()

updateCacheData(\PHPExcel_Cell  $cell) : void

Add or Update a cell in cache

Parameters

\PHPExcel_Cell $cell

Cell to update

Throws

\PHPExcel_Exception

deleteCacheData()

deleteCacheData(string  $pCoord) 

Delete a cell in cache identified by coordinate address

Parameters

string $pCoord

Coordinate address of the cell to delete

Throws

\PHPExcel_Exception

getCellList()

getCellList() : array

Get a list of all cell addresses currently held in cache

Returns

array —

of string

getSortedCellList()

getSortedCellList() : void

Sort the list of all cell addresses currently held in cache by row and column

getHighestRowAndColumn()

getHighestRowAndColumn() : array

Get highest worksheet column and highest row that have cell records

Returns

array —

Highest column name and highest row number

getCurrentAddress()

getCurrentAddress() : string

Return the cell address of the currently active cell object

Returns

string

getCurrentColumn()

getCurrentColumn() : string

Return the column address of the currently active cell object

Returns

string

getCurrentRow()

getCurrentRow() : string

Return the row address of the currently active cell object

Returns

string

getHighestColumn()

getHighestColumn() : string

Get highest worksheet column

Returns

string —

Highest column name

getHighestRow()

getHighestRow() : integer

Get highest worksheet row

Returns

integer —

Highest row number

copyCellCollection()

copyCellCollection(\PHPExcel_Worksheet  $parent) : void

Clone the cell collection

Parameters

\PHPExcel_Worksheet $parent

The new worksheet

cacheMethodIsAvailable()

cacheMethodIsAvailable() : boolean

Identify whether the caching method is currently available Some methods are dependent on the availability of certain extensions being enabled in the PHP build

Returns

boolean

_getUniqueID()

_getUniqueID() : string

Generate a unique ID for cache referencing

Returns

string —

Unique Reference