📄 worksheet.html
字号:
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, int[][], boolean)">setCellValue</A></B>(int row,
int column,
int[][] values,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, int[], boolean)">setCellValue</A></B>(int row,
int column,
int[] value,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, long)">setCellValue</A></B>(int row,
int column,
long value)</CODE>
<BR>
给行号和列号指定的单元格设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, long[][], boolean)">setCellValue</A></B>(int row,
int column,
long[][] values,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, long[], boolean)">setCellValue</A></B>(int row,
int column,
long[] value,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, java.lang.String)">setCellValue</A></B>(int row,
int column,
java.lang.String value)</CODE>
<BR>
给行号和列号指定的单元格设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, java.lang.String[][], boolean)">setCellValue</A></B>(int row,
int column,
java.lang.String[][] values,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setCellValue(int, int, java.lang.String[], boolean)">setCellValue</A></B>(int row,
int column,
java.lang.String[] values,
boolean horizontal)</CODE>
<BR>
给以指定的行号和列号为起点的单元格区域设置内容。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setName(java.lang.String)">setName</A></B>(java.lang.String name)</CODE>
<BR>
设置工作表的名字。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setStandardColumnWidth(double)">setStandardColumnWidth</A></B>(double width)</CODE>
<BR>
设置标准列宽(默认度量单位:磅)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setStandardRowHeight(double)">setStandardRowHeight</A></B>(double height)</CODE>
<BR>
设置标准行高(默认度量单位:磅)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setTabBarBackground(java.awt.Color)">setTabBarBackground</A></B>(java.awt.Color color)</CODE>
<BR>
设置工作表标签的背景色。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setTabBarForeground(java.awt.Color)">setTabBarForeground</A></B>(java.awt.Color color)</CODE>
<BR>
设置工作表标签栏上工作表标签的前景色。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setVisible(boolean)">setVisible</A></B>(boolean visible)</CODE>
<BR>
隐藏/显示活动工作表。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#setZoom(int)">setZoom</A></B>(int zoom)</CODE>
<BR>
设置当前工作表的显示比例。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#showAllData()">showAllData</A></B>()</CODE>
<BR>
显示所有被筛选后隐藏的行。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#showDependentArrows(int, int)">showDependentArrows</A></B>(int row,
int column)</CODE>
<BR>
追踪从属单元格(内容是数值)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#showPrecedentArrows(int, int)">showPrecedentArrows</A></B>(int row,
int column)</CODE>
<BR>
追踪引用单元格(此单元格为公式)，绘制出一个从为活动单元格（公式）提供数据的单元格指向活动单元格的蓝色箭头。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#showTraceError(int, int)">showTraceError</A></B>(int row,
int column)</CODE>
<BR>
显示错误追踪箭头(单元格的公式结果是错误值)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#translateToSimple()">translateToSimple</A></B>()</CODE>
<BR>
将当前工作表内的文字编码方式转换为简体编码方式。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#translateToTraditional()">translateToTraditional</A></B>()</CODE>
<BR>
将当前工作表内的文字编码方式转换为繁体编码方式。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> boolean</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#unprotect(java.lang.String)">unprotect</A></B>(java.lang.String password)</CODE>
<BR>
对工作表解除保护。</TD>
</TR>
</TABLE>
<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>从类 java.lang.Object 继承的方法</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
<P>
<!-- ============ METHOD DETAIL ========== -->
<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>方法详细信息</B></FONT></TH>
</TR>
</TABLE>
<A NAME="activate()"><!-- --></A><H3>
activate</H3>
<PRE>
public void <B>activate</B>()</PRE>
<DL>
<DD>激活工作表。 <p> <b>例子: </b> <pre> //激活工作表1 Worksheets sheets = Application.getWorkbooks().getActiveWorkbook().getWorksheets(); Worksheet sheet = sheets.getWorksheet(1); sheet.activate(); </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="addFloatingChart(int, int, java.lang.String, boolean)"><!-- --></A><H3>
addFloatingChart</H3>
<PRE>
public <A HREF="../../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>addFloatingChart</B>(int chartType,
int subType,
java.lang.String rangeAddress,
boolean isRow)</PRE>
<DL>
<DD>添加浮动图表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>chartType</CODE> - 图表主类型<DD><CODE>subType</CODE> - 图表次类型<DD><CODE>rangeAddress</CODE> - 图表数据源<DD><CODE>isRow</CODE> - TRUE 表示按行，FALSE 表示按列
<DT><B>返回：</B><DD>浮动图表 <p> <b >例子：</b> <pre>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -