scenario.html

永中OFFICE二次开发帮助文档

 <p>
 <b>例子: </b>
 <pre>
 //取得存放可变单元格的数组
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 String[] values = scenario.getCellValue();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getMemo()"><!-- --></A><H3>
getMemo</H3>
<PRE>
public java.lang.String <B>getMemo</B>()</PRE>
<DL>
<DD>取得备注。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>getMemo</CODE></DL>
</DD>
<DD><DL>

<DT><B>返回：</B><DD>备注
 <p>
 <b>例子: </b>
 <pre>
 //取得方案"ww"的备注
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 String memo = scenario.getMemo();
 System.out.println(memo);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getName()"><!-- --></A><H3>
getName</H3>
<PRE>
public java.lang.String <B>getName</B>()</PRE>
<DL>
<DD>取得方案的名称。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>getName</CODE></DL>
</DD>
<DD><DL>

<DT><B>返回：</B><DD>名称
 <p>
 <b>例子: </b>
 <pre>
 //取得方案的名称　
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 String name = scenario.getName();
 System.out.println(name);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setCellDescription(java.lang.String)"><!-- --></A><H3>
setCellDescription</H3>
<PRE>
public void <B>setCellDescription</B>(java.lang.String&nbsp;rangeAddress)</PRE>
<DL>
<DD>设置方案描述字符串的单元格位置。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>setCellDescription</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>rangeAddress</CODE> - 单元格地址
 <p>
 <b>例子: </b>
 <pre>
 //设置方案描述字符串的单元格位置
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 Scenario scenario = scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 scenario.setCellDescription("$B$10:$C$20"); 
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的单元格区域地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="setCellValue(java.lang.String[])"><!-- --></A><H3>
setCellValue</H3>
<PRE>
public void <B>setCellValue</B>(java.lang.String[]&nbsp;values)</PRE>
<DL>
<DD>设置存储可变单元格的值。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>setCellValue</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>values</CODE> - 可变单元格的值
 <p>
 <b>例子: </b>
 <pre>
 //设置存储可变单元格的值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 Scenario scenario = scenarios.addScenario("aa","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 scenario.setCellValue(new String[]{"q","we","r","t","y","y","u","iop"});
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setMemo(java.lang.String)"><!-- --></A><H3>
setMemo</H3>
<PRE>
public void <B>setMemo</B>(java.lang.String&nbsp;memo)</PRE>
<DL>
<DD>设置备注。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>setMemo</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>memo</CODE> - 备注
 <p>
 <b>例子: </b>
 <pre>
 //设置名为"ww"的方案的备注为"aaaaaaaaa"
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 scenario.setMemo("aaaaaaaaa");
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setName(java.lang.String)"><!-- --></A><H3>
setName</H3>
<PRE>
public void <B>setName</B>(java.lang.String&nbsp;name)</PRE>
<DL>
<DD>设置方案的名称。
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>setName</CODE></DL>
</DD>
<DD><DL>
<DT><B>参数：</B><DD><CODE>name</CODE> - 名称
 <p>
 <b>例子: </b>
 <pre>
 //将名称为"ww"的方案的名称设置为"ww2"
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 scenario.setName("ww2");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当方案名为空</DL>
</DD>
</DL>
<HR>

<A NAME="showValue()"><!-- --></A><H3>
showValue</H3>
<PRE>
public void <B>showValue</B>()</PRE>
<DL>
<DD>显示可变单元格中值。
 <p>
 <b>例子: </b>
 <pre>
 //显示可变单元格中值
 Worksheet worksheet = Application.getWorkbooks().getActiveWorkbook()
                                 .getWorksheets().getActiveWorksheet();
 Scenarios scenarios = worksheet.getScenarios();
 scenarios.addScenario("ww","$B$17:$C$20","创建者 coolin 日期 2006-01-20");
 Scenario scenario = scenarios.getScenario("ww"); 
 scenario.showValue();
 </pre>
<P>
<DD><DL>
<DT><B>覆盖：</B><DD>类 <CODE>application.workbooks.workbook.worksheets.worksheet.Scenario</CODE> 中的 <CODE>showValue</CODE></DL>
</DD>
<DD><DL>
</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;<A HREF="../../../../application/workbooks/workbook/worksheets/ProtectProperties.html" title="application.workbooks.workbook.worksheets 中的类"><B>上一个类</B></A>&nbsp;
&nbsp;<A HREF="../../../../application/workbooks/workbook/worksheets/Scenarios.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/Scenario.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="Scenario.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>