DEFAULT_RANGE
DEFAULT_RANGE = 'A1:A1'
Default range variable constant
@var string
PHPExcel_Cell
$_valueBinder : \PHPExcel_Cell_IValueBinder
Value binder to use
$_calculatedValue : mixed
Calculated value of the cell (used for caching) This returns the value last calculated by MS Excel or whichever spreadsheet program was used to create the original spreadsheet file.
Note that this value is not guaranteed to reflect the actual calculated value because it is possible that auto-calculation was disabled in the original spreadsheet, and underlying data values used by the formula have changed since it was last calculated.
$_parent : \PHPExcel_CachedObjectStorage_CacheBase
Parent worksheet
attach(\PHPExcel_CachedObjectStorage_CacheBase $parent)
| \PHPExcel_CachedObjectStorage_CacheBase | $parent |
__construct(mixed $pValue = NULL, string $pDataType = NULL, \PHPExcel_Worksheet $pSheet = NULL)
Create a new Cell
| mixed | $pValue | |
| string | $pDataType | |
| \PHPExcel_Worksheet | $pSheet |
setValue(mixed $pValue = NULL) : \PHPExcel_Cell
Set cell value
Sets the value for a cell, automatically determining the datatype using the value binder
| mixed | $pValue | Value |
setValueExplicit(mixed $pValue = NULL, string $pDataType = \PHPExcel_Cell_DataType::TYPE_STRING) : \PHPExcel_Cell
Set the value for a cell, with the explicit data type passed to the method (bypassing any use of the value binder)
| mixed | $pValue | Value |
| string | $pDataType | Explicit data type |
setCalculatedValue(mixed $pValue = NULL) : \PHPExcel_Cell
Set old calculated value (cached)
| mixed | $pValue | Value |
getOldCalculatedValue() : mixed
Get old calculated value (cached) This returns the value last calculated by MS Excel or whichever spreadsheet program was used to create the original spreadsheet file.
Note that this value is not guaranteed to refelect the actual calculated value because it is possible that auto-calculation was disabled in the original spreadsheet, and underlying data values used by the formula have changed since it was last calculated.
setDataType(string $pDataType = \PHPExcel_Cell_DataType::TYPE_STRING) : \PHPExcel_Cell
Set cell data type
| string | $pDataType |
getDataValidation() : \PHPExcel_Cell_DataValidation
Get Data validation rules
setDataValidation(\PHPExcel_Cell_DataValidation $pDataValidation = NULL) : \PHPExcel_Cell
Set Data validation rules
| \PHPExcel_Cell_DataValidation | $pDataValidation |
getHyperlink() : \PHPExcel_Cell_Hyperlink
Get Hyperlink
setHyperlink(\PHPExcel_Cell_Hyperlink $pHyperlink = NULL) : \PHPExcel_Cell
Set Hyperlink
| \PHPExcel_Cell_Hyperlink | $pHyperlink |
getParent() : \PHPExcel_Worksheet
Get parent worksheet
getWorksheet() : \PHPExcel_Worksheet
Get parent worksheet
getStyle() : \PHPExcel_Style
Get cell style
rebindParent(\PHPExcel_Worksheet $parent) : \PHPExcel_Cell
Re-bind parent
| \PHPExcel_Worksheet | $parent |
absoluteReference(string $pCoordinateString = 'A1') : string
Make string row, column or cell coordinate absolute
| string | $pCoordinateString | e.g. 'A' or '1' or 'A1' Note that this value can be a row or column reference as well as a cell reference |
Absolute coordinate e.g. '$A' or '$1' or '$A$1'
splitRange(string $pRange = 'A1:A1') : array
Split range into coordinate strings
| string | $pRange | e.g. 'B4:D9' or 'B4:D9,H2:O11' or 'B4' |
Array containg one or more arrays containing one or two coordinate strings e.g. array('B4','D9') or array(array('B4','D9'),array('H2','O11')) or array('B4')
compareCells(\PHPExcel_Cell $a, \PHPExcel_Cell $b) : integer
Compare 2 cells
| \PHPExcel_Cell | $a | Cell a |
| \PHPExcel_Cell | $b | Cell b |
Result of comparison (always -1 or 1, never zero!)
getValueBinder() : \PHPExcel_Cell_IValueBinder
Get value binder to use
setValueBinder(\PHPExcel_Cell_IValueBinder $binder = NULL)
Set value binder to use
| \PHPExcel_Cell_IValueBinder | $binder |
setXfIndex(integer $pValue) : \PHPExcel_Cell
Set index to cellXf
| integer | $pValue |