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

$_cachePrefix

$_cachePrefix : string

Prefix used to uniquely identify cache data for this worksheet

Type

string

$_cacheTime

$_cacheTime : integer

Cache timeout

Type

integer

$_memcache

$_memcache : resource

Memcache interface

Type

resource

Methods

__construct()

__construct(\PHPExcel_Worksheet  $parent,   $arguments) 

Initialise this new cell collection

Parameters

\PHPExcel_Worksheet $parent

The worksheet for this cell collection

$arguments

getParent()

getParent() : \PHPExcel_Worksheet

Return the parent worksheet for this cell collection

Returns

\PHPExcel_Worksheet

isDataSet()

isDataSet(string  $pCoord) : void

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

Parameters

string $pCoord

Coordinate address of the cell to check

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

addCacheData()

addCacheData(string  $pCoord, \PHPExcel_Cell  $cell) : void

Add or Update a cell in cache identified by coordinate address

Parameters

string $pCoord

Coordinate address of the cell to update

\PHPExcel_Cell $cell

Cell to update

Throws

\PHPExcel_Exception

getCacheData()

getCacheData(string  $pCoord) : \PHPExcel_Cell

Get cell at a specific coordinate

Parameters

string $pCoord

Coordinate of the cell

Throws

\PHPExcel_Exception

Returns

\PHPExcel_Cell

Cell that was found, or null if not found

unsetWorksheetCells()

unsetWorksheetCells() : void

Clear the cell collection and disconnect from our parent

failureCallback()

failureCallback(string  $host, integer  $port) 

Memcache error handler

Parameters

string $host

Memcache server

integer $port

Memcache port

Throws

\PHPExcel_Exception

__destruct()

__destruct() 

Destroy this cell collection

_getUniqueID()

_getUniqueID() : string

Generate a unique ID for cache referencing

Returns

string —

Unique Reference

_storeData()

_storeData() : void

Store cell data in cache for the current cell object if it's "dirty", and the 'nullify' the current cell object

Throws

\PHPExcel_Exception