PHPExcel classes
Back to top  

PHPExcel_CachedObjectStorage_SQLite3

category PHPExcel
package PHPExcel_CachedObjectStorage
copyright Copyright (c) 2006 - 2014 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 $row) : string
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getHighestColumn()

Parameters

$row

string

Return the highest column for the specified row, or the highest column of any row if no row number is passed

Returns

stringHighest column name

Get highest worksheet row

getHighestRow(string $column) : int
Inherited
inherited_from \PHPExcel_CachedObjectStorage_CacheBase::getHighestRow()

Parameters

$column

string

Return the highest row for the specified column, or the highest row of any column if no column letter is passed

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

\PHPExcel_Worksheet

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
 

$_deleteQuery : \SQLite3Stmt
 

$_insertQuery : \SQLite3Stmt
 

$_selectQuery : \SQLite3Stmt
 

$_updateQuery : \SQLite3Stmt