📄 worksheet.html
字号:
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#hasAutoFilter()">hasAutoFilter</A></B>()</CODE>
<BR>
得到当前工作表中是否有自动筛选区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.awt.Component</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#insertCellComponent(int, int, int)">insertCellComponent</A></B>(int row,
int col,
int compType)</CODE>
<BR>
在单元格中插入控件。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.awt.Component</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#insertCellComponent(java.lang.String, int)">insertCellComponent</A></B>(java.lang.String cellAddress,
int compType)</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#insertEntireColumns(int, int)">insertEntireColumns</A></B>(int startCol,
int endCol)</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#insertEntireRows(int, int)">insertEntireRows</A></B>(int startRow,
int endRow)</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#insertMultiMedia(java.lang.String)">insertMultiMedia</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#insertPicture(java.lang.String)">insertPicture</A></B>(java.lang.String pictureName)</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#isActive()">isActive</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#isProtected()">isProtected</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#isVisible()">isVisible</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#isWorksheetChart()">isWorksheetChart</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#protect(java.lang.String, application.workbooks.workbook.worksheets.ProtectProperties)">protect</A></B>(java.lang.String password,
<A HREF="../../../../application/workbooks/workbook/worksheets/ProtectProperties.html" title="application.workbooks.workbook.worksheets 中的类">ProtectProperties</A> protectProperties)</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#refresh()">refresh</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#removeDependentArrows(int, int)">removeDependentArrows</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#removeHPageBreak(int)">removeHPageBreak</A></B>(int row)</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#removeHVPageBreak(int, int)">removeHVPageBreak</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#removePrecedentArrows(int, int)">removePrecedentArrows</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#removeVPageBreak(int)">removeVPageBreak</A></B>(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#removeWorksheetListener(application.event.WorksheetListener)">removeWorksheetListener</A></B>(<A HREF="../../../../application/event/WorksheetListener.html" title="application.event 中的接口">WorksheetListener</A> sl)</CODE>
<BR>
向Worksheet注册监听器</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#resetTabBarBackground()">resetTabBarBackground</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#resetTabBarForeground()">resetTabBarForeground</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#saveAsDBF(java.lang.String)">saveAsDBF</A></B>(java.lang.String filename)</CODE>
<BR>
另存为DBF文件。</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#select(int, int, int, int)">select</A></B>(int startRow,
int startColumn,
int endRow,
int endColumn)</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#select(java.lang.String)">select</A></B>(java.lang.String address)</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#selectAll()">selectAll</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#setBackground(java.lang.String)">setBackground</A></B>(java.lang.String pictureName)</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#setCellText(int, int, java.lang.String)">setCellText</A></B>(int row,
int column,
java.lang.String text)</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, boolean)">setCellValue</A></B>(int row,
int column,
boolean 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, double)">setCellValue</A></B>(int row,
int column,
double 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, double[][], boolean)">setCellValue</A></B>(int row,
int column,
double[][] 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, double[], boolean)">setCellValue</A></B>(int row,
int column,
double[] value,
boolean horizontal)</CODE>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -