|
| static | index (mixed $matrix, mixed $rowNum=0, mixed $columnNum=null) |
| | INDEX.
|
| |
|
static | isColumnVector (array $values) |
| |
|
static | isRowVector (array $values) |
| | Helper function; NOT an implementation of any Excel Function.
|
| |
| static | transpose ($matrixData) |
| | TRANSPOSE.
|
| |
◆ index()
| static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\Matrix::index |
( |
mixed | $matrix, |
|
|
mixed | $rowNum = 0, |
|
|
mixed | $columnNum = null ) |
|
static |
INDEX.
Uses an index to choose a value from a reference or array
Excel Function: =INDEX(range_array, row_num, [column_num], [area_num])
- Parameters
-
| mixed | $matrix | A range of cells or an array constant |
| mixed | $rowNum | The row in the array or range from which to return a value. If row_num is omitted, column_num is required. Or can be an array of values |
| mixed | $columnNum | The column in the array or range from which to return a value. If column_num is omitted, row_num is required. Or can be an array of values |
TODO Provide support for area_num, currently not supported
- Return values
-
| mixed | the value of a specified cell or array of cells If an array of values is passed as the $rowNum and/or $columnNum arguments, then the returned result will also be an array with the same dimensions |
◆ transpose()
| static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\Matrix::transpose |
( |
| $matrixData | ) |
|
|
static |
TRANSPOSE.
- Parameters
-
| array | mixed | $matrixData | A matrix of values |
The documentation for this class was generated from the following file:
- lib/phpspreadsheet/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/Matrix.php
1.13.2