public static
string

#
CELL_ADDRESS( row $row, column $column, relativity $relativity = 1, referenceStyle $referenceStyle = True, sheetText $sheetText = '' )
CELL_ADDRESS
Creates a cell address as text, given specified row and column numbers.
Parameters
 $row
 number to use in the cell reference
 $column
 number to use in the cell reference
 $relativity
 indicating the type of reference to return 1 or omitted Absolute 2 Absolute row;
relative column 3 Relative row; absolute column 4 Relative
 $referenceStyle
 logical value that specifies the A1 or R1C1 reference style. TRUE or omitted
CELL_ADDRESS returns an A1style reference FALSE CELL_ADDRESS returns an
R1C1style reference
 $sheetText
 Name of worksheet to use
Returns
string string

public static
integer

#
COLUMN( cellAddress $cellAddress = Null )
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.
Parameters
 $cellAddress
 reference to a range of cells for which you want the column numbers
Returns
integer or array of integer

public static
integer

#
COLUMNS( cellAddress $cellAddress = Null )
COLUMNS
Returns the number of columns in an array or reference.
Parameters
 $cellAddress
 array or array formula, or a reference to a range of cells for which you want
the number of columns
Returns
integer integer

public static
integer

#
ROW( cellAddress $cellAddress = Null )
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.
Parameters
 $cellAddress
 reference to a range of cells for which you want the row numbers
Returns
integer or array of integer

public static
integer

#
ROWS( cellAddress $cellAddress = Null )
ROWS
Returns the number of rows in an array or reference.
Parameters
 $cellAddress
 array or array formula, or a reference to a range of cells for which you want
the number of rows
Returns
integer integer

public static
mixed

#
HYPERLINK( string $linkURL = '', string $displayName = null, PHPExcel_Cell $pCell = null )
HYPERLINK
Excel Function: =HYPERLINK(linkURL,displayName)
Parameters
 $linkURL
 Value to check, is also the value returned when no error
 $displayName
 Value to return when testValue is an error condition
 $pCell
Returns
mixed The value of errorpart or testValue determined by error condition
Category
Logical Functions

public static
integer

#
INDIRECT( cellAddress $cellAddress = Null, PHPExcel_Cell $pCell = null )
INDIRECT
Returns the number of rows in an array or reference.
Parameters
 $cellAddress
 array or array formula, or a reference to a range of cells for which you want
the number of rows
 $pCell
Returns
integer integer

public static
string

#
OFFSET( cellAddress $cellAddress = Null, rows $rows = 0, cols $columns = 0, height $height = null, width $width = null )
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.
Parameters
 $cellAddress
 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.
 $rows
 number of rows, up or down, that you want the upperleft cell to refer to. Using
5 as the rows argument specifies that the upperleft 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).
 $columns
 number of columns, to the left or right, that you want the upperleft cell of
the result to refer to. Using 5 as the cols argument specifies that the
upperleft 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).
 $height
 height, in number of rows, that you want the returned reference to be. Height
must be a positive number.
 $width
 width, in number of columns, that you want the returned reference to be. Width
must be a positive number.
Returns
string A reference to a cell or range of cells

public static


public static
integer

#
MATCH( lookup_value $lookup_value, lookup_array $lookup_array, match_type $match_type = 1 )
MATCH
The MATCH function searches for a specified item in a range of cells
Parameters
 $lookup_value
 value that you want to match in lookup_array
 $lookup_array
 range of cells being searched
 $match_type
 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.
Returns
integer The relative position of the found item

public static

#
INDEX( range_array $arrayValues, row_num $rowNum = 0, column_num $columnNum = 0 )
INDEX
Uses an index to choose a value from a reference or array implemented: Return
the value of a specified cell or array of cells Array form not implemented:
Return a reference to specified cells Reference form
Parameters
 $arrayValues
 range of cells or an array constant
 $rowNum
 the row in array from which to return a value. If row_num is omitted, column_num
is required.
 $columnNum
 the column in array from which to return a value. If column_num is omitted,
row_num is required.

public static
array

#
TRANSPOSE( array $matrixData )
TRANSPOSE
Parameters
 $matrixData
 A matrix of values
Returns
array Unlike the Excel TRANSPOSE function, which will only work on a single row or
column, this function will transpose a full matrix.

public static
mixed

#
VLOOKUP( lookup_value $lookup_value, lookup_array $lookup_array, index_number $index_number, not_exact_match $not_exact_match = true )
VLOOKUP The VLOOKUP function searches for value in the leftmost column of
lookup_array and returns the value in the same row based on the
index_number.
VLOOKUP The VLOOKUP function searches for value in the leftmost column of
lookup_array and returns the value in the same row based on the
index_number.
Parameters
 $lookup_value
 value that you want to match in lookup_array
 $lookup_array
 range of cells being searched
 $index_number
 column number in table_array from which the matching value must be returned. The
first column is 1.
 $not_exact_match
 if you are looking for an exact match based on lookup_value.
Returns
mixed The value of the found cell

public static
mixed

#
LOOKUP( lookup_value $lookup_value, lookup_vector $lookup_vector, result_vector $result_vector = null )
LOOKUP The LOOKUP function searches for value either from a onerow or
onecolumn range or from an array.
LOOKUP The LOOKUP function searches for value either from a onerow or
onecolumn range or from an array.
Parameters
 $lookup_value
 value that you want to match in lookup_array
 $lookup_vector
 range of cells being searched
 $result_vector
 column from which the matching value must be returned
Returns
mixed The value of the found cell
