cell.html

永中OFFICE二次开发帮助文档

getParent</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/Worksheet.html" title="application.workbooks.workbook.worksheets 中的类">Worksheet</A> <B>getParent</B>()</PRE>
<DL>
<DD>返回所属的工作表对象。
<P>
<DD><DL>

<DT><B>返回：</B><DD>工作表
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格所属的工作表对象
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getActiveCell();
 Worksheet sheet = cell.getParent();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getRow()"><!-- --></A><H3>
getRow</H3>
<PRE>
public int <B>getRow</B>()</PRE>
<DL>
<DD>获取单元格行号。
<P>
<DD><DL>

<DT><B>返回：</B><DD>行号
 <p>
 <b>例子：</b>
 <pre> 
  //获取当前单元格行号
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 int row = worksheet.getActiveCell().getRow();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getRowHeight()"><!-- --></A><H3>
getRowHeight</H3>
<PRE>
public double <B>getRowHeight</B>()</PRE>
<DL>
<DD>返回单元格的高度，单位为磅
<P>
<DD><DL>

<DT><B>返回：</B><DD>单元格的高度
 <p>
 <b>例子：</b>
 </P>
 <PRE>
  //获得单元格"C3"的高度
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 worksheet.setCellValue(3,3,"abc");
 Cell cell = worksheet.getCell(3,3);
 System.out.println("Height is " + cell.getRowHeight());
 </PRE></DL>
</DD>
</DL>
<HR>

<A NAME="getValue()"><!-- --></A><H3>
getValue</H3>
<PRE>
public java.lang.Object <B>getValue</B>()</PRE>
<DL>
<DD>获取单元格的值。
<P>
<DD><DL>

<DT><B>返回：</B><DD>单元格中储存的对象
 <p>
 <b>例子：</b>
 <pre>
  //获取当前单元格的值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Object value = worksheet.getActiveCell().getValue();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getWorksheet()"><!-- --></A><H3>
getWorksheet</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/Worksheet.html" title="application.workbooks.workbook.worksheets 中的类">Worksheet</A> <B>getWorksheet</B>()</PRE>
<DL>
<DD>返回所属的工作表对象。
<P>
<DD><DL>

<DT><B>返回：</B><DD>工作表对象
 <p>
 <b>例子：</b>
 <pre>
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getActiveCell();
 Worksheet sheet = cell.getWorksheet();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasComment()"><!-- --></A><H3>
hasComment</H3>
<PRE>
public boolean <B>hasComment</B>()</PRE>
<DL>
<DD>判断单元格是否有注释。
<P>
<DD><DL>

<DT><B>返回：</B><DD>是否有注释
 <p>
 <b>例子：</b>
 <pre>
  //判断单元格是否有注释
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 boolean hasComment = worksheet.getCell("C4").hasComment();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasFormula()"><!-- --></A><H3>
hasFormula</H3>
<PRE>
public boolean <B>hasFormula</B>()</PRE>
<DL>
<DD>单元格中是否存在公式。
<P>
<DD><DL>

<DT><B>返回：</B><DD>如果存在公式，返回true，否则返回false
 <p>
 <b>例子：</b>
 <pre>
  //判断当前单元格中是否存在公式
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 System.out.println(worksheet.getActiveCell().hasFormula());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="insertComment()"><!-- --></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>()</PRE>
<DL>
<DD>插入注释。
<P>
<DD><DL>

