cell.html

永中OFFICE二次开发帮助文档

  //在单元格"G7" 连接单元格区域"B3:E5"
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Range range = worksheet.getRange("B3:E5");
 range.setValue("ABC");
 Cell cell = worksheet.getCell("G7");
 cell.linkRange("B3:E5");    
 </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="offset(int, int)"><!-- --></A><H3>
offset</H3>
<PRE>
public <A HREF="../../../../../application/workbooks/workbook/worksheets/worksheet/Cell.html" title="application.workbooks.workbook.worksheets.worksheet 中的类">Cell</A> <B>offset</B>(int&nbsp;rows,
                   int&nbsp;columns)</PRE>
<DL>
<DD>根据单元格位置做指定的偏移
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>rows</CODE> - 需要偏移的行数<DD><CODE>columns</CODE> - 需要偏移的列数
<DT><B>返回：</B><DD>返回指定的单元格
 <p>
 <b>例子：</b>
 <pre>
  //获得当前单元格向下偏移一格后的单元格
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getActiveCell();
 Cell temp = cell.offset(1,0);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="paste()"><!-- --></A><H3>
paste</H3>
<PRE>
public void <B>paste</B>()</PRE>
<DL>
<DD>粘贴。
 <p>
 <b>例子：</b>
 <PRE>
  //把单元格"C3"复制粘贴到单元格"C4"
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 worksheet.setCellValue(3,3,"abc");
 Cell cell = worksheet.getCell(3,3);
 cell.copy();
 worksheet.getRange("C4").paste();
 </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="select()"><!-- --></A><H3>
select</H3>
<PRE>
public void <B>select</B>()</PRE>
<DL>
<DD>选中单元格。 
 <p>
 <b>例子：</b>
 <pre>
  //使单元格"e3"成为当前单元格
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Cell cell = worksheet.getCell(3,5);
 cell.select();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="setBorderAttribute(application.workbooks.workbook.style.border.BorderAttribute)"><!-- --></A><H3>
setBorderAttribute</H3>
<PRE>
public void <B>setBorderAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/border/BorderAttribute.html" title="application.workbooks.workbook.style.border 中的类">BorderAttribute</A>&nbsp;ba)</PRE>
<DL>
<DD>设置边框。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>ba</CODE> - 边框属性
<p>
<b>例子：</b>
 <pre>
  //给当前单元格设置边框属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 BorderAttribute border = new BorderAttribute();
 border.setApplyType(BorderAndShadingConstants.APPLY_CELL);
 border.setBorderType(BorderAndShadingConstants.BORDERTYPE_CUSTOM);
 border.setBorderLineType(BorderAndShadingConstants.DIAGONAL_FORWARD,0);
 border.setBorderLineWidth(BorderAndShadingConstants.DIAGONAL_FORWARD,0.5f);
 border.setBorderLineType(BorderAndShadingConstants.DIAGONAL_BACKWARD,0);
 border.setBorderLineWidth(BorderAndShadingConstants.DIAGONAL_BACKWARD,0.5f);
 worksheet.getActiveCell().setBorderAttribute(border);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="setFillAttribute(application.workbooks.workbook.style.fill.FillAttribute)"><!-- --></A><H3>
setFillAttribute</H3>
<PRE>
public void <B>setFillAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A>&nbsp;fa)</PRE>
<DL>
<DD>设置填充属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fa</CODE> - 填充属性   
<p>
<b>例子：</b>
 <pre>
  //给当前单元格设置填充属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FillAttribute fill = new FillAttribute();
 fill.setTexture(255,204,153);
 worksheet.getActiveCell().setFillAttribute(fill);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="setFontAttribute(application.workbooks.workbook.style.font.FontAttribute)"><!-- --></A><H3>
setFontAttribute</H3>
<PRE>
public void <B>setFontAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A>&nbsp;ca)</PRE>
<DL>
<DD>设置字体属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>ca</CODE> - 字体属性
<p>
<b>例子：</b>
 <pre>
  //给当前单元格设置字体属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FontAttribute font = new FontAttribute();
 font.setBold(true);
 font.setForeground(255,0,0);
 font.setStrikeThrough(true);
 worksheet.getActiveCell().setFontAttribute(font);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="setFormatCellAttribute(application.workbooks.workbook.worksheets.FormatCellAttribute)"><!-- --></A><H3>
setFormatCellAttribute</H3>
<PRE>
public void <B>setFormatCellAttribute</B>(<A HREF="../../../../../application/workbooks/workbook/worksheets/FormatCellAttribute.html" title="application.workbooks.workbook.worksheets 中的类">FormatCellAttribute</A>&nbsp;attr)</PRE>
<DL>
<DD>设置单元格格式属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>attr</CODE> - 单元格格式属性
<p>
<b>例子：</b>
 <pre>
  //给当前单元格设置单元格格式属性
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 FormatCellAttribute fcAttribute = new FormatCellAttribute();
 fcAttribute.setHorizontalIndex(CellFormatConstants.HOR_MIDDLE);
 worksheet.getActiveCell().setFormatCellAttribute(fcAttribute);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="setText(java.lang.String)"><!-- --></A><H3>
setText</H3>
<PRE>
public void <B>setText</B>(java.lang.String&nbsp;text)</PRE>
<DL>
<DD>设置字符串的值。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>text</CODE> - 未经解析的基本字符串
 <p>
 <b>例子：</b>
 <pre>
  //给当前单元格设值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().setText("22-Jan-2007");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护或不允许编辑</DL>
</DD>
</DL>
<HR>

<A NAME="setValue(boolean)"><!-- --></A><H3>
setValue</H3>
<PRE>
public void <B>setValue</B>(boolean&nbsp;value)</PRE>
<DL>
<DD>设值。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 布尔型值
 <p>
 <b>例子：</b>
 <pre>
  //给当前单元格设值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().setValue(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="setValue(double)"><!-- --></A><H3>
setValue</H3>
<PRE>
public void <B>setValue</B>(double&nbsp;value)</PRE>
<DL>
<DD>设值。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 双精度型值
 <p>
 <b>例子：</b>
 <pre>
  //给当前单元格设值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().setValue(3.14159265357);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护或不允许编辑</DL>
</DD>
</DL>
<HR>

<A NAME="setValue(long)"><!-- --></A><H3>
setValue</H3>
<PRE>
public void <B>setValue</B>(long&nbsp;value)</PRE>
<DL>
<DD>设值。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 长整型值
 <p>
 <b>例子：</b>
 <pre>
  //给当前单元格设值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().setValue(1.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="setValue(java.lang.String)"><!-- --></A><H3>
setValue</H3>
<PRE>
public void <B>setValue</B>(java.lang.String&nbsp;value)</PRE>
<DL>
<DD>设值。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>value</CODE> - 未经解析的基本字符串
 <p>
 <b>例子：</b>
 <pre>
  //给当前单元格设值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getActiveCell().setValue("ABC");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当单元格区域已被保护或不允许编辑</DL>
</DD>
</DL>
<HR>

<A NAME="showComment(boolean)"><!-- --></A><H3>
showComment</H3>
<PRE>
public void <B>showComment</B>(boolean&nbsp;show)</PRE>
<DL>
<DD>显示注释。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>show</CODE> - 布尔型，如为true，则显示注释；否则不显示注释
 <p>
 <b>例子：</b>
 <pre>
  //显示单元格内的注释
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.getCell("C4").showComment(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