function.cs

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

		//public static final Function HALT =  new Function(0x36, "HALT",);
				 PV = new Function(0x38, "pv", 0xff);
				 FV = new Function(0x39, "fv", 0xff);
				 NPER = new Function(0x3a, "nper", 0xff);
				 PMT = new Function(0x3b, "pmt", 0xff);
				 RATE = new Function(0x3c, "rate", 0xff);
		//public static final Function MIRR =  new Function(0x3d, "MIRR",);
		//public static final Function IRR =  new Function(0x3e, "IRR",);
				 RAND = new Function(0x3f, "rand", 0);
				 MATCH = new Function(0x40, "match", 3);
				 DATE = new Function(0x41, "date", 3);
				 TIME = new Function(0x42, "time", 3);
				 DAY = new Function(0x43, "day", 1);
				 MONTH = new Function(0x44, "month", 1);
				 YEAR = new Function(0x45, "year", 1);
				 WEEKDAY = new Function(0x46, "weekday", 2);
				 HOUR = new Function(0x47, "hour", 1);
				 MINUTE = new Function(0x48, "minute", 1);
				 SECOND = new Function(0x49, "second", 1);
				 NOW = new Function(0x4a, "now", 0);
				 AREAS = new Function(0x4b, "areas", 0xff);
				 ROWS = new Function(0x4c, "rows", 0xff);
				 COLUMNS = new Function(0x4d, "columns", 0xff);
				 OFFSET = new Function(0x4e, "offset", 0xff);
		//public static final Function ABSREF =  new Function(0x4f, "ABSREF",);
		//public static final Function RELREF =  new Function(0x50, "RELREF",);
		//public static final Function ARGUMENT =  new Function(0x51,"ARGUMENT",);
		//public static final Function SEARCH =  new Function(0x52, "SEARCH",3);
				 TRANSPOSE = new Function(0x53, "transpose", 0xff);
				 ERROR = new Function(0x54, "error", 1);
		//public static final Function STEP =  new Function(0x55, "STEP",);
				 TYPE = new Function(0x56, "type", 1);
		//public static final Function ECHO =  new Function(0x57, "ECHO",);
		//public static final Function SETNAME =  new Function(0x58, "SETNAME",);
		//public static final Function CALLER =  new Function(0x59, "CALLER",);
		//public static final Function DEREF =  new Function(0x5a, "DEREF",);
		//public static final Function WINDOWS =  new Function(0x5b, "WINDOWS",);
		//public static final Function SERIES =  new Function(0x5c, "SERIES",);
		//public static final Function DOCUMENTS =  new Function(0x5d,"DOCUMENTS",);
		//public static final Function ACTIVECELL =  new Function(0x5e,"ACTIVECELL",);
		//public static final Function SELECTION =  new Function(0x5f,"SELECTION",);
		//public static final Function RESULT =  new Function(0x60, "RESULT",);
				 ATAN2 = new Function(0x61, "atan2", 1);
				 ASIN = new Function(0x62, "asin", 1);
				 ACOS = new Function(0x63, "acos", 1);
				 CHOOSE = new Function(0x64, "choose", 0xff);
				 HLOOKUP = new Function(0x65, "hlookup", 0xff);
				 VLOOKUP = new Function(0x66, "vlookup", 0xff);
		//public static final Function LINKS =  new Function(0x67, "LINKS",);
		//public static final Function INPUT =  new Function(0x68, "INPUT",);
				 ISREF = new Function(0x69, "isref", 1);
		//public static final Function GETFORMULA =  new Function(0x6a,"GETFORMULA",);
		//public static final Function GETNAME =  new Function(0x6b, "GETNAME",);
		//public static final Function SETVALUE =  new Function(0x6c,"SETVALUE",);
				 LOG = new Function(0x6d, "log", 0xff);
		//public static final Function EXEC =  new Function(0x6e, "EXEC",);
				 CHAR = new Function(0x6f, "char", 1);
				 LOWER = new Function(0x70, "lower", 1);
				 UPPER = new Function(0x71, "upper", 1);
				 PROPER = new Function(0x72, "proper", 1);
				 LEFT = new Function(0x73, "left", 0xff);
				 RIGHT = new Function(0x74, "right", 0xff);
				 EXACT = new Function(0x75, "exact", 2);
				 TRIM = new Function(0x76, "trim", 1);
				 REPLACE = new Function(0x77, "replace", 4);
				 SUBSTITUTE = new Function(0x78, "substitute", 0xff);
				 CODE = new Function(0x79, "code", 1);
		//public static final Function NAMES =  new Function(0x7a, "NAMES",);
		//public static final Function DIRECTORY =  new Function(0x7b,"DIRECTORY",);
				 FIND = new Function(0x7c, "find", 0xff);
				 CELL = new Function(0x7d, "cell", 2);
				 ISERR = new Function(0x7e, "iserr", 1);
				 ISTEXT = new Function(0x7f, "istext", 1);
				 ISNUMBER = new Function(0x80, "isnumber", 1);
				 ISBLANK = new Function(0x81, "isblank", 1);
				 T = new Function(0x82, "t", 1);
				 N = new Function(0x83, "n", 1);
		//public static final Function FOPEN =  new Function(0x84, "FOPEN",);
		//public static final Function FCLOSE =  new Function(0x85, "FCLOSE",);
		//public static final Function FSIZE =  new Function(0x86, "FSIZE",);
		//public static final Function FREADLN =  new Function(0x87, "FREADLN",);
		//public static final Function FREAD =  new Function(0x88, "FREAD",);
		//public static final Function FWRITELN =  new Function(0x89,"FWRITELN",);
		//public static final Function FWRITE =  new Function(0x8a, "FWRITE",);
		//public static final Function FPOS =  new Function(0x8b, "FPOS",);
				 DATEVALUE = new Function(0x8c, "datevalue", 1);
				 TIMEVALUE = new Function(0x8d, "timevalue", 1);
				 SLN = new Function(0x8e, "sln", 3);
				 SYD = new Function(0x8f, "syd", 3);
				 DDB = new Function(0x90, "ddb", 0xff);
		//public static final Function GETDEF =  new Function(0x91, "GETDEF",);
		//public static final Function REFTEXT =  new Function(0x92, "REFTEXT",);
		//public static final Function TEXTREF =  new Function(0x93, "TEXTREF",);
				 INDIRECT = new Function(0x94, "indirect", 0xff);
		//public static final Function REGISTER =  new Function(0x95,"REGISTER",);
		//public static final Function CALL =  new Function(0x96, "CALL",);
		//public static final Function ADDBAR =  new Function(0x97, "ADDBAR",);
		//public static final Function ADDMENU =  new Function(0x98, "ADDMENU",);
		//public static final Function ADDCOMMAND =  new Function(0x99,"ADDCOMMAND",);
		//public static final Function ENABLECOMMAND =  new Function(0x9a,"ENABLECOMMAND",);
		//public static final Function CHECKCOMMAND =  new Function(0x9b,"CHECKCOMMAND",);
		//public static final Function RENAMECOMMAND =  new Function(0x9c,"RENAMECOMMAND",);
		//public static final Function SHOWBAR =  new Function(0x9d, "SHOWBAR",);
		//public static final Function DELETEMENU =  new Function(0x9e,"DELETEMENU",);
		//public static final Function DELETECOMMAND =  new Function(0x9f,"DELETECOMMAND",);
		//public static final Function GETCHARTITEM =  new Function(0xa0,"GETCHARTITEM",);
		//public static final Function DIALOGBOX =  new Function(0xa1,"DIALOGBOX",);
				 CLEAN = new Function(0xa2, "clean", 1);
				 MDETERM = new Function(0xa3, "mdeterm", 0xff);
				 MINVERSE = new Function(0xa4, "minverse", 0xff);
				 MMULT = new Function(0xa5, "mmult", 0xff);
		//public static final Function FILES =  new Function(0xa6, "FILES",);
				 IPMT = new Function(0xa7, "ipmt", 0xff);
				 PPMT = new Function(0xa8, "ppmt", 0xff);
				 COUNTA = new Function(0xa9, "counta", 0xff);
				 PRODUCT = new Function(0xb7, "product", 0xff);
				 FACT = new Function(0xb8, "fact", 1);
		//public static final Function GETCELL =  new Function(0xb9, "GETCELL",);
		//public static final Function GETWORKSPACE =  new Function(0xba,"GETWORKSPACE",);
		//public static final Function GETWINDOW =  new Function(0xbb,"GETWINDOW",);
		//public static final Function GETDOCUMENT =  new Function(0xbc,"GETDOCUMENT",);
				 DPRODUCT = new Function(0xbd, "dproduct", 3);
				 ISNONTEXT = new Function(0xbe, "isnontext", 1);
		//public static final Function GETNOTE =  new Function(0xbf, "GETNOTE",);
		//public static final Function NOTE =  new Function(0xc0, "NOTE",);
				 STDEVP = new Function(0xc1, "stdevp", 0xff);
				 VARP = new Function(0xc2, "varp", 0xff);
				 DSTDEVP = new Function(0xc3, "dstdevp", 0xff);
				 DVARP = new Function(0xc4, "dvarp", 0xff);
				 TRUNC = new Function(0xc5, "trunc", 0xff);
				 ISLOGICAL = new Function(0xc6, "islogical", 1);
				 DCOUNTA = new Function(0xc7, "dcounta", 0xff);
				 FINDB = new Function(0xcd, "findb", 0xff);
				 SEARCHB = new Function(0xce, "searchb", 3);
				 REPLACEB = new Function(0xcf, "replaceb", 4);
				 LEFTB = new Function(0xd0, "leftb", 0xff);
				 RIGHTB = new Function(0xd1, "rightb", 0xff);
				 MIDB = new Function(0xd2, "midb", 3);
				 LENB = new Function(0xd3, "lenb", 1);
				 ROUNDUP = new Function(0xd4, "roundup", 2);
				 ROUNDDOWN = new Function(0xd5, "rounddown", 2);
				 RANK = new Function(0xd8, "rank", 0xff);
				 ADDRESS = new Function(0xdb, "address", 0xff);
				 AYS360 = new Function(0xdc, "days360", 0xff);
				 ODAY = new Function(0xdd, "today", 0);
				 VDB = new Function(0xde, "vdb", 0xff);
				 MEDIAN = new Function(0xe3, "median", 0xff);
				 SUMPRODUCT = new Function(0xe4, "sumproduct", 0xff);
				 SINH = new Function(0xe5, "sinh", 1);
				 COSH = new Function(0xe6, "cosh", 1);
				 TANH = new Function(0xe7, "tanh", 1);
				 ASINH = new Function(0xe8, "asinh", 1);
				 ACOSH = new Function(0xe9, "acosh", 1);
				 ATANH = new Function(0xea, "atanh", 1);
				 AVEDEV = new Function(0x10d, "avedev", 0xFF);
				 BETADIST = new Function(0x10e, "betadist", 0xFF);
				 GAMMALN = new Function(0x10f, "gammaln", 1);
				 BETAINV = new Function(0x110, "betainv", 0xFF);
				 BINOMDIST = new Function(0x111, "binomdist", 4);
				 CHIDIST = new Function(0x112, "chidist", 2);
				 CHIINV = new Function(0x113, "chiinv", 2);
				 COMBIN = new Function(0x114, "combin", 2);
				 CONFIDENCE = new Function(0x115, "confidence", 3);
				 CRITBINOM = new Function(0x116, "critbinom", 3);
				 EVEN = new Function(0x117, "even", 1);
				 EXPONDIST = new Function(0x118, "expondist", 3);
				 FDIST = new Function(0x119, "fdist", 3);
				 FINV = new Function(0x11a, "finv", 3);
				 FISHER = new Function(0x11b, "fisher", 1);
				 FISHERINV = new Function(0x11c, "fisherinv", 1);
				 FLOOR = new Function(0x11d, "floor", 2);
				 GAMMADIST = new Function(0x11e, "gammadist", 4);
				 GAMMAINV = new Function(0x11f, "gammainv", 3);
				 CEILING = new Function(0x120, "ceiling", 2);
				 HYPGEOMDIST = new Function(0x121, "hypgeomdist", 4);
				 LOGNORMDIST = new Function(0x122, "lognormdist", 3);
				 LOGINV = new Function(0x123, "loginv", 3);
				 NEGBINOMDIST = new Function(0x124, "negbinomdist", 3);
				 NORMDIST = new Function(0x125, "normdist", 4);
				 NORMSDIST = new Function(0x126, "normsdist", 1);
				 NORMINV = new Function(0x127, "norminv", 3);
				 NORMSINV = new Function(0x128, "normsinv", 1);
				 STANDARDIZE = new Function(0x129, "standardize", 3);
				 ODD = new Function(0x12a, "odd", 1);
				 PERMUT = new Function(0x12b, "permut", 2);
				 POISSON = new Function(0x12c, "poisson", 3);
				 TDIST = new Function(0x12d, "tdist", 3);
				 WEIBULL = new Function(0x12e, "weibull", 4);
				 SUMXMY2 = new Function(303, "sumxmy2", 0xff);
				 SUMX2MY2 = new Function(304, "sumx2my2", 0xff);
				 SUMX2PY2 = new Function(305, "sumx2py2", 0xff);
				 CHITEST = new Function(0x132, "chitest", 0xff);
				 CORREL = new Function(0x133, "correl", 0xff);
				 COVAR = new Function(0x134, "covar", 0xff);
				 FORECAST = new Function(0x135, "forecast", 0xff);
				 FTEST = new Function(0x136, "ftest", 0xff);
				 INTERCEPT = new Function(0x137, "intercept", 0xff);
				 PEARSON = new Function(0x138, "pearson", 0xff);
				 RSQ = new Function(0x139, "rsq", 0xff);
				 STEYX = new Function(0x13a, "steyx", 0xff);
				 SLOPE = new Function(0x13b, "slope", 2);
				 TTEST = new Function(0x13c, "ttest", 0xff);
				 PROB = new Function(0x13d, "prob", 0xff);
				 DEVSQ = new Function(0x13e, "devsq", 0xff);
				 GEOMEAN = new Function(0x13f, "geomean", 0xff);
				 HARMEAN = new Function(0x140, "harmean", 0xff);
				 SUMSQ = new Function(0x141, "sumsq", 0xff);
				 KURT = new Function(0x142, "kurt", 0xff);
				 SKEW = new Function(0x143, "skew", 0xff);
				 ZTEST = new Function(0x144, "ztest", 0xff);
				 LARGE = new Function(0x145, "large", 0xff);
				 SMALL = new Function(0x146, "small", 0xff);
				 QUARTILE = new Function(0x147, "quartile", 0xff);
				 PERCENTILE = new Function(0x148, "percentile", 0xff);
				 PERCENTRANK = new Function(0x149, "percentrank", 0xff);
				 MODE = new Function(0x14a, "mode", 0xff);
				 TRIMMEAN = new Function(0x14b, "trimmean", 0xff);
				 TINV = new Function(0x14c, "tinv", 2);
				 CONCATENATE = new Function(0x150, "concatenate", 0xff);
				 POWER = new Function(0x151, "power", 2);
				 RADIANS = new Function(0x156, "radians", 1);
				 DEGREES = new Function(0x157, "degrees", 1);
				 SUBTOTAL = new Function(0x158, "subtotal", 0xff);
				 SUMIF = new Function(0x159, "sumif", 0xff);
				 COUNTIF = new Function(0x15a, "countif", 2);
				 COUNTBLANK = new Function(0x15b, "countblank", 0xff);
				 HYPERLINK = new Function(0x167, "hyperlink", 2);
				 AVERAGEA = new Function(0x169, "averagea", 0xff);
				 MAXA = new Function(0x16a, "maxa", 0xff);
				 MINA = new Function(0x16b, "mina", 0xff);
				 STDEVPA = new Function(0x16c, "stdevpa", 0xff);
				 VARPA = new Function(0x16d, "varpa", 0xff);
				 STDEVA = new Function(0x16e, "stdeva", 0xff);
				 VARA = new Function(0x16f, "vara", 0xff);

		// If token.  This is not an excel assigned number, but one made up
		// in order that the if command may be recognized
				 IF = new Function(0xfffe, "if", 0xff);
		
		// Unknown token
				 UNKNOWN = new Function(0xffff, "", 0);

		}
	}
}