C# CalculationEngine.RegisterFunction方法代码示例

 public static void Register(CalculationEngine ce)
 {
     ce.RegisterFunction("AND" , 1 , int.MaxValue , And);
     ce.RegisterFunction("OR"  , 1 , int.MaxValue , Or);
     ce.RegisterFunction("NOT"   , 1 , Not);
     ce.RegisterFunction("IF"    , 3 , If);
     ce.RegisterFunction("TRUE"  , 0 , True);
     ce.RegisterFunction("FALSE" , 0 , False);
 }

 public static void Register(CalculationEngine ce)
 {
     //ce.RegisterFunction("AVEDEV", AveDev, 1, int.MaxValue);
     ce.RegisterFunction("AVERAGE", 1, int.MaxValue, Average);
     ce.RegisterFunction("AVERAGEA", 1, int.MaxValue, AverageA);
     //BETADIST	Returns the beta cumulative distribution function
     //BETAINV	Returns the inverse of the cumulative distribution function for a specified beta distribution
     //BINOMDIST	Returns the individual term binomial distribution probability
     //CHIDIST	Returns the one-tailed probability of the chi-squared distribution
     //CHIINV	Returns the inverse of the one-tailed probability of the chi-squared distribution
     //CHITEST	Returns the test for independence
     //CONFIDENCE	Returns the confidence interval for a population mean
     //CORREL	Returns the correlation coefficient between two data sets
     ce.RegisterFunction("COUNT", 1, int.MaxValue, Count);
     ce.RegisterFunction("COUNTA", 1, int.MaxValue, CountA);
     ce.RegisterFunction("COUNTBLANK", 1, int.MaxValue, CountBlank);
     ce.RegisterFunction("COUNTIF", 2, CountIf);
     //COVAR	Returns covariance, the average of the products of paired deviations
     //CRITBINOM	Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
     //DEVSQ	Returns the sum of squares of deviations
     //EXPONDIST	Returns the exponential distribution
     //FDIST	Returns the F probability distribution
     //FINV	Returns the inverse of the F probability distribution
     //FISHER	Returns the Fisher transformation
     //FISHERINV	Returns the inverse of the Fisher transformation
     //FORECAST	Returns a value along a linear trend
     //FREQUENCY	Returns a frequency distribution as a vertical array
     //FTEST	Returns the result of an F-test
     //GAMMADIST	Returns the gamma distribution
     //GAMMAINV	Returns the inverse of the gamma cumulative distribution
     //GAMMALN	Returns the natural logarithm of the gamma function, Γ(x)
     //GEOMEAN	Returns the geometric mean
     //GROWTH	Returns values along an exponential trend
     //HARMEAN	Returns the harmonic mean
     //HYPGEOMDIST	Returns the hypergeometric distribution
     //INTERCEPT	Returns the intercept of the linear regression line
     //KURT	Returns the kurtosis of a data set
     //LARGE	Returns the k-th largest value in a data set
     //LINEST	Returns the parameters of a linear trend
     //LOGEST	Returns the parameters of an exponential trend
     //LOGINV	Returns the inverse of the lognormal distribution
     //LOGNORMDIST	Returns the cumulative lognormal distribution
     ce.RegisterFunction("MAX", 1, int.MaxValue, Max);
     ce.RegisterFunction("MAXA", 1, int.MaxValue, MaxA);
     //MEDIAN	Returns the median of the given numbers
     ce.RegisterFunction("MIN", 1, int.MaxValue, Min);
     ce.RegisterFunction("MINA", 1, int.MaxValue, MinA);
     //MODE	Returns the most common value in a data set
     //NEGBINOMDIST	Returns the negative binomial distribution
     //NORMDIST	Returns the normal cumulative distribution
     //NORMINV	Returns the inverse of the normal cumulative distribution
     //NORMSDIST	Returns the standard normal cumulative distribution
     //NORMSINV	Returns the inverse of the standard normal cumulative distribution
     //PEARSON	Returns the Pearson product moment correlation coefficient
     //PERCENTILE	Returns the k-th percentile of values in a range
     //PERCENTRANK	Returns the percentage rank of a value in a data set
     //PERMUT	Returns the number of permutations for a given number of objects
     //POISSON	Returns the Poisson distribution
     //PROB	Returns the probability that values in a range are between two limits
     //QUARTILE	Returns the quartile of a data set
     //RANK	Returns the rank of a number in a list of numbers
     //RSQ	Returns the square of the Pearson product moment correlation coefficient
     //SKEW	Returns the skewness of a distribution
     //SLOPE	Returns the slope of the linear regression line
     //SMALL	Returns the k-th smallest value in a data set
     //STANDARDIZE	Returns a normalized value
     ce.RegisterFunction("STDEV", 1, int.MaxValue, StDev);
     ce.RegisterFunction("STDEVA", 1, int.MaxValue, StDevA);
     ce.RegisterFunction("STDEVP", 1, int.MaxValue, StDevP);
     ce.RegisterFunction("STDEVPA", 1, int.MaxValue, StDevPA);
     //STEYX	Returns the standard error of the predicted y-value for each x in the regression
     //TDIST	Returns the Student's t-distribution
     //TINV	Returns the inverse of the Student's t-distribution
     //TREND	Returns values along a linear trend
     //TRIMMEAN	Returns the mean of the interior of a data set
     //TTEST	Returns the probability associated with a Student's t-test
     ce.RegisterFunction("VAR", 1, int.MaxValue, Var);
     ce.RegisterFunction("VARA", 1, int.MaxValue, VarA);
     ce.RegisterFunction("VARP", 1, int.MaxValue, VarP);
     ce.RegisterFunction("VARPA", 1, int.MaxValue, VarPA);
     //WEIBULL	Returns the Weibull distribution
     //ZTEST	Returns the one-tailed probability-value of a z-test
 }

 public static void Register(CalculationEngine ce)
 {
     //ce.RegisterFunction("ASC	Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
     //ce.RegisterFunction("BAHTTEXT	Converts a number to text, using the ß (baht) currency format
     ce.RegisterFunction("CHAR", 1, _Char); // Returns the character specified by the code number
     //ce.RegisterFunction("CLEAN	Removes all nonprintable characters from text
     ce.RegisterFunction("CODE", 1, Code); // Returns a numeric code for the first character in a text string
     ce.RegisterFunction("CONCATENATE", 1, int.MaxValue, Concat); //	Joins several text items into one text item
     //ce.RegisterFunction("DOLLAR	Converts a number to text, using the $ (dollar) currency format
     //ce.RegisterFunction("EXACT	Checks to see if two text values are identical
     ce.RegisterFunction("FIND", 2, 3, Find); //Finds one text value within another (case-sensitive)
     //ce.RegisterFunction("FIXED	Formats a number as text with a fixed number of decimals
     //ce.RegisterFunction("JIS	Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters
     ce.RegisterFunction("LEFT", 1, 2, Left); // LEFTB	Returns the leftmost characters from a text value
     ce.RegisterFunction("LEN", 1, Len); //, Returns the number of characters in a text string
     ce.RegisterFunction("LOWER", 1, Lower); //	Converts text to lowercase
     ce.RegisterFunction("MID", 3, Mid); // Returns a specific number of characters from a text string starting at the position you specify
     //ce.RegisterFunction("PHONETIC	Extracts the phonetic (furigana) characters from a text string
     ce.RegisterFunction("PROPER", 1, Proper); // Capitalizes the first letter in each word of a text value
     ce.RegisterFunction("REPLACE", 4, Replace); // Replaces characters within text
     ce.RegisterFunction("REPT", 2, Rept); // Repeats text a given number of times
     ce.RegisterFunction("RIGHT", 1, 2, Right); // Returns the rightmost characters from a text value
     ce.RegisterFunction("SEARCH", 2, Search); // Finds one text value within another (not case-sensitive)
     ce.RegisterFunction("SUBSTITUTE", 3, 4, Substitute); // Substitutes new text for old text in a text string
     ce.RegisterFunction("T", 1, T); // Converts its arguments to text
     ce.RegisterFunction("TEXT", 2, _Text); // Formats a number and converts it to text
     ce.RegisterFunction("TRIM", 1, Trim); // Removes spaces from text
     ce.RegisterFunction("UPPER", 1, Upper); // Converts text to uppercase
     ce.RegisterFunction("VALUE", 1, Value); // Converts a text argument to a number
 }