sscomments.html

来自「永中OFFICE二次开发帮助文档」· HTML 代码 · 共 500 行 · 第 1/2 页

public <A HREF="../../../../application/workbooks/workbook/style/comment/Comment.html" title="application.workbooks.workbook.style.comment 中的类">Comment</A> <B>getComment</B>(int&nbsp;row,
                          int&nbsp;column)</PRE>
<DL>
<DD>获取单元格内的批注。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格行号<DD><CODE>column</CODE> - 单元格列号
<DT><B>返回：</B><DD>批注
 <p>
 <b>例子：</b>
 <pre>
 //得到第三行第二列的单元格的批注
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Comment comment = sheet.getComments().getComment(3, 2);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="getCount()"><!-- --></A><H3>
getCount</H3>
<PRE>
public int <B>getCount</B>()</PRE>
<DL>
<DD>获得批注的个数。
<P>
<DD><DL>

<DT><B>返回：</B><DD>批注的个数
 <p>
 <b>例子：</b>
 <pre>
 //得到批注的个数
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 int size = sheet.getComments().getCount();
 System.out.println(size);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasComment(int, int)"><!-- --></A><H3>
hasComment</H3>
<PRE>
public boolean <B>hasComment</B>(int&nbsp;row,
                          int&nbsp;column)</PRE>
<DL>
<DD>是否有批注。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格行号<DD><CODE>column</CODE> - 单元格列号
<DT><B>返回：</B><DD>TRUE表示有批注，FALSE表示无批注
 <p>
 <b>例子：</b>
 <pre>
 //判断第三行第三列单元格中是否有批注
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 boolean hasComment = sheet.getComments().hasComment(3,3);
 System.out.println(hasComment);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="insertComment(int, int)"><!-- --></A><H3>
insertComment</H3>
<PRE>
public <A HREF="../../../../application/workbooks/workbook/style/comment/Comment.html" title="application.workbooks.workbook.style.comment 中的类">Comment</A> <B>insertComment</B>(int&nbsp;row,
                             int&nbsp;column)</PRE>
<DL>
<DD>在指定的单元格中插入批注。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格行号<DD><CODE>column</CODE> - 单元格列号
<DT><B>返回：</B><DD>批注
 <p>
 <b>例子：</b>
 <pre>
 //在单元格第三行第三列单元格中插入批注,批注内容为"aaaaa"
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 SsComments comments = sheet.getComments();
 Comment comment = comments.insertComment(3,3);
 comment.setText("aaaaa");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="removeAllComments()"><!-- --></A><H3>
removeAllComments</H3>
<PRE>
public void <B>removeAllComments</B>()</PRE>
<DL>
<DD>删除所有批注。
 <p>
 <b>例子：</b>
 <pre>
 //删除当前工作表中所有的批注
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 sheet.getComments().removeAllComments();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="removeComment(int, int)"><!-- --></A><H3>
removeComment</H3>
<PRE>
public void <B>removeComment</B>(int&nbsp;row,
                          int&nbsp;column)</PRE>
<DL>
<DD>在指定的单元格中移除批注。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格行号<DD><CODE>column</CODE> - 单元格列号
 <p>
 <b>例子：</b>
 <pre>
 //移除第三行第三列单元格中的批注
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 sheet.getComments().removeComment(3,3);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="setCommentVisible(int, int, boolean)"><!-- --></A><H3>
setCommentVisible</H3>
<PRE>
public void <B>setCommentVisible</B>(int&nbsp;row,
                              int&nbsp;column,
                              boolean&nbsp;visible)</PRE>
<DL>
<DD>设置某个批注是否显示。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 行号<DD><CODE>column</CODE> - 列号<DD><CODE>visible</CODE> - 可见性
 <p>
 <b>例子：</b>
 <pre>
 //将第三行第三列单元格中的批注设置为显示
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 sheet.getComments().setCommentVisible(3,3,true);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="showAllComments(boolean)"><!-- --></A><H3>
showAllComments</H3>
<PRE>
public void <B>showAllComments</B>(boolean&nbsp;show)</PRE>
<DL>
<DD>显示所有批注。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>show</CODE> - 布尔型值，如为true，显示批注；否则，不显示批注
 <p>
 <b>例子：</b>
 <pre>
 //将当前工作表中的所有的批注都显示出来
 Worksheet sheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 sheet.getComments().showAllComments(true);
 </pre></DL>
</DD>
</DL>
<!-- ========= END OF CLASS DATA ========= -->
<HR>


<!-- ======= START OF BOTTOM NAVBAR ====== -->
<A NAME="navbar_bottom"><!-- --></A>
<A HREF="#skip-navbar_bottom" title="跳过导航链接"></A>
<TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY="">
<TR>
<TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1">
<A NAME="navbar_bottom_firstrow"><!-- --></A>
<TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY="">
  <TR ALIGN="center" VALIGN="top">
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>概述</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>软件包</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> &nbsp;<FONT CLASS="NavBarFont1Rev"><B>类</B></FONT>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>树</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>索引</B></FONT></A>&nbsp;</TD>
  <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1">    <A HREF="../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>帮助</B></FONT></A>&nbsp;</TD>
  </TR>
</TABLE>
</TD>
<TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM>
</EM>
</TD>
</TR>

<TR>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
&nbsp;上一个类&nbsp;
&nbsp;<A HREF="../../../../application/workbooks/workbook/worksheets/SsHyperlinks.html" title="application.workbooks.workbook.worksheets 中的类"><B>下一个类</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html?application/workbooks/workbook/worksheets/SsComments.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="SsComments.html" target="_top"><B>无框架</B></A>  &nbsp;
&nbsp;<SCRIPT type="text/javascript">
  <!--
  if(window==top) {
    document.writeln('<A HREF="../../../../allclasses-noframe.html"><B>所有类</B></A>');
  }
  //-->
</SCRIPT>
<NOSCRIPT>
  <A HREF="../../../../allclasses-noframe.html"><B>所有类</B></A>
</NOSCRIPT>


</FONT></TD>
</TR>
<TR>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
  摘要：&nbsp;嵌套&nbsp;|&nbsp;字段&nbsp;|&nbsp;构造方法&nbsp;|&nbsp;<A HREF="#method_summary">方法</A></FONT></TD>
<TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2">
详细信息：&nbsp;字段&nbsp;|&nbsp;构造方法&nbsp;|&nbsp;<A HREF="#method_detail">方法</A></FONT></TD>
</TR>
</TABLE>
<A NAME="skip-navbar_bottom"></A>
<!-- ======== END OF BOTTOM NAVBAR ======= -->

<HR>
版权所有 2001-2006 无锡永中科技有限公司
</BODY>
</HTML>