<DT><B>返回：</B><DD>注释对象
 <p>
 <b>例子：</b>
 <pre>
  //在单元格"C4"中插入注释
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Comment comment = worksheet.getCell("C4").insertComment();
 comment.setText("my comment");
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="insertComment(java.lang.String)"><!-- --></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>(java.lang.String&nbsp;text)</PRE>
<DL>
<DD>插入注释。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>text</CODE> - 注释内容
<DT><B>返回：</B><DD>注释对象
 <p>
 <b>例子：</b>
 <pre>
  //在单元格"C4"中插入注释
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Comment comment = worksheet.getCell("C4").insertComment("这是第一个注释");
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="insertComponent(int)"><!-- --></A><H3>
insertComponent</H3>
<PRE>
public java.awt.Component <B>insertComponent</B>(int&nbsp;compType)</PRE>
<DL>
<DD>在单元格中插入控件。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格行号<DD><CODE>col</CODE> - 单元格列号<DD><CODE>compType</CODE> - 控件的类型，其分类如下：
 <pre>
                ComponentConstants.GROUPBOX -- 分组框
                ComponentConstants.BUTTON -- 命令按钮
                ComponentConstants.CHECKBOX -- 复选框
                ComponentConstants.RADIOBUTTON -- 单选按钮
                ComponentConstants.LIST -- 列表框
                ComponentConstants.SCROLLBAR -- 滚动条
                ComponentConstants.SPINNER -- 数值调节钮
                ComponentConstants.TEXTBOX -- 文字框
                ComponentConstants.TOGGLEBUTTON -- 切换按钮
                ComponentConstants.LABEL -- 标签
                ComponentConstants.PICTURE -- 图像
                ComponentConstants.GROUPBOX -- 分组框
 </pre>
<DT><B>返回：</B><DD>插入到单元格中的控件
 <p>
 <b>例子: </b>
 <pre>
 //在单元格"C3"中插入复选框控件
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getCell(3, 3);
 Component comp = cell.insertComponent(ComponentConstants.CHECKBOX);
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../../application/constants/ComponentConstants.html" title="application.constants 中的接口"><CODE>ComponentConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="insertMultiMedia(java.lang.String)"><!-- --></A><H3>
insertMultiMedia</H3>
<PRE>
public void <B>insertMultiMedia</B>(java.lang.String&nbsp;name)</PRE>
<DL>
<DD>插入影音文件。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>name</CODE> - 带绝对路径的影音文件名
 <p>
 <b>例子：</b>
 <pre>
  //在单元格中插入一个影音文件
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getCell("C4");
 cell.insertMultiMedia("C:\\WINNT\\clock.avi");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的影音文件名找不到
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="insertPicture(java.lang.String)"><!-- --></A><H3>
insertPicture</H3>
<PRE>
public void <B>insertPicture</B>(java.lang.String&nbsp;pictureName)</PRE>
<DL>
<DD>插入图片。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>pictureName</CODE> - 带完全路径的图片的文件名
 <p>
 <b>例子：</b>
 <pre>
  //在单元格中插入一幅图片
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getCell("C4");
 cell.insertPicture("d:\\temp\\样品.jpg");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的图片的文件名找不到
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="insertSymbol(java.lang.String)"><!-- --></A><H3>
insertSymbol</H3>
<PRE>
public void <B>insertSymbol</B>(java.lang.String&nbsp;symbol)</PRE>
<DL>
<DD>插入符号。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>symbol</CODE> - 要插入的字符
 <p>
 <b>例子：</b>
 <PRE>
  //给当前单元格插入符号
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().insertSymbol("uvw");
 </PRE>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护或不允许编辑</DL>
</DD>
</DL>
<HR>

<A NAME="isProtected()"><!-- --></A><H3>
isProtected</H3>
<PRE>
public boolean <B>isProtected</B>()</PRE>
<DL>
<DD>单元格是否保护。
<P>
<DD><DL>

<DT><B>返回：</B><DD>TRUE表示保护，FALSE表示没有保护
 <p>
 <b>例子：</b>
 <pre>
  //获取当前单元格是否保护
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 boolean protected = worksheet.getActiveCell().isProtected();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="linkRange(java.lang.String)"><!-- --></A><H3>
linkRange</H3>
<PRE>
public void <B>linkRange</B>(java.lang.String&nbsp;rangeAddress)</PRE>
<DL>
<DD>连接区域。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>rangeAddress</CODE> - 目标区域
 <p>
 <b>例子：</b>
 <pre>