Collaboration diagram for PhpOffice\PhpSpreadsheet\Calculation\Database:

Static Public Member Functions
static	DAVERAGE ($database, $field, $criteria)
	DAVERAGE. More...

static	DCOUNT ($database, $field, $criteria)
	DCOUNT. More...

static	DCOUNTA ($database, $field, $criteria)
	DCOUNTA. More...

static	DGET ($database, $field, $criteria)
	DGET. More...

static	DMAX ($database, $field, $criteria)
	DMAX. More...

static	DMIN ($database, $field, $criteria)
	DMIN. More...

static	DPRODUCT ($database, $field, $criteria)
	DPRODUCT. More...

static	DSTDEV ($database, $field, $criteria)
	DSTDEV. More...

static	DSTDEVP ($database, $field, $criteria)
	DSTDEVP. More...

static	DSUM ($database, $field, $criteria)
	DSUM. More...

static	DVAR ($database, $field, $criteria)
	DVAR. More...

static	DVARP ($database, $field, $criteria)
	DVARP. More...

Detailed Description

Deprecated:: 1.17.0

Definition at line 8 of file Database.php.

Member Function Documentation

◆ DAVERAGE()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DAVERAGE	(	$database,
		$field,
		$criteria
	)

static

DAVERAGE.

Averages the values in a column of a list or database that match conditions you specify.

Excel Function: DAVERAGE(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: null|float|string

Definition at line 40 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DAverage\evaluate().

     {
         return Database\DAverage::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DCOUNT()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DCOUNT	(	$database,
		$field,
		$criteria
	)

static

DCOUNT.

Counts the cells that contain numbers in a column of a list or database that match conditions that you specify.

Excel Function: DCOUNT(database,[field],criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
null \| int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: int

The field argument is optional. If field is omitted, DCOUNT counts all records in the database that match the criteria.

Definition at line 79 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DCount\evaluate().

     {
         return Database\DCount::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DCOUNTA()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DCOUNTA	(	$database,
		$field,
		$criteria
	)

static

DCOUNTA.

Counts the nonblank cells in a column of a list or database that match conditions that you specify.

Excel Function: DCOUNTA(database,[field],criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
null \| int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: int

Definition at line 114 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DCountA\evaluate().

     {
         return Database\DCountA::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DGET()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DGET	(	$database,
		$field,
		$criteria
	)

static

DGET.

Extracts a single value from a column of a list or database that matches conditions that you specify.

Excel Function: DGET(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: mixed

Definition at line 150 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DGet\evaluate().

     {
         return Database\DGet::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DMAX()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DMAX	(	$database,
		$field,
		$criteria
	)

static

DMAX.

Returns the largest number in a column of a list or database that matches conditions you that specify.

Excel Function: DMAX(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float

Definition at line 186 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DMax\evaluate().

     {
         return Database\DMax::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DMIN()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DMIN	(	$database,
		$field,
		$criteria
	)

static

DMIN.

Returns the smallest number in a column of a list or database that matches conditions you that specify.

Excel Function: DMIN(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float

Definition at line 222 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DMin\evaluate().

     {
         return Database\DMin::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DPRODUCT()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DPRODUCT	(	$database,
		$field,
		$criteria
	)

static

DPRODUCT.

Multiplies the values in a column of a list or database that match conditions that you specify.

Excel Function: DPRODUCT(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string

Definition at line 257 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DProduct\evaluate().

     {
         return Database\DProduct::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DSTDEV()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DSTDEV	(	$database,
		$field,
		$criteria
	)

static

DSTDEV.

Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSTDEV(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string

Definition at line 293 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DStDev\evaluate().

     {
         return Database\DStDev::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DSTDEVP()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DSTDEVP	(	$database,
		$field,
		$criteria
	)

static

DSTDEVP.

Calculates the standard deviation of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSTDEVP(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string

Definition at line 329 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DStDevP\evaluate().

     {
         return Database\DStDevP::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DSUM()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DSUM	(	$database,
		$field,
		$criteria
	)

static

DSUM.

Adds the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DSUM(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string

Definition at line 364 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DSum\evaluate().

     {
         return Database\DSum::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DVAR()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DVAR	(	$database,
		$field,
		$criteria
	)

static

DVAR.

Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DVAR(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string (string if result is an error)

Definition at line 400 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DVar\evaluate().

     {
         return Database\DVar::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

◆ DVARP()

static PhpOffice\PhpSpreadsheet\Calculation\Database::DVARP	(	$database,
		$field,
		$criteria
	)

static

DVARP.

Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions that you specify.

Excel Function: DVARP(database,field,criteria)

1.17.0

See also: Database::evaluate() Use the evaluate() method in the Database class instead

Parameters

	mixed[]	$database The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields. The first row of the list contains labels for each column.
int \| string	$field	Indicates which column is used in the function. Enter the column label enclosed between double quotation marks, such as "Age" or "Yield," or a number (without quotation marks) that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.
	mixed[]	$criteria The range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label in which you specify a condition for the column.

Returns: float|string (string if result is an error)

Definition at line 436 of file Database.php.

References PhpOffice\PhpSpreadsheet\Calculation\Database\DVarP\evaluate().

     {
         return Database\DVarP::evaluate($database, $field, $criteria);
     }

Here is the call graph for this function:

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

libs/composer/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/Database.php

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ DAVERAGE()

◆ DCOUNT()

◆ DCOUNTA()

◆ DGET()

◆ DMAX()

◆ DMIN()

◆ DPRODUCT()

◆ DSTDEV()

◆ DSTDEVP()

◆ DSUM()

◆ DVAR()

◆ DVARP()