worksheet.html

永中OFFICE二次开发帮助文档

 //在当前工作表中添加浮动图表
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 sheet.addFloatingChart(ChartConstants.EMOCHART_COLUMN, ChartConstants.EMOCOLUMN_STACKED, "A5:E12", false); 
 </pre><DT><B>另请参见：</B><DD><A HREF="../../../../application/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="addHPageBreak(int)"><!-- --></A><H3>
addHPageBreak</H3>
<PRE>
public void <B>addHPageBreak</B>(int&nbsp;row)</PRE>
<DL>
<DD>在指定行处增加水平分页符。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>row</CODE> - 行号
 <p>
 <b>例子: </b>
 <pre>
  //在当前工作表的第3行处添加水平分页符
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.addHPageBreak(5);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="addHVPageBreak(int, int)"><!-- --></A><H3>
addHVPageBreak</H3>
<PRE>
public void <B>addHVPageBreak</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>
  //在当前工作表的单元格(3,5)处增加水平分页符和垂直分页符
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.addHVPageBreak(3,5);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格区域地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="addVPageBreak(int)"><!-- --></A><H3>
addVPageBreak</H3>
<PRE>
public void <B>addVPageBreak</B>(int&nbsp;column)</PRE>
<DL>
<DD>在指定列处增加垂直分页符。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>column</CODE> - 列号
 <p>
 <b>例子: </b>
 <pre>
  //在当前工作表的第5列处添加垂直分页符
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.addVPageBreak(5);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定参数的数值错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="addWorksheetListener(application.event.WorksheetListener)"><!-- --></A><H3>
addWorksheetListener</H3>
<PRE>
public void <B>addWorksheetListener</B>(<A HREF="../../../../application/event/WorksheetListener.html" title="application.event 中的接口">WorksheetListener</A>&nbsp;sl)</PRE>
<DL>
<DD>向Worksheet注册监听器
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sl</CODE> - 监听器对象    
 <p>
 <b>例子: </b>
 <pre>
 //向Worksheet添加一监听器,当工作表发生改变时激发。
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 WorksheetListener listener = new WorksheetListener()
 {
      void sheetChanged(WorksheetEvent e)
      {
          System.out.println("This worksheet is changed. The type is " + e.getType());
      }
 };
 worksheet.addWorksheetListener(listener);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="circleInvalid()"><!-- --></A><H3>
circleInvalid</H3>
<PRE>
public void <B>circleInvalid</B>()</PRE>
<DL>
<DD>圈出无效数据（不符合数据有效性的数据）。
 <p>
 <b>例子: </b>
 <pre>
 //圈出当前工作表中的无效数据
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.circleInvalid();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="clearArrows()"><!-- --></A><H3>
clearArrows</H3>
<PRE>
public void <B>clearArrows</B>()</PRE>
<DL>
<DD>删除所有追踪箭头。使用审核功能可添加追踪箭头。
 <p>
 <b>例子: </b>
 <pre>
 //删除当前工作表中的所有追踪箭头
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.clearArrows();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="clearCircles()"><!-- --></A><H3>
clearCircles</H3>
<PRE>
public void <B>clearCircles</B>()</PRE>
<DL>
<DD>清除验证圈。使用审核功能可添加追踪箭头。
 <p>
 <b>例子: </b>
 <pre>
 //圈出当前工作表中的验证圈
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.clearCircles();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="compressPicture(boolean, boolean)"><!-- --></A><H3>
compressPicture</H3>
<PRE>
public void <B>compressPicture</B>(boolean&nbsp;compressed,
                            boolean&nbsp;clipDeleted)</PRE>
<DL>
<DD>压缩当前工作表中的所有图片。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>compressed</CODE> - 是否压缩　布尔型值，如为true，压缩；如为false，不压缩<DD><CODE>clipDeleted</CODE> - 是否删除图片的剪裁区域　布尔型值，如为true，删除图片的剪裁区域；如为false，不删除图片的剪裁区域
 <p>
 <b>例子：</b>
 <pre>
 //压缩当前工作表中的所有图片。(运行代码前先在当前工作表中插入几张图片)
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook().getWorksheets().getActiveWorksheet();
 worksheet.compressPicture(true, true);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="deleteBackground()"><!-- --></A><H3>
deleteBackground</H3>
<PRE>
public void <B>deleteBackground</B>()</PRE>
<DL>
<DD>删除当前工作表的背景图片。
 <p>
 <b>例子: </b>
 <pre>
  //删除当前工作表的背景图片
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 worksheet.deleteBackground();
 </pre>
<P>
<DD><DL>
</DL>
</DD>
</DL>
<HR>

<A NAME="deleteEntireColumns(int, int)"><!-- --></A><H3>
deleteEntireColumns</H3>
<PRE>
public void <B>deleteEntireColumns</B>(int&nbsp;startCol,
                                int&nbsp;endCol)</PRE>
<DL>
<DD>删除整列，表示右方单元格左移至相应位置。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>startCol</CODE> - 开始列号<DD><CODE>endCol</CODE> - 结束列号
 <p>
 <b>例子：</b>
 <pre>
 //在当前工作表中，删除第3至第5列
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 worksheet.deleteEntireColumns(3,5);
 </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> - 当区域的起始行大于结束行
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当工作表单元格已被保护</DL>
</DD>
</DL>
<HR>

<A NAME="deleteEntireRows(int, int)"><!-- --></A><H3>
deleteEntireRows</H3>
<PRE>
public void <B>deleteEntireRows</B>(int&nbsp;startRow,
                             int&nbsp;endRow)</PRE>
<DL>
<DD>删除整行，并使下方单元格上移至相应位置。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>startRow</CODE> - 开始行号<DD><CODE>endRow</CODE> - 结束行号
 <p>
 <b>例子：</b>
 <pre>
 //在当前工作表中，删除第3至第5行
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                  .getWorksheets().getActiveWorksheet();
 worksheet.deleteEntireRows(3,5);
 </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> - 当区域的起始行大于结束行
<DD><CODE><A HREF="../../.