public static function PHPExcel_Calculation_Database::DGET in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php \PHPExcel_Calculation_Database::DGET()

* 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) * * @access public * @category Database Functions *

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. * @param string|integer $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. * @param 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. * @return mixed *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Database.php, line 328

Class

PHPExcel_Calculation_Database

PHPExcel_Calculation_Database

Code

public static function DGET($database, $field, $criteria) {
  $field = self::__fieldExtract($database, $field);
  if (is_null($field)) {
    return NULL;
  }

  //	reduce the database to a set of rows that match all the criteria
  $database = self::__filter($database, $criteria);

  //	extract an array of values for the requested column
  $colData = array();
  foreach ($database as $row) {
    $colData[] = $row[$field];
  }

  // Return
  if (count($colData) > 1) {
    return PHPExcel_Calculation_Functions::NaN();
  }
  return $colData[0];
}