Gitee
\
OSS
Core
Http
Model
Result
Qcloud_cos
qcloudcos
Qiniu
Http
Processing
Storage
Testify
We7
Table
Account
Article
Core
Mc
Modules
Phoneapp
Qrcode
Rule
Site
Stat
Store
System
Uni
Userapi
Users
Wechat
Wxapp

\PHPExcel_CachedObjectStorage_SQLite3

PHPExcel_CachedObjectStorage_SQLite3

Summary

Methods
Properties
Constants
__construct()
getParent()
isDataSet()
moveCell()
updateCacheData()
deleteCacheData()
getCellList()
getSortedCellList()
getHighestRowAndColumn()
getCurrentAddress()
getCurrentColumn()
getCurrentRow()
getHighestColumn()
getHighestRow()
copyCellCollection()
cacheMethodIsAvailable()
addCacheData()
getCacheData()
unsetWorksheetCells()
__destruct()
No public properties found
No constants found
_getUniqueID()
_storeData()
$_parent
$_currentObject
$_currentObjectID
$_currentCellIsDirty
$_cellCache
N/A
No private methods found
$_TableName
$_DBHandle
$_selectQuery
$_insertQuery
$_updateQuery
$_deleteQuery
N/A

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

$_TableName

$_TableName : string

Database table name

Type

string

$_DBHandle

$_DBHandle : resource

Database handle

Type

resource

$_selectQuery

$_selectQuery : \SQLite3Stmt

Prepared statement for a SQLite3 select query

Type

\SQLite3Stmt

$_insertQuery

$_insertQuery : \SQLite3Stmt

Prepared statement for a SQLite3 insert query

Type

\SQLite3Stmt

$_updateQuery

$_updateQuery : \SQLite3Stmt

Prepared statement for a SQLite3 update query

Type

\SQLite3Stmt

$_deleteQuery

$_deleteQuery : \SQLite3Stmt

Prepared statement for a SQLite3 delete query

Type

\SQLite3Stmt

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

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

__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