PHPExcel_CachedObjectStorage_SQLite

category PHPExcel
package PHPExcel_CachedObjectStorage
copyright Copyright (c) 2006 - 2013 PHPExcel (http://www.codeplex.com/PHPExcel)

 Methods

Initialise this new cell collection

__construct(\PHPExcel_Worksheet $parent) 

Parameters

$parent

\PHPExcel_Worksheet

The worksheet for this cell collection

Destroy this cell collection

__destruct() 

Add or Update a cell in cache identified by coordinate address

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

Parameters

$pCoord

string

Coordinate address of the cell to update

$cell

\PHPExcel_Cell

Cell to update

Exceptions

\PHPExcel_Exception

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

cacheMethodIsAvailable() : boolean
Static

Returns

boolean

Clone the cell collection

copyCellCollection(\PHPExcel_Worksheet $parent) : void

Parameters

$parent

\PHPExcel_Worksheet

The new worksheet

Delete a cell in cache identified by coordinate address

deleteCacheData(string $pCoord) 

Parameters

$pCoord

string

Coordinate address of the cell to delete

Exceptions

\PHPExcel_Exception

Get cell at a specific coordinate

getCacheData(string $pCoord) : \PHPExcel_Cell

Parameters

$pCoord

string

Coordinate of the cell

Exceptions

\PHPExcel_Exception

Returns

\PHPExcel_CellCell that was found, or null if not found

Get a list of all cell addresses currently held in cache

getCellList() : array

Returns

arrayof string

Return the cell address of the currently active cell object

getCurrentAddress() : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getCurrentAddress()

Returns

string

Return the column address of the currently active cell object

getCurrentColumn() : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getCurrentColumn()

Returns

string

Return the row address of the currently active cell object

getCurrentRow() : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getCurrentRow()

Returns

string

Get highest worksheet column

getHighestColumn() : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getHighestColumn()

Returns

stringHighest column name

Get highest worksheet row

getHighestRow() : int
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getHighestRow()

Returns

intHighest row number

Get highest worksheet column and highest row that have cell records

getHighestRowAndColumn() : array
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getHighestRowAndColumn()

Returns

arrayHighest column name and highest row number

Return the parent worksheet for this cell collection

getParent() : \PHPExcel_Worksheet
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getParent()

Returns

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

getSortedCellList() : void
Inherited
inherited_from \PHPExcel_CachedObjectStorage_ICache::getSortedCellList()

Is a value set for an indexed cell?

isDataSet(string $pCoord) : boolean

Parameters

$pCoord

string

Coordinate address of the cell to check

Returns

boolean

Move a cell object from one address to another

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

Parameters

$fromAddress

string

Current address of the cell to move

$toAddress

string

Destination address of the cell to move

Returns

boolean

Clear the cell collection and disconnect from our parent

unsetWorksheetCells() : void

Add or Update a cell in cache

updateCacheData(\PHPExcel_Cell $cell) : void
Inherited
inherited_from \PHPExcel_CachedObjectStorage_ICache::updateCacheData()

Parameters

$cell

\PHPExcel_Cell

Cell to update

Exceptions

\PHPExcel_Exception

Generate a unique ID for cache referencing

_getUniqueID() : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::_getUniqueID()

Returns

stringUnique Reference

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

_storeData() : void

Exceptions

\PHPExcel_Exception

 Properties

 

$_cellCache : array
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::$$_cellCache
 

$_currentCellIsDirty : boolean
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::$$_currentCellIsDirty
 

$_currentObject : \PHPExcel_Cell
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::$$_currentObject
 

$_currentObjectID : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::$$_currentObjectID
 

$_parent : \PHPExcel_Worksheet
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::$$_parent
 

$_DBHandle : resource
 

$_TableName : string