PHPExcel_Calculation_LookupRef
| category | PHPExcel |
|---|---|
| package | PHPExcel_Calculation |
| copyright | Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) |
CELL_ADDRESS(\row $row, \column $column, \relativity $relativity, \referenceStyle $referenceStyle, \sheetText $sheetText) : string
Creates a cell address as text, given specified row and column numbers.
Excel Function: =ADDRESS(row, column, [relativity], [referenceStyle], [sheetText])
\rowRow number to use in the cell reference
\columnColumn number to use in the cell reference
\relativityFlag indicating the type of reference to return 1 or omitted Absolute 2 Absolute row; relative column 3 Relative row; absolute column 4 Relative
\referenceStyleA logical value that specifies the A1 or R1C1 reference style. TRUE or omitted CELL_ADDRESS returns an A1-style reference FALSE CELL_ADDRESS returns an R1C1-style reference
\sheetTextOptional Name of worksheet to use
stringCHOOSE() : mixed
Uses lookup_value to return a value from the list of value arguments. Use CHOOSE to select one of up to 254 values based on the lookup_value.
Excel Function: =CHOOSE(index_num, value1, [value2], ...)
mixedThe selected valueCOLUMN(\cellAddress $cellAddress) : integer
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])
\cellAddressA reference to a range of cells for which you want the column numbers
integeror array of integerCOLUMNS(\cellAddress $cellAddress) : integer
Returns the number of columns in an array or reference.
Excel Function: =COLUMNS(cellAddress)
\cellAddressAn array or array formula, or a reference to a range of cells for which you want the number of columns
integerThe number of columns in cellAddressHLOOKUP(\lookup_value $lookup_value, \lookup_array $lookup_array, \index_number $index_number, \not_exact_match $not_exact_match) : mixed
\lookup_valueThe value that you want to match in lookup_array
\lookup_arrayThe range of cells being searched
\index_numberThe row number in table_array from which the matching value must be returned. The first row is 1.
\not_exact_matchDetermines if you are looking for an exact match based on lookup_value.
mixedThe value of the found cellHYPERLINK(string $linkURL, string $displayName, \PHPExcel_Cell $pCell) : mixed
Excel Function: =HYPERLINK(linkURL,displayName)
| access | public |
|---|---|
| category | Logical Functions |
stringValue to check, is also the value returned when no error
stringValue to return when testValue is an error condition
mixedThe value of $displayName (or $linkURL if $displayName was blank)INDEX(\range_array $arrayValues, \row_num $rowNum, \column_num $columnNum) : mixed
Uses an index to choose a value from a reference or array
Excel Function: =INDEX(range_array, row_num, [column_num])
\range_arrayA range of cells or an array constant
\row_numThe row in array from which to return a value. If row_num is omitted, column_num is required.
\column_numThe column in array from which to return a value. If column_num is omitted, row_num is required.
mixedthe value of a specified cell or array of cellsINDIRECT(\cellAddress $cellAddress, \PHPExcel_Cell $pCell) : mixed
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
| todo | Support for the optional a1 parameter introduced in Excel 2010 |
|---|
\cellAddressThe cell address of the current cell (containing this formula)
mixedThe cells referenced by cellAddressLOOKUP(\lookup_value $lookup_value, \lookup_vector $lookup_vector, \result_vector $result_vector) : mixed
\lookup_valueThe value that you want to match in lookup_array
\lookup_vectorThe range of cells being searched
\result_vectorThe column from which the matching value must be returned
mixedThe value of the found cellMATCH(\lookup_value $lookup_value, \lookup_array $lookup_array, \match_type $match_type) : integer
The MATCH function searches for a specified item in a range of cells
Excel Function: =MATCH(lookup_value, lookup_array, [match_type])
\lookup_valueThe value that you want to match in lookup_array
\lookup_arrayThe range of cells being searched
\match_typeThe number -1, 0, or 1. -1 means above, 0 means exact match, 1 means below. If match_type is 1 or -1, the list has to be ordered.
integerThe relative position of the found itemOFFSET(\cellAddress $cellAddress, \rows $rows, \cols $columns, \height $height, \width $width) : string
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])
\cellAddressThe reference from which you want to base the offset. Reference must refer to a cell or range of adjacent cells; otherwise, OFFSET returns the #VALUE! error value.
\rowsThe number of rows, up or down, that you want the upper-left cell to refer to. Using 5 as the rows argument specifies that the upper-left cell in the reference is five rows below reference. Rows can be positive (which means below the starting reference) or negative (which means above the starting reference).
\colsThe number of columns, to the left or right, that you want the upper-left cell of the result to refer to. Using 5 as the cols argument specifies that the upper-left cell in the reference is five columns to the right of reference. Cols can be positive (which means to the right of the starting reference) or negative (which means to the left of the starting reference).
\heightThe height, in number of rows, that you want the returned reference to be. Height must be a positive number.
\widthThe width, in number of columns, that you want the returned reference to be. Width must be a positive number.
stringA reference to a cell or range of cellsROW(\cellAddress $cellAddress) : integer
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])
\cellAddressA reference to a range of cells for which you want the row numbers
integeror array of integerROWS(\cellAddress $cellAddress) : integer
Returns the number of rows in an array or reference.
Excel Function: =ROWS(cellAddress)
\cellAddressAn array or array formula, or a reference to a range of cells for which you want the number of rows
integerThe number of rows in cellAddressTRANSPOSE(array $matrixData) : array
arrayA matrix of values
arrayUnlike the Excel TRANSPOSE function, which will only work on a single row or column, this function will transpose a full matrix.VLOOKUP(\lookup_value $lookup_value, \lookup_array $lookup_array, \index_number $index_number, \not_exact_match $not_exact_match) : mixed
\lookup_valueThe value that you want to match in lookup_array
\lookup_arrayThe range of cells being searched
\index_numberThe column number in table_array from which the matching value must be returned. The first column is 1.
\not_exact_matchDetermines if you are looking for an exact match based on lookup_value.
mixedThe value of the found cell_vlookupSort($a, $b)