cell.html

永中OFFICE二次开发帮助文档

 worksheet.setCellValue(3,3,"abc");
 Cell cell = worksheet.getCell(3,3);
 cell.cut();
 <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="floatChart()"><!-- --></A><H3>
floatChart</H3>
<PRE>
public void <B>floatChart</B>()</PRE>
<DL>
<DD>浮起单元格内图表。   
 <p>
 <b>例子：</b>
 <pre>
  //浮起当前单元格内的图表
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 //单元格内已有图表
 worksheet.getActiveCell().floatChart();
 </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="floatComponent()"><!-- --></A><H3>
floatComponent</H3>
<PRE>
public java.awt.Component <B>floatComponent</B>()</PRE>
<DL>
<DD>浮起单元格中的控件。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 单元格的行号<DD><CODE>col</CODE> - 单元格的列号
<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);
 System.out.println(comp);
 Component comp2 = cell.floatComponent();
 System.out.println(comp2);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="floatPicture()"><!-- --></A><H3>
floatPicture</H3>
<PRE>
public void <B>floatPicture</B>()</PRE>
<DL>
<DD>浮起单元格内图片。 
 <p>
 <b>例子：</b>
 <pre> 
  //浮起当前单元格内的图片
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet(); 
 Cell cell = worksheet.getActiveCell();
  //单元格内已有图片
 cell.floatPicture();
 </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="getAddress()"><!-- --></A><H3>
getAddress</H3>
<PRE>
public java.lang.String <B>getAddress</B>()</PRE>
<DL>
<DD>获取单元格的地址。
<P>
<DD><DL>

<DT><B>返回：</B><DD>单元格的地址
 <p>
 <b>例子：</b>
 <pre>
  //获取当前单元格的地址
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 String address = worksheet.getActiveCell().getAddress();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getBorderAttribute()"><!-- --></A><H3>
getBorderAttribute</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/style/border/BorderAttribute.html" title="application.workbooks.workbook.style.border 中的类">BorderAttribute</A> <B>getBorderAttribute</B>()</PRE>
<DL>
<DD>获得边框属性。
<P>
<DD><DL>

<DT><B>返回：</B><DD>边框属性
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格的边框属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 BorderAttribute border =  worksheet.getActiveCell().getBorderAttribute();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getCellString()"><!-- --></A><H3>
getCellString</H3>
<PRE>
public java.lang.String <B>getCellString</B>()</PRE>
<DL>
<DD>获得单元格内容。
<P>
<DD><DL>

<DT><B>返回：</B><DD>字符内容
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格的内容
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 String content = worksheet.getActiveCell().getCellString();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getCharacters(int, int)"><!-- --></A><H3>
getCharacters</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Characters.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Characters</A> <B>getCharacters</B>(int&nbsp;startPosition,
                                int&nbsp;length)</PRE>
<DL>
<DD>取得单元格中的部分字符集。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>startPosition</CODE> - 起始位置<DD><CODE>length</CODE> - 选取长度
<DT><B>返回：</B><DD>指定的字符集
 <p>
 <b>例子：</b>
 <pre>
  //取得单元格"a1"中的字符集，并设置字符集中的字体  
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getCell("a1");
 cell.setValue("abcdef");
 Characters chars = cell.getCharacters(1,4);
 System.out.println(chars.toString());
 chars.setFontSize(14);
 chars.setFontBold(true); 
 chars.setFontColor(java.awt.Color.RED); 
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的参数的数值错误或越界<DT><B>另请参见：</B><DD><A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Characters.html" title="application.workbooks.workbook.worksheets.worksheet 中的类"><CODE>Characters</CODE></A></DL>
</DD>
</DL>
<HR>

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

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

<A NAME="getColumnWidth()"><!-- --></A><H3>
getColumnWidth</H3>
<PRE>
public double <B>getColumnWidth</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("Width is " + cell.getColumnWidth());
 </PRE></DL>
</DD>
</DL>
<HR>

<A NAME="getComment()"><!-- --></A><H3>
getComment</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/style/comment/Comment.html" title="application.workbooks.workbook.style.comment 中的类">Comment</A> <B>getComment</B>()</PRE>
<DL>
<DD>获取单元格内的注释。
<P>
<DD><DL>

<DT><B>返回：</B><DD>指定单元格内的注释 
 <p>
 <b>例子：</b>
 <pre>
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Comment comment = worksheet.getCell("C4").getComment();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFillAttribute()"><!-- --></A><H3>
getFillAttribute</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A> <B>getFillAttribute</B>()</PRE>
<DL>
<DD>获取填充属性。
<P>
<DD><DL>

<DT><B>返回：</B><DD>填充属性
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格的填充属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FillAttribute fa =  worksheet.getActiveCell().getFillAttribute();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFontAttribute()"><!-- --></A><H3>
getFontAttribute</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A> <B>getFontAttribute</B>()</PRE>
<DL>
<DD>获得字体属性。
<P>
<DD><DL>

<DT><B>返回：</B><DD>字体属性
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格的字体属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FontAttribute font = worksheet.getActiveCell().getFontAttribute();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFormatCellAttribute()"><!-- --></A><H3>
getFormatCellAttribute</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/FormatCellAttribute.html" title="application.workbooks.workbook.worksheets 中的类">FormatCellAttribute</A> <B>getFormatCellAttribute</B>()</PRE>
<DL>
<DD>获得单元格格式属性。
<P>
<DD><DL>

<DT><B>返回：</B><DD>单元格格式属性
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格的单元格格式属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FormatCellAttribute fca =  worksheet.getActiveCell().getFormatCellAttribute();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFormula()"><!-- --></A><H3>
getFormula</H3>
<PRE>
public java.lang.String <B>getFormula</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();
 if (cell.hasFormula())
 {
     System.out.println(cell.getFormula());
 }
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getParent()"><!-- --></A><H3>