function.cs

Excel的操作,其中可以读取及写入Excel 文件

				public static readonly Function LOG;
		//public static final Function EXEC;
				public static readonly Function CHAR;
				public static readonly Function LOWER;
				public static readonly Function UPPER;
				public static readonly Function PROPER;
				public static readonly Function LEFT;
				public static readonly Function RIGHT;
				public static readonly Function EXACT;
				public static readonly Function TRIM;
				public static readonly Function REPLACE;
				public static readonly Function SUBSTITUTE;
				public static readonly Function CODE;
		//public static final Function NAMES;
		//public static final Function DIRECTORY;
				public static readonly Function FIND;
				public static readonly Function CELL;
				public static readonly Function ISERR;
				public static readonly Function ISTEXT;
				public static readonly Function ISNUMBER;
				public static readonly Function ISBLANK;
				public static readonly Function T;
				public static readonly Function N;
		//public static final Function FOPEN;
		//public static final Function FCLOSE;
		//public static final Function FSIZE;
		//public static final Function FREADLN;
		//public static final Function FREAD;
		//public static final Function FWRITELN;
		//public static final Function FWRITE;
		//public static final Function FPOS;
				public static readonly Function DATEVALUE;
				public static readonly Function TIMEVALUE;
				public static readonly Function SLN;
				public static readonly Function SYD;
				public static readonly Function DDB;
		//public static final Function GETDEF;
		//public static final Function REFTEXT;
		//public static final Function TEXTREF;
				public static readonly Function INDIRECT;
		//public static final Function REGISTER;
		//public static final Function CALL;
		//public static final Function ADDBAR;
		//public static final Function ADDMENU;
		//public static final Function ADDCOMMAND;
		//public static final Function ENABLECOMMAND;
		//public static final Function CHECKCOMMAND;
		//public static final Function RENAMECOMMAND;
		//public static final Function SHOWBAR;
		//public static final Function DELETEMENU;
		//public static final Function DELETECOMMAND;
		//public static final Function GETCHARTITEM;
		//public static final Function DIALOGBOX;
				public static readonly Function CLEAN;
				public static readonly Function MDETERM;
				public static readonly Function MINVERSE;
				public static readonly Function MMULT;
		//public static final Function FILES;
				public static readonly Function IPMT;
				public static readonly Function PPMT;
				public static readonly Function COUNTA;
				public static readonly Function PRODUCT;
				public static readonly Function FACT;
		//public static final Function GETCELL;
		//public static final Function GETWORKSPACE;
		//public static final Function GETWINDOW;
		//public static final Function GETDOCUMENT;
				public static readonly Function DPRODUCT;
				public static readonly Function ISNONTEXT;
		//public static final Function GETNOTE;
		//public static final Function NOTE;
				public static readonly Function STDEVP;
				public static readonly Function VARP;
				public static readonly Function DSTDEVP;
				public static readonly Function DVARP;
				public static readonly Function TRUNC;
				public static readonly Function ISLOGICAL;
				public static readonly Function DCOUNTA;
				public static readonly Function FINDB;
				public static readonly Function SEARCHB;
				public static readonly Function REPLACEB;
				public static readonly Function LEFTB;
				public static readonly Function RIGHTB;
				public static readonly Function MIDB;
				public static readonly Function LENB;
				public static readonly Function ROUNDUP;
				public static readonly Function ROUNDDOWN;
				public static readonly Function RANK;
				public static readonly Function ADDRESS;
				public static readonly Function AYS360;
				public static readonly Function ODAY;
				public static readonly Function VDB;
				public static readonly Function MEDIAN;
				public static readonly Function SUMPRODUCT;
				public static readonly Function SINH;
				public static readonly Function COSH;
				public static readonly Function TANH;
				public static readonly Function ASINH;
				public static readonly Function ACOSH;
				public static readonly Function ATANH;
				public static readonly Function AVEDEV;
				public static readonly Function BETADIST;
				public static readonly Function GAMMALN;
				public static readonly Function BETAINV;
				public static readonly Function BINOMDIST;
				public static readonly Function CHIDIST;
				public static readonly Function CHIINV;
				public static readonly Function COMBIN;
				public static readonly Function CONFIDENCE;
				public static readonly Function CRITBINOM;
				public static readonly Function EVEN;
				public static readonly Function EXPONDIST;
				public static readonly Function FDIST;
				public static readonly Function FINV;
				public static readonly Function FISHER;
				public static readonly Function FISHERINV;
				public static readonly Function FLOOR;
				public static readonly Function GAMMADIST;
				public static readonly Function GAMMAINV;
				public static readonly Function CEILING;
				public static readonly Function HYPGEOMDIST;
				public static readonly Function LOGNORMDIST;
				public static readonly Function LOGINV;
				public static readonly Function NEGBINOMDIST;
				public static readonly Function NORMDIST;
				public static readonly Function NORMSDIST;
				public static readonly Function NORMINV;
				public static readonly Function NORMSINV;
				public static readonly Function STANDARDIZE;
				public static readonly Function ODD;
				public static readonly Function PERMUT;
				public static readonly Function POISSON;
				public static readonly Function TDIST;
				public static readonly Function WEIBULL;
				public static readonly Function SUMXMY2;
				public static readonly Function SUMX2MY2;
				public static readonly Function SUMX2PY2;
				public static readonly Function CHITEST;
				public static readonly Function CORREL;
				public static readonly Function COVAR;
				public static readonly Function FORECAST;
				public static readonly Function FTEST;
				public static readonly Function INTERCEPT;
				public static readonly Function PEARSON;
				public static readonly Function RSQ;
				public static readonly Function STEYX;
				public static readonly Function SLOPE;
				public static readonly Function TTEST;
				public static readonly Function PROB;
				public static readonly Function DEVSQ;
				public static readonly Function GEOMEAN;
				public static readonly Function HARMEAN;
				public static readonly Function SUMSQ;
				public static readonly Function KURT;
				public static readonly Function SKEW;
				public static readonly Function ZTEST;
				public static readonly Function LARGE;
				public static readonly Function SMALL;
				public static readonly Function QUARTILE;
				public static readonly Function PERCENTILE;
				public static readonly Function PERCENTRANK;
				public static readonly Function MODE;
				public static readonly Function TRIMMEAN;
				public static readonly Function TINV;
				public static readonly Function CONCATENATE;
				public static readonly Function POWER;
				public static readonly Function RADIANS;
				public static readonly Function DEGREES;
				public static readonly Function SUBTOTAL;
				public static readonly Function SUMIF;
				public static readonly Function COUNTIF;
				public static readonly Function COUNTBLANK;
				public static readonly Function HYPERLINK;
				public static readonly Function AVERAGEA;
				public static readonly Function MAXA;
				public static readonly Function MINA;
				public static readonly Function STDEVPA;
				public static readonly Function VARPA;
				public static readonly Function STDEVA;
				public static readonly Function VARA;
		
		// If token.  This is not an excel assigned number, but one made up
		// in order that the if command may be recognized
				public static readonly Function IF;
		
		// Unknown token
				public static readonly Function UNKNOWN;

		static Function()
		{
			logger = Logger.getLogger(typeof(Function));
			functions = new Function[0];

				 COUNT = new Function(0x0, "count", 0xff);
				 ATTRIBUTE = new Function(0x1, "", 0xff);
				 ISNA = new Function(0x2, "isna", 1);
				 ISERROR = new Function(0x3, "iserror", 1);
				 SUM = new Function(0x4, "sum", 0xff);
				 AVERAGE = new Function(0x5, "average", 0xff);
				 MIN = new Function(0x6, "min", 0xff);
				 MAX = new Function(0x7, "max", 0xff);
				 ROW = new Function(0x8, "row", 0xff);
				 COLUMN = new Function(0x9, "column", 1);
				 NA = new Function(0xa, "na", 0);
				 NPV = new Function(0xb, "npv", 0xff);
				 STDEV = new Function(0xc, "stdev", 0xff);
				 DOLLAR = new Function(0xd, "dollar", 2);
				 FIXED = new Function(0xe, "fixed", 0xff);
				 SIN = new Function(0xf, "sin", 1);
				 COS = new Function(0x10, "cos", 1);
				 TAN = new Function(0x11, "tan", 1);
				 ATAN = new Function(0x12, "atan", 1);
				 PI = new Function(0x13, "pi", 0);
				 SQRT = new Function(0x14, "sqrt", 1);
				 EXP = new Function(0x15, "exp", 1);
				 LN = new Function(0x16, "ln", 1);
				 LOG10 = new Function(0x17, "log10", 1);
				 ABS = new Function(0x18, "abs", 1);
				 INT = new Function(0x19, "int", 1);
				 SIGN = new Function(0x1a, "sign", 1);
				 ROUND = new Function(0x1b, "round", 2);
		//public static final Function LOOKUP =  new Function(0x1c, "LOOKUP",);
				 INDEX = new Function(0x1d, "index", 3);
		//public static final Function REPT =  new Function(0x1e, "REPT",);
				 MID = new Function(0x1f, "mid", 3);
				 LEN = new Function(0x20, "len", 1);
				 VALUE = new Function(0x21, "value", 1);
				 TRUE_Renamed = new Function(0x22, "true", 0);
				 FALSE_Renamed = new Function(0x23, "false", 0);
				 AND = new Function(0x24, "and", 0xff);
				 OR = new Function(0x25, "or", 0xff);
				 NOT = new Function(0x26, "not", 1);
				 MOD = new Function(0x27, "mod", 2);
				 DCOUNT = new Function(0x28, "dcount", 3);
				 DSUM = new Function(0x29, "dsum", 3);
				 DAVERAGE = new Function(0x2a, "daverage", 3);
				 DMIN = new Function(0x2b, "dmin", 3);
				 DMAX = new Function(0x2c, "dmax", 3);
				 DSTDEV = new Function(0x2d, "dstdev", 3);
				 VAR = new Function(0x2e, "var", 0xff);
				 DVAR = new Function(0x2f, "dvar", 3);
				 TEXT = new Function(0x30, "text", 2);
				 LINEST = new Function(0x31, "linest", 0xff);
				 TREND = new Function(0x32, "trend", 0xff);
				 LOGEST = new Function(0x33, "logest", 0xff);
				 GROWTH = new Function(0x34, "growth", 0xff);
		//public static final Function GOTO =  new Function(0x35, "GOTO",);