Todo List
PHPExcel_Cell
[line 59]
Column of the cell
[line 80]
Type of the cell data
[line 87]
Data validation
[line 94]
Hyperlink
[line 101]
Parent worksheet
[line 66]
Row of the cell
[line 73]
Value of the cell
static string absoluteCoordinate( [string $pCoordinateString = 'A1'])
Make string coordinate absolute
static int columnIndexFromString( [string $pString = 'A'])
Column index from string
static int compareCells( PHPExcel_Cell $a, PHPExcel_Cell $b)
Compare 2 cells
static array coordinateFromString( [string $pCoordinateString = 'A1'])
Coordinate from string
static array extractAllCellReferencesInRange( [string $pRange = 'A1'])
Extract all cell references in range
static array rangeDimension( [string $pRange = 'A1:A1'])
Calculate range dimension
static array splitRange( [string $pRange = 'A1:A1'])
Split range into coordinate strings
static string stringFromColumnIndex( [int $pColumnIndex = 0])
String from columnindex
PHPExcel_Cell __construct( [string $pColumn = 'A'], [int $pRow = 1], [mixed $pValue = null], [string $pDataType = null], [ $pSheet = null])
Create a new Cell
mixed getCalculatedValue( )
Get caluclated cell value
string getColumn( )
Get cell coordinate column
string getCoordinate( )
Get cell coordinate
string getDataType( )
Get cell data type
PHPExcel_Cell_DataValidation getDataValidation( )
Get Data validation
PHPExcel_Cell_Hyperlink getHyperlink( )
Get Hyperlink
PHPExcel_Worksheet getParent( )
Get parent
int getRow( )
Get cell coordinate row
mixed getValue( )
Get cell value
boolean hasDataValidation( )
Has Data validation?
boolean hasHyperlink( )
Has Hyperlink
boolean isInRange( [string $pRange = 'A1:A1'])
Is cell in a specific range?
void rebindParent( $parent)
Re-bind parent
void setDataType( [string $pDataType = PHPExcel_Cell_DataType::TYPE_STRING])
Set cell data type
void setDataValidation( [PHPExcel_Cell_DataValidation $pDataValidation = null])
Set Data validation
void setHyperlink( [PHPExcel_Cell_Hyperlink $pHyperlink = null])
Set Hyperlink
void setValue( [mixed $pValue = null], [bool $pUpdateDataType = true])
Set cell value This clears the cell formula.
void setValueExplicit( [mixed $pValue = null], [string $pDataType = PHPExcel_Cell_DataType::TYPE_STRING])
Set cell value (with explicit data type given)
void __clone( )
Implement PHP __clone to create a deep clone, not just a shallow copy.