📄 cell.html
字号:
<BR>
单元格中是否存在公式。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> <A HREF="../../../../../application/workbooks/workbook/style/comment/Comment.html" title="application.workbooks.workbook.style.comment 中的类">Comment</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#insertComment()">insertComment</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/style/comment/Comment.html" title="application.workbooks.workbook.style.comment 中的类">Comment</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#insertComment(java.lang.String)">insertComment</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> java.awt.Component</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#insertComponent(int)">insertComponent</A></B>(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/Cell.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/Cell.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> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#insertSymbol(java.lang.String)">insertSymbol</A></B>(java.lang.String symbol)</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/Cell.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> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#linkRange(java.lang.String)">linkRange</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/Cell.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Cell</A></CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#offset(int, int)">offset</A></B>(int rows,
int columns)</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/Cell.html#paste()">paste</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/Cell.html#select()">select</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/Cell.html#setBorderAttribute(application.workbooks.workbook.style.border.BorderAttribute)">setBorderAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/border/BorderAttribute.html" title="application.workbooks.workbook.style.border 中的类">BorderAttribute</A> ba)</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/Cell.html#setFillAttribute(application.workbooks.workbook.style.fill.FillAttribute)">setFillAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A> fa)</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/Cell.html#setFontAttribute(application.workbooks.workbook.style.font.FontAttribute)">setFontAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A> ca)</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/Cell.html#setFormatCellAttribute(application.workbooks.workbook.worksheets.FormatCellAttribute)">setFormatCellAttribute</A></B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/FormatCellAttribute.html" title="application.workbooks.workbook.worksheets 中的类">FormatCellAttribute</A> attr)</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/Cell.html#setText(java.lang.String)">setText</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> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html#setValue(boolean)">setValue</A></B>(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/Cell.html#setValue(double)">setValue</A></B>(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/Cell.html#setValue(long)">setValue</A></B>(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/Cell.html#setValue(java.lang.String)">setValue</A></B>(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/Cell.html#showComment(boolean)">showComment</A></B>(boolean show)</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="autoFit()"><!-- --></A><H3>
autoFit</H3>
<PRE>
public void <B>autoFit</B>()</PRE>
<DL>
<DD>将列宽和行高设置为最佳。<p> <b>例子：</b> <pre> //将当前单元格的列宽和行高设置为最佳 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); Cell cell = worksheet.getActiveCell(); cell.autoFit(); </pre>
<P>
<DD><DL>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>
<A NAME="clear()"><!-- --></A><H3>
clear</H3>
<PRE>
public void <B>clear</B>()</PRE>
<DL>
<DD>清除单元格中的全部信息，包括格式、内容、注释等。 <p> <b>例子：</b> <pre> //清除当前单元格中的全部信息 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); worksheet.getActiveCell().clear(); </pre>
<P>
<DD><DL>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>
<A NAME="clearComments()"><!-- --></A><H3>
clearComments</H3>
<PRE>
public void <B>clearComments</B>()</PRE>
<DL>
<DD>清除单元格中的注释。 <p> <b>例子：</b> <pre> //清除当前单元格中的注释 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); worksheet.getCell("C4").clearComments(); </pre>
<P>
<DD><DL>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>
<A NAME="clearContents()"><!-- --></A><H3>
clearContents</H3>
<PRE>
public void <B>clearContents</B>()</PRE>
<DL>
<DD>清除单元格中的内容。 <p> <b>例子：</b> <pre> //清除当前单元格中的内容 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); worksheet.getActiveCell().clearContents(); </pre>
<P>
<DD><DL>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>
<A NAME="clearFormats()"><!-- --></A><H3>
clearFormats</H3>
<PRE>
public void <B>clearFormats</B>()</PRE>
<DL>
<DD>清除单元格中的格式。 <p> <b>例子：</b> <pre> //清除当前单元格中的格式 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); worksheet.getActiveCell().clearFormats(); </pre>
<P>
<DD><DL>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>
<A NAME="copy()"><!-- --></A><H3>
copy</H3>
<PRE>
public void <B>copy</B>()</PRE>
<DL>
<DD>复制。 <p> <b>例子：</b> <PRE> //复制单元格"C3" Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet(); worksheet.setCellValue(3,3,"abc"); Cell cell = worksheet.getCell(3,3); cell.copy(); </PRE>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>
<A NAME="cut()"><!-- --></A><H3>
cut</H3>
<PRE>
public void <B>cut</B>()</PRE>
<DL>
<DD>剪切。 <p> <b>例子：</b> <PRE> //剪切单元格"C3" Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook() .getWorksheets().getActiveWorksheet();⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -