PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc Class Reference

Static Public Member Functions
static	chooseCols (mixed $input, mixed ... $args)
	CHOOSECOLS.
static	chooseRows (mixed $input, mixed ... $args)
	CHOOSEROWS.
static	drop (mixed $input, mixed $rows=null, mixed $columns=null)
	DROP.
static	expand (mixed $input, mixed $rows, mixed $columns=null, mixed $pad='#N/A')
	EXPAND.
static	take (mixed $input, mixed $rows, mixed $columns=null)
	TAKE.
static	transpose (array $array)

Member Function Documentation

chooseCols()

static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc::chooseCols ( mixed $input, mixed ... $args )

static

CHOOSECOLS.

Parameters

mixed

$input

expecting two-dimensional array

Return values

mixed[]|string

chooseRows()

static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc::chooseRows ( mixed $input, mixed ... $args )

static

CHOOSEROWS.

Parameters

mixed

$input

expecting two-dimensional array

Return values

mixed[]|string

drop()

static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc::drop ( mixed $input, mixed $rows = null, mixed $columns = null )

static

DROP.

Parameters

mixed

$input

expect two-dimensional array

Return values

mixed[]|string

expand()

static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc::expand ( mixed $input, mixed $rows, mixed $columns = null, mixed $pad = '#N/A' )

static

EXPAND.

Parameters

mixed

$input

expecting two-dimensional array

Return values

mixed[]|string

take()

static PhpOffice\PhpSpreadsheet\Calculation\LookupRef\ChooseRowsEtc::take ( mixed $input, mixed $rows, mixed $columns = null )

static

TAKE.

Parameters

mixed

$input

expecting two-dimensional array

Return values

mixed[]|string

---

The documentation for this class was generated from the following file:

• lib/phpspreadsheet/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ChooseRowsEtc.php