PHPExcel_Calculation_LookupRef
CELL_ADDRESS(mixed $row, mixed $column, mixed $relativity = 1, mixed $referenceStyle = True, mixed $sheetText = '') : string
CELL_ADDRESS
Creates a cell address as text, given specified row and column numbers.
Excel Function: =ADDRESS(row, column, [relativity], [referenceStyle], [sheetText])
| mixed | $row | |
| mixed | $column | |
| mixed | $relativity | |
| mixed | $referenceStyle | |
| mixed | $sheetText |
COLUMN(mixed $cellAddress = Null) : int
COLUMN
Returns the column number of the given cell reference If the cell reference is a range of cells, COLUMN returns the column numbers of each column in the reference as a horizontal array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the COLUMN function appears; otherwise this function returns 0.
Excel Function: =COLUMN([cellAddress])
| mixed | $cellAddress |
or array of integer
ROW(mixed $cellAddress = Null) : int
ROW
Returns the row number of the given cell reference If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference as a vertical array. If cell reference is omitted, and the function is being called through the calculation engine, then it is assumed to be the reference of the cell in which the ROW function appears; otherwise this function returns 0.
Excel Function: =ROW([cellAddress])
| mixed | $cellAddress |
or array of integer
HYPERLINK(string $linkURL = '', string $displayName = null, \PHPExcel_Cell $pCell = null) : mixed
HYPERLINK
Excel Function: =HYPERLINK(linkURL,displayName)
| string | $linkURL | Value to check, is also the value returned when no error |
| string | $displayName | Value to return when testValue is an error condition |
| \PHPExcel_Cell | $pCell | The cell to set the hyperlink in |
The value of $displayName (or $linkURL if $displayName was blank)
INDIRECT(\cellAddress $cellAddress = NULL, \PHPExcel_Cell $pCell = NULL) : mixed
INDIRECT
Returns the reference specified by a text string. References are immediately evaluated to display their contents.
Excel Function: =INDIRECT(cellAddress)
NOTE - INDIRECT() does not yet support the optional a1 parameter introduced in Excel 2010
| \cellAddress | $cellAddress | The cell address of the current cell (containing this formula) |
| \PHPExcel_Cell | $pCell | The current cell (containing this formula) |
The cells referenced by cellAddress
OFFSET(mixed $cellAddress = Null, mixed $rows, mixed $columns, mixed $height = null, mixed $width = null) : string
OFFSET
Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.
Excel Function: =OFFSET(cellAddress, rows, cols, [height], [width])
| mixed | $cellAddress | |
| mixed | $rows | |
| mixed | $columns | |
| mixed | $height | |
| mixed | $width |
A reference to a cell or range of cells
MATCH(mixed $lookup_value, mixed $lookup_array, mixed $match_type = 1) : int
MATCH
The MATCH function searches for a specified item in a range of cells
Excel Function: =MATCH(lookup_value, lookup_array, [match_type])
| mixed | $lookup_value | |
| mixed | $lookup_array | |
| mixed | $match_type |
The relative position of the found item
INDEX(mixed $arrayValues, mixed $rowNum, mixed $columnNum) : mixed
INDEX
Uses an index to choose a value from a reference or array
Excel Function: =INDEX(range_array, row_num, [column_num])
| mixed | $arrayValues | |
| mixed | $rowNum | |
| mixed | $columnNum |
the value of a specified cell or array of cells
VLOOKUP(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true) : mixed
VLOOKUP The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.
| mixed | $lookup_value | |
| mixed | $lookup_array | |
| mixed | $index_number | |
| mixed | $not_exact_match |
The value of the found cell
HLOOKUP(mixed $lookup_value, mixed $lookup_array, mixed $index_number, mixed $not_exact_match = true) : mixed
HLOOKUP The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.
| mixed | $lookup_value | |
| mixed | $lookup_array | |
| mixed | $index_number | |
| mixed | $not_exact_match |
The value of the found cell
LOOKUP(mixed $lookup_value, mixed $lookup_vector, mixed $result_vector = null) : mixed
LOOKUP The LOOKUP function searches for value either from a one-row or one-column range or from an array.
| mixed | $lookup_value | |
| mixed | $lookup_vector | |
| mixed | $result_vector |
The value of the found cell