charts.html

永中OFFICE二次开发帮助文档

 Chart chart = charts.getFloatingChart("图表1");
 System.out.println(chart); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFloatingChart(java.lang.String, java.lang.String)"><!-- --></A><H3>
getFloatingChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>getFloatingChart</B>(java.lang.String&nbsp;workSheetName,
                              java.lang.String&nbsp;chartName)</PRE>
<DL>
<DD>通过工作表名字和图表名称获取浮动图表对象.
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>workSheetName</CODE> - 工作表名称<DD><CODE>chartName</CODE> - 图表名称
<DT><B>返回：</B><DD>获取Chart对象
 <p>
 <b >例子：</b>
 <pre>
  //通过工作表名字和图表名称获取浮动图表对象,并打印其图表主类型
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getWorksheet("工作表1");    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,"工作表1"); 
 Chart chart = charts.getFloatingChart("工作表1","图表1");
 System.out.println(chart.getMainType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFloatingChartName()"><!-- --></A><H3>
getFloatingChartName</H3>
<PRE>
public java.lang.String <B>getFloatingChartName</B>()</PRE>
<DL>
<DD>取得当前活动的浮动图表的名字。
<P>
<DD><DL>

<DT><B>返回：</B><DD>name
 <p>
 <b >例子：</b>
 <pre>
  //取得当前活动的浮动图表的名字
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,sheet.getName()); 
 System.out.println(charts.getFloatingChartName());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getPlacement(java.lang.String)"><!-- --></A><H3>
getPlacement</H3>
<PRE>
public int <B>getPlacement</B>(java.lang.String&nbsp;chartName)</PRE>
<DL>
<DD>返回图表区域属性的位置。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>chartName</CODE> - 图表的名字
<DT><B>返回：</B><DD>int 为整型数值
        ChartConstants.LOCATION_FOLLOW  表示随单元格一起移动并改变大小
        ChartConstants.LOCATION_NOT_FOLLOW  表示单元格移动但不随单元格改变大小
        ChartConstants.LOCATION_NONE_FOLLOW  表示不随单元格移动也不随单元格改变大小
 <p>
 <b >例子：</b> 
 <pre>
  //获得图表区域属性的位置
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,sheet.getName());  
 String chartName = charts.getFloatingChartName();
 charts.setPlacement(chartName,ChartConstants.LOCATION_NOT_FOLLOW);
 System.out.println("posFloat"+charts.getPlacement(chartName));
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getWorksheetChart(java.lang.String)"><!-- --></A><H3>
getWorksheetChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>getWorksheetChart</B>(java.lang.String&nbsp;sheetChartName)</PRE>
<DL>
<DD>通过名称获取工作表图表的对象。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sheetChartName</CODE> - 工作表图表的名称
<DT><B>返回：</B><DD>获取工作表图表对象
 <p>
 <b >例子：</b>
 <pre>
  //获取名为"aa"的工作表图表的对象
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addWorkSheetChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED, "aa");
 Chart chart = charts.getWorksheetChart("aa");
 System.out.println(chart.getMainType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setFloatingChartName(java.lang.String, java.lang.String)"><!-- --></A><H3>
setFloatingChartName</H3>
<PRE>
public void <B>setFloatingChartName</B>(java.lang.String&nbsp;oldName,
                                 java.lang.String&nbsp;newName)</PRE>
<DL>
<DD>改变当前浮动图表的名字。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>oldName</CODE> - 浮动图表旧名字<DD><CODE>newName</CODE> - 浮动图表新名字
 <p>
 <b >例子：</b>
 <pre>
  //改变当前浮动图表的名字为"aa"
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.select();
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,sheet.getName()); 
 String oldName = charts.getFloatingChartName();    
 charts.setFloatingChartName(oldName, "aa");
 String newName = charts.getFloatingChartName();
 System.out.println("newName:"+newName);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setPlacement(java.lang.String, int)"><!-- --></A><H3>
setPlacement</H3>
<PRE>
public void <B>setPlacement</B>(java.lang.String&nbsp;chartName,
                         int&nbsp;placement)</PRE>
<DL>
<DD>设置图表区域属性的位置。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>chartName</CODE> - 图表的名字<DD><CODE>placement</CODE> - 设置图表面积的新位置，为整型数值
 <pre>
        ChartConstants.LOCATION_FOLLOW 表示随单元格一起移动并改变大小
        ChartConstants.LOCATION_NOT_FOLLOW 表示随单元格移动但不随单元格改变大小
        ChartConstants.LOCATION_NONE_FOLLOW  表示不随单元格移动也不随单元格改变大小
 </pre> 
 <p>
 <b >例子：</b>
 <pre>
  //设置图表区域属性的位置
 Workbook book =  Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range=sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,sheet.getName()); 
 String chartName = charts.getFloatingChartName();
 charts.setPlacement(chartName,ChartConstants.LOCATION_FOLLOW);
 </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/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></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;上一个类&nbsp;
&nbsp;<A HREF="../../../application/workbooks/workbook/CustomFileProperties.html" title="application.workbooks.workbook 中的类"><B>下一个类</B></A></FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../index.html?application/workbooks/workbook/Charts.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="Charts.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>