Syncfusion.XlsIO.Base


Syncfusion.XlsIO Namespace : Excel2007Function Enumeration

Excel2007Function Enumeration

Represents functions added in Excel 2007.
Syntax
'Declaration
 
Public Enum Excel2007Function 
   Inherits System.Enum
'Usage
 
Dim instance As Excel2007Function
public enum Excel2007Function : System.Enum 
Members
MemberDescription
AVERAGEIF Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS Returns the average (arithmetic mean) of all cells that meet multiple criteria.
BESSELI Returns the modified Bessel function In(x).
BESSELJ Returns the Bessel function Jn(x).
BESSELK Returns the modified Bessel function Kn(x).
BESSELY Returns the Bessel function Yn(x).
BIN2DEC Converts a binary number to decimal.
BIN2HEX Converts a binary number to hexadecimal.
BIN2OCT Converts a binary number to octal.
COMPLEX Converts real and imaginary coefficients into a complex number.
CONVERT Converts a number from one measurement system to another.
CUBEKPIMEMBER Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.
CUBEMEMBER Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CUBEMEMBERPROPERTY Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member.
CUBERANKEDMEMBER Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students.
CUBESET Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.
CUBESETCOUNT Returns the number of items in a set.
CUBEVALUE Returns an aggregated value from a cube.
DEC2BIN Converts a decimal number to binary.
DEC2HEX Converts a decimal number to hexadecimal.
DEC2OCT Converts a decimal number to octal.
DELTA Tests whether two values are equal.
ERF Returns the error function.
ERFC Returns the complementary error function.
GESTEP Tests whether a number is greater than a threshold value.
HEX2BIN Converts a hexadecimal number to binary.
HEX2DEC Converts a hexadecimal number to decimal.
HEX2OCT Converts a hexadecimal number to octal.
IMABS Returns the absolute value (modulus) of a complex number.
IMAGINARY Returns the imaginary coefficient of a complex number.
IMARGUMENT Returns the argument theta, an angle expressed in radians.
IMCONJUGATE Returns the complex conjugate of a complex number.
IMCOS Returns the cosine of a complex number
IMDIV Returns the quotient of two complex numbers.
IMEXP Returns the exponential of a complex number.
IMLN Returns the natural logarithm of a complex number.
IMLOG10 Returns the base-10 logarithm of a complex number.
IMLOG2 Returns the base-2 logarithm of a complex number.
IMPOWER Returns a complex number raised to an integer power.
IMPRODUCT Returns the product of from 2 to 29 complex numbers
IMREAL Returns the real coefficient of a complex number
IMSIN Returns the sine of a complex number
IMSQRT Returns the square root of a complex number
IMSUB Returns the difference between two complex numbers
IMSUM Returns the sum of complex numbers.
OCT2BIN Converts an octal number to binary.
OCT2DEC Converts an octal number to decimal.
OCT2HEX Converts an octal number to hexadecimal.
SUMIFS Adds the cells in a range that meet multiple criteria
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         Syncfusion.XlsIO.Excel2007Function

AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also