Database Functions
- 2 minutes to read
This document briefly describes database functions implemented in the ASPxSpreadsheet.
The database functions operates on a range of cells that makes up the list or database. A database in this context is a list of related data in which rows are records and columns are fields. The first row of the list contains labels for each column.
The database (or list) is identified as the datalist parameter in function syntax.
DAVERAGE(datalist, field, criteria)- Returns the average of selected database entries.
DCOUNT(datalist, field, criteria)- Counts the cells that contain numbers in a database.
DCOUNTA(datalist, field, criteria)- Counts nonblank cells in a database.
DGET(datalist, field, criteria)- Extracts from a database a single record that matches the specified criteria.
DMAX(datalist, field, criteria)- Returns the maximum value from selected database entries.
DMIN(datalist, field, criteria)- Returns the minimum value from selected database entries.
DPRODUCT(datalist, field, criteria)- Multiplies the values in a particular field of records that match the criteria in a database.
DSTDEV(datalist, field, criteria)- Estimates the standard deviation based on a sample of selected database entries.
DSTDEVP(datalist, field, criteria)- Calculates the standard deviation based on the entire population of selected database entries.
DSUM(datalist, field, criteria)- Adds the numbers in the field column of records in the database that match the criteria.
DVAR(datalist, field, criteria)- Estimates variance based on a sample from selected database entries.
DVARP(datalist, field, criteria)- Calculates variance based on the entire population of selected database entries.
Example
worksheet.Cells["C4"].Formula = "=DAVERAGE(C2:D14, "Total", B2:B4)";