📄 worksheetfunction.html
字号:
返回某一引用范围中的左上角单元格的格式、位置或内容等信息。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#character(int)">character</A></B>(int number)</CODE>
<BR>
根据指定数字返回对应的字符。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#chidist(double, double)">chidist</A></B>(double x,
double degrees_freedom)</CODE>
<BR>
返回 γ2 分布的单尾概率。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#chiinv(double, double)">chiinv</A></B>(double probability,
double degrees_freedom)</CODE>
<BR>
返回 γ2 分布单尾概率的反函数值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#chitest(application.workbooks.workbook.worksheets.worksheet.Range, application.workbooks.workbook.worksheets.worksheet.Range)">chitest</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> actual_range,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> expected_range)</CODE>
<BR>
返回独立性检验值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#choose(int, java.lang.String[])">choose</A></B>(int index_num,
java.lang.String[] values)</CODE>
<BR>
根据索引号，返回已输入的数值中任一数值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#clean(java.lang.String)">clean</A></B>(java.lang.String string)</CODE>
<BR>
删除文本中的所有不可打印字符。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#code(java.lang.String)">code</A></B>(java.lang.String text)</CODE>
<BR>
计算文本串中第一个字符的数字代码。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#column(application.workbooks.workbook.worksheets.worksheet.Range)">column</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> reference)</CODE>
<BR>
返回引用的列标。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#columns(application.workbooks.workbook.worksheets.worksheet.Range)">columns</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> reference)</CODE>
<BR>
返回引用或数组的列数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#combin(double, double)">combin</A></B>(double number,
double number_chosen)</CODE>
<BR>
求从给定数目的对象集合中提取若干对象的组合数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#complex(double, double)">complex</A></B>(double real_num,
double i_number)</CODE>
<BR>
将实系数和虚系数转换为 x+yi 形式的复数形式。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#concatenate(java.lang.String, java.lang.String)">concatenate</A></B>(java.lang.String text1,
java.lang.String text2)</CODE>
<BR>
将数个字符串合并成一个字符串。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#confidence(double, double, double)">confidence</A></B>(double alpha,
double standard_dev,
double size)</CODE>
<BR>
总体平均值的置信区间。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#convert(double, java.lang.String, java.lang.String)">convert</A></B>(double number,
java.lang.String from_unit,
java.lang.String to_unit)</CODE>
<BR>
将数值从一个度量系统转换到另一个度量系统。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#correl(application.workbooks.workbook.worksheets.worksheet.Range, application.workbooks.workbook.worksheets.worksheet.Range)">correl</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range1,
<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range2)</CODE>
<BR>
单元格区域 array1 和 array2 之间的相关系数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#cos(double)">cos</A></B>(double number)</CODE>
<BR>
返回指定角度的余弦值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#cosh(double)">cosh</A></B>(double number)</CODE>
<BR>
求双曲余弦值。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#count(application.workbooks.workbook.worksheets.worksheet.Range)">count</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
包含数字以及包含参数列表中的数字的单元格的个数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#counta(application.workbooks.workbook.worksheets.worksheet.Range)">counta</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
包含数字以及包含参数列表中的数字的单元格的个数， 参数值可以是任何类型，它们可以包括空字符 ("")，但不包括空白单元格。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#countBlank(application.workbooks.workbook.worksheets.worksheet.Range)">countBlank</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> range)</CODE>
<BR>
计算指定单元格区域中空白单元格的个数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static long</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#countif(application.workbooks.workbook.worksheets.worksheet.Range, double)">countif</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> array,
double criteria)</CODE>
<BR>
求计算区域中满足给定条件的单元格的个数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static long</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#countif(application.workbooks.workbook.worksheets.worksheet.Range, java.lang.String)">countif</A></B>(<A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A> array,
java.lang.String criteria)</CODE>
<BR>
求计算区域中满足给定条件的单元格的个数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#coupdaybs(java.lang.String, java.lang.String, double, double)">coupdaybs</A></B>(java.lang.String settlement,
java.lang.String maturity,
double frequency,
double basis)</CODE>
<BR>
返回每个会计期间资产的按比例线性折旧率。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE>static double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/WorksheetFunction.html#coupdays(java.lang.String, java.lang.String, double, double)">coupdays</A></B>(java.lang.String settlement,
java.lang.String maturity,
double frequency,
double basis)</CODE>
<BR>
返回成交日所在的付息期的天数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -