functioneval.java
来自「EXCEL read and write」· Java 代码 · 共 432 行 · 第 1/2 页
JAVA
432 行
retval[141] = new Timevalue(); // TIMEVALUE retval[142] = new Sln(); // SLN retval[143] = new Syd(); // SYD retval[144] = new Ddb(); // DDB retval[145] = new NotImplementedFunction(); // GETDEF retval[146] = new Reftext(); // REFTEXT retval[147] = new Textref(); // TEXTREF retval[ID.INDIRECT] = null; // Indirect.evaluate has different signature retval[149] = new NotImplementedFunction(); // REGISTER retval[150] = new Call(); // CALL retval[151] = new NotImplementedFunction(); // ADDBAR retval[152] = new NotImplementedFunction(); // ADDMENU retval[153] = new NotImplementedFunction(); // ADDCOMMAND retval[154] = new NotImplementedFunction(); // ENABLECOMMAND retval[155] = new NotImplementedFunction(); // CHECKCOMMAND retval[156] = new NotImplementedFunction(); // RENAMECOMMAND retval[157] = new NotImplementedFunction(); // SHOWBAR retval[158] = new NotImplementedFunction(); // DELETEMENU retval[159] = new NotImplementedFunction(); // DELETECOMMAND retval[160] = new NotImplementedFunction(); // GETCHARTITEM retval[161] = new NotImplementedFunction(); // DIALOGBOX retval[162] = new Clean(); // CLEAN retval[163] = new Mdeterm(); // MDETERM retval[164] = new Minverse(); // MINVERSE retval[165] = new Mmult(); // MMULT retval[166] = new Files(); // FILES retval[167] = new Ipmt(); // IPMT retval[168] = new Ppmt(); // PPMT retval[169] = new Counta(); // COUNTA retval[170] = new NotImplementedFunction(); // CANCELKEY retval[175] = new Initiate(); // INITIATE retval[176] = new Request(); // REQUEST retval[177] = new NotImplementedFunction(); // POKE retval[178] = new NotImplementedFunction(); // EXECUTE retval[179] = new NotImplementedFunction(); // TERMINATE retval[180] = new NotImplementedFunction(); // RESTART retval[181] = new Help(); // HELP retval[182] = new NotImplementedFunction(); // GETBAR retval[183] = AggregateFunction.PRODUCT; retval[184] = NumericFunction.FACT; retval[185] = new NotImplementedFunction(); // GETCELL retval[186] = new NotImplementedFunction(); // GETWORKSPACE retval[187] = new NotImplementedFunction(); // GETWINDOW retval[188] = new NotImplementedFunction(); // GETDOCUMENT retval[189] = new Dproduct(); // DPRODUCT retval[190] = new Isnontext(); // ISNONTEXT retval[191] = new NotImplementedFunction(); // GETNOTE retval[192] = new Note(); // NOTE retval[193] = new Stdevp(); // STDEVP retval[194] = new Varp(); // VARP retval[195] = new Dstdevp(); // DSTDEVP retval[196] = new Dvarp(); // DVARP retval[197] = new Trunc(); // TRUNC retval[198] = new Islogical(); // ISLOGICAL retval[199] = new Dcounta(); // DCOUNTA retval[200] = new NotImplementedFunction(); // DELETEBAR retval[201] = new NotImplementedFunction(); // UNREGISTER retval[204] = new Usdollar(); // USDOLLAR retval[205] = new Findb(); // FINDB retval[206] = new Searchb(); // SEARCHB retval[207] = new Replaceb(); // REPLACEB retval[208] = new Leftb(); // LEFTB retval[209] = new Rightb(); // RIGHTB retval[210] = new Midb(); // MIDB retval[211] = new Lenb(); // LENB retval[212] = NumericFunction.ROUNDUP; retval[213] = NumericFunction.ROUNDDOWN; retval[214] = new Asc(); // ASC retval[215] = new Dbcs(); // DBCS retval[216] = new Rank(); // RANK retval[219] = new Address(); // ADDRESS retval[220] = new Days360(); // DAYS360 retval[221] = new Today(); // TODAY retval[222] = new Vdb(); // VDB retval[227] = AggregateFunction.MEDIAN; retval[228] = new Sumproduct(); // SUMPRODUCT retval[229] = NumericFunction.SINH; retval[230] = NumericFunction.COSH; retval[231] = NumericFunction.TANH; retval[232] = NumericFunction.ASINH; retval[233] = NumericFunction.ACOSH; retval[234] = NumericFunction.ATANH; retval[235] = new Dget(); // DGET retval[236] = new NotImplementedFunction(); // CREATEOBJECT retval[237] = new Volatile(); // VOLATILE retval[238] = new Lasterror(); // LASTERROR retval[239] = new NotImplementedFunction(); // CUSTOMUNDO retval[240] = new Customrepeat(); // CUSTOMREPEAT retval[241] = new Formulaconvert(); // FORMULACONVERT retval[242] = new NotImplementedFunction(); // GETLINKINFO retval[243] = new NotImplementedFunction(); // TEXTBOX retval[244] = new Info(); // INFO retval[245] = new Group(); // GROUP retval[246] = new NotImplementedFunction(); // GETOBJECT retval[247] = new Db(); // DB retval[248] = new NotImplementedFunction(); // PAUSE retval[250] = new NotImplementedFunction(); // RESUME retval[252] = new Frequency(); // FREQUENCY retval[253] = new NotImplementedFunction(); // ADDTOOLBAR retval[254] = new NotImplementedFunction(); // DELETETOOLBAR retval[ID.EXTERNAL_FUNC] = null; // ExternalFunction is a FreeREfFunction retval[256] = new NotImplementedFunction(); // RESETTOOLBAR retval[257] = new Evaluate(); // EVALUATE retval[258] = new NotImplementedFunction(); // GETTOOLBAR retval[259] = new NotImplementedFunction(); // GETTOOL retval[260] = new NotImplementedFunction(); // SPELLINGCHECK retval[261] = new Errortype(); // ERRORTYPE retval[262] = new NotImplementedFunction(); // APPTITLE retval[263] = new NotImplementedFunction(); // WINDOWTITLE retval[264] = new NotImplementedFunction(); // SAVETOOLBAR retval[265] = new NotImplementedFunction(); // ENABLETOOL retval[266] = new NotImplementedFunction(); // PRESSTOOL retval[267] = new NotImplementedFunction(); // REGISTERID retval[268] = new NotImplementedFunction(); // GETWORKBOOK retval[269] = AggregateFunction.AVEDEV; retval[270] = new Betadist(); // BETADIST retval[271] = new Gammaln(); // GAMMALN retval[272] = new Betainv(); // BETAINV retval[273] = new Binomdist(); // BINOMDIST retval[274] = new Chidist(); // CHIDIST retval[275] = new Chiinv(); // CHIINV retval[276] = NumericFunction.COMBIN; retval[277] = new Confidence(); // CONFIDENCE retval[278] = new Critbinom(); // CRITBINOM retval[279] = new Even(); // EVEN retval[280] = new Expondist(); // EXPONDIST retval[281] = new Fdist(); // FDIST retval[282] = new Finv(); // FINV retval[283] = new Fisher(); // FISHER retval[284] = new Fisherinv(); // FISHERINV retval[285] = NumericFunction.FLOOR; retval[286] = new Gammadist(); // GAMMADIST retval[287] = new Gammainv(); // GAMMAINV retval[288] = NumericFunction.CEILING; retval[289] = new Hypgeomdist(); // HYPGEOMDIST retval[290] = new Lognormdist(); // LOGNORMDIST retval[291] = new Loginv(); // LOGINV retval[292] = new Negbinomdist(); // NEGBINOMDIST retval[293] = new Normdist(); // NORMDIST retval[294] = new Normsdist(); // NORMSDIST retval[295] = new Norminv(); // NORMINV retval[296] = new Normsinv(); // NORMSINV retval[297] = new Standardize(); // STANDARDIZE retval[298] = new Odd(); // ODD retval[299] = new Permut(); // PERMUT retval[300] = new Poisson(); // POISSON retval[301] = new Tdist(); // TDIST retval[302] = new Weibull(); // WEIBULL retval[303] = new Sumxmy2(); // SUMXMY2 retval[304] = new Sumx2my2(); // SUMX2MY2 retval[305] = new Sumx2py2(); // SUMX2PY2 retval[306] = new Chitest(); // CHITEST retval[307] = new Correl(); // CORREL retval[308] = new Covar(); // COVAR retval[309] = new Forecast(); // FORECAST retval[310] = new Ftest(); // FTEST retval[311] = new Intercept(); // INTERCEPT retval[312] = new Pearson(); // PEARSON retval[313] = new Rsq(); // RSQ retval[314] = new Steyx(); // STEYX retval[315] = new Slope(); // SLOPE retval[316] = new Ttest(); // TTEST retval[317] = new Prob(); // PROB retval[318] = AggregateFunction.DEVSQ; retval[319] = new Geomean(); // GEOMEAN retval[320] = new Harmean(); // HARMEAN retval[321] = AggregateFunction.SUMSQ; retval[322] = new Kurt(); // KURT retval[323] = new Skew(); // SKEW retval[324] = new Ztest(); // ZTEST retval[325] = AggregateFunction.LARGE; retval[326] = AggregateFunction.SMALL; retval[327] = new Quartile(); // QUARTILE retval[328] = new Percentile(); // PERCENTILE retval[329] = new Percentrank(); // PERCENTRANK retval[330] = new Mode(); // MODE retval[331] = new Trimmean(); // TRIMMEAN retval[332] = new Tinv(); // TINV retval[334] = new NotImplementedFunction(); // MOVIECOMMAND retval[335] = new NotImplementedFunction(); // GETMOVIE retval[336] = TextFunction.CONCATENATE; retval[337] = NumericFunction.POWER; retval[338] = new NotImplementedFunction(); // PIVOTADDDATA retval[339] = new NotImplementedFunction(); // GETPIVOTTABLE retval[340] = new NotImplementedFunction(); // GETPIVOTFIELD retval[341] = new NotImplementedFunction(); // GETPIVOTITEM retval[342] = NumericFunction.RADIANS; retval[343] = NumericFunction.DEGREES; retval[344] = new Subtotal(); // SUBTOTAL retval[345] = new Sumif(); // SUMIF retval[346] = new Countif(); // COUNTIF retval[347] = new Countblank(); // COUNTBLANK retval[348] = new NotImplementedFunction(); // SCENARIOGET retval[349] = new NotImplementedFunction(); // OPTIONSLISTSGET retval[350] = new Ispmt(); // ISPMT retval[351] = new Datedif(); // DATEDIF retval[352] = new Datestring(); // DATESTRING retval[353] = new Numberstring(); // NUMBERSTRING retval[354] = new Roman(); // ROMAN retval[355] = new NotImplementedFunction(); // OPENDIALOG retval[356] = new NotImplementedFunction(); // SAVEDIALOG retval[357] = new NotImplementedFunction(); // VIEWGET retval[358] = new NotImplementedFunction(); // GETPIVOTDATA retval[359] = new Hyperlink(); // HYPERLINK retval[360] = new NotImplementedFunction(); // PHONETIC retval[361] = new Averagea(); // AVERAGEA retval[362] = MinaMaxa.MAXA; retval[363] = MinaMaxa.MINA; retval[364] = new Stdevpa(); // STDEVPA retval[365] = new Varpa(); // VARPA retval[366] = new Stdeva(); // STDEVA retval[367] = new Vara(); // VARA return retval; }}
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?