📄 worksheet.html
字号:
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Cell</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getCell(java.lang.String)">getCell</A></B>(java.lang.String cellAddress)</CODE>
<BR>
根据单元格地址获取指定单元格。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getCellString(int, int)">getCellString</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> java.lang.Object</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getCellValue(int, int)">getCellValue</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> <A HREF="../../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A>[]</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getCharts()">getCharts</A></B>()</CODE>
<BR>
取得该工作表上的所有图表。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Columns.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Columns</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getColumns(int, int)">getColumns</A></B>(int startColumn,
int endColumn)</CODE>
<BR>
根据起始列号和终止列号获取指定列对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Columns.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Columns</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getColumns(java.lang.String)">getColumns</A></B>(java.lang.String columnAddress)</CODE>
<BR>
根据列地址获取列对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/SsComments.html" title="application.workbooks.workbook.worksheets 中的类">SsComments</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getComments()">getComments</A></B>()</CODE>
<BR>
获得注释管理器。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> application.workbooks.workbook.worksheets.FilterProperties</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getFilterProperties()">getFilterProperties</A></B>()</CODE>
<BR>
取得自定义筛选属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/SsHyperlinks.html" title="application.workbooks.workbook.worksheets 中的类">SsHyperlinks</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getHyperlinks()">getHyperlinks</A></B>()</CODE>
<BR>
获得超链接管理器。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getMaxColumn()">getMaxColumn</A></B>()</CODE>
<BR>
取得最大列数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getMaxDataColumn()">getMaxDataColumn</A></B>()</CODE>
<BR>
得到当前工作表内拥有数据区域的最大列号。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getMaxDataRow()">getMaxDataRow</A></B>()</CODE>
<BR>
得到当前工作表内拥有数据区域的最大行号。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getMaxRow()">getMaxRow</A></B>()</CODE>
<BR>
获取最大行数。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> java.lang.String</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getName()">getName</A></B>()</CODE>
<BR>
获得当前工作表的名称。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/SsPageSetup.html" title="application.workbooks.workbook.worksheets 中的类">SsPageSetup</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getPageSetup()">getPageSetup</A></B>()</CODE>
<BR>
获得工作表的页面设置。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/print/Print.html" title="application.workbooks.workbook.print 中的类">Print</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getPrint()">getPrint</A></B>()</CODE>
<BR>
获得打印机。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> application.workbooks.workbook.print.PrintPreview</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getPrintPreview()">getPrintPreview</A></B>()</CODE>
<BR>
得到打印预览。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/ProtectProperties.html" title="application.workbooks.workbook.worksheets 中的类">ProtectProperties</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getProtectProperties()">getProtectProperties</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#getProtectState(int)">getProtectState</A></B>(int type)</CODE>
<BR>
得到某个功能的保护状态。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getRange()">getRange</A></B>()</CODE>
<BR>
取得工作表对应的Range对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getRange(int, int, int, int)">getRange</A></B>(int startRow,
int startCol,
int endRow,
int endCol)</CODE>
<BR>
获得单元格区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getRange(java.lang.String)">getRange</A></B>(java.lang.String rangeAddress)</CODE>
<BR>
获得单元格区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Rows</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getRows(int, int)">getRows</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> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Rows.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Rows</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getRows(java.lang.String)">getRows</A></B>(java.lang.String rowsAddress)</CODE>
<BR>
根据行地址获取行对象。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/Scenarios.html" title="application.workbooks.workbook.worksheets 中的类">Scenarios</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getScenarios()">getScenarios</A></B>()</CODE>
<BR>
获得方案管理器。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/SsShapes.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">SsShapes</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getShapes()">getShapes</A></B>()</CODE>
<BR>
获取工作表的自选图形管理器。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getStandardColumnWidth()">getStandardColumnWidth</A></B>()</CODE>
<BR>
获得标准列宽(默认度量单位:磅)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> double</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getStandardRowHeight()">getStandardRowHeight</A></B>()</CODE>
<BR>
获得标准行高(默认度量单位:磅)。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/Workbook.html" title="application.workbooks 中的类">Workbook</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getWorkbook()">getWorkbook</A></B>()</CODE>
<BR>
返回工作表所属的工作薄。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> int</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#getZoom()">getZoom</A></B>()</CODE>
<BR>
返回当前工作表的显示比例。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#gotoRange(java.lang.String)">gotoRange</A></B>(java.lang.String refer)</CODE>
<BR>
定位到指定的单元格区域。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../application/workbooks/workbook/worksheets/worksheet/Range.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Range</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/worksheets/Worksheet.html#gotoSpecial(int, int)">gotoSpecial</A></B>(int type,
int detail)</CODE>
<BR>
特殊定位。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> boolean</CODE></FONT></TD>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -