charts.html

永中OFFICE二次开发帮助文档

<BR>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;设置图表区域属性的位置。</TD>
</TR>
</TABLE>
&nbsp;<A NAME="methods_inherited_from_class_java.lang.Object"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#EEEEFF" CLASS="TableSubHeadingColor">
<TH ALIGN="left"><B>从类 java.lang.Object 继承的方法</B></TH>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD><CODE>equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</CODE></TD>
</TR>
</TABLE>
&nbsp;
<P>

<!-- ============ METHOD DETAIL ========== -->

<A NAME="method_detail"><!-- --></A>
<TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY="">
<TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor">
<TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2">
<B>方法详细信息</B></FONT></TH>
</TR>
</TABLE>

<A NAME="addCellChart(int, int, java.lang.String, int, int)"><!-- --></A><H3>
addCellChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>addCellChart</B>(int&nbsp;type,
                          int&nbsp;subType,
                          java.lang.String&nbsp;workSheetName,
                          int&nbsp;row,
                          int&nbsp;col)</PRE>
<DL>
<DD>添加单元格图表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 图表主类型<DD><CODE>subType</CODE> - 图表次类型<DD><CODE>workSheetName</CODE> - 工作表的名字<DD><CODE>row</CODE> - 单元格的行<DD><CODE>col</CODE> - 单元格的列
<DT><B>返回：</B><DD>图表
 <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.addCellChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,"工作表2",15,7); 
 </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> - 当参数越界<DT><B>另请参见：</B><DD><A HREF="../../../application/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="addFloatingChart(int, int, java.lang.String)"><!-- --></A><H3>
addFloatingChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>addFloatingChart</B>(int&nbsp;type,
                              int&nbsp;subType,
                              java.lang.String&nbsp;workSheetName)</PRE>
<DL>
<DD>添加浮动图表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 图表主类型<DD><CODE>subType</CODE> - 图表次类型<DD><CODE>workSheetName</CODE> - 要添加图表的工作表名
<DT><B>返回：</B><DD>浮动图表
 <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,"工作表1"); 
 </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> - 当参数越界<DT><B>另请参见：</B><DD><A HREF="../../../application/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="addWorksheetChart(int, int, java.lang.String)"><!-- --></A><H3>
addWorksheetChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>addWorksheetChart</B>(int&nbsp;type,
                               int&nbsp;subType,
                               java.lang.String&nbsp;chartSheetName)</PRE>
<DL>
<DD>添加工作表图表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 图表主类型<DD><CODE>subType</CODE> - 图表次类型<DD><CODE>chartSheetName</CODE> - 要添加的图表工作表名
<DT><B>返回：</B><DD>图表
 <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.addWorksheetChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,"图表1"); 
 </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> - 当参数越界<DT><B>另请参见：</B><DD><A HREF="../../../application/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></DL>
</DD>
</DL>
<HR>

<A NAME="floatingChartInToCell(int, int)"><!-- --></A><H3>
floatingChartInToCell</H3>
<PRE>
public void <B>floatingChartInToCell</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>
  //把当前激活的浮动图表插入到当前工作表指定的单元格中
 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());  
 charts.floatingChartInToCell(15,7); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getActiveChart()"><!-- --></A><H3>
getActiveChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>getActiveChart</B>()</PRE>
<DL>
<DD>获得当前工作表下活动图表。
<P>
<DD><DL>

<DT><B>返回：</B><DD>当前活动图表
 <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,"工作表1"); 
 Chart chart = charts.getActiveChart();
 System.out.println(chart.getMainType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getAllCharts(java.lang.String)"><!-- --></A><H3>
getAllCharts</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A>[] <B>getAllCharts</B>(java.lang.String&nbsp;sheetName)</PRE>
<DL>
<DD>取得指定工作表上的所有图表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sheetName</CODE> - 工作表名
<DT><B>返回：</B><DD>所有图表
 <p>
 <b >例子：</b>
 <pre>
  //取得工作表1上的所有图表
 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());  
 Chart[] allcharts = charts.getAllCharts("工作表1");
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getCellChart(java.lang.String, int, int)"><!-- --></A><H3>
getCellChart</H3>
<PRE>
public <A HREF="../../../application/workbooks/workbook/charts/Chart.html" title="application.workbooks.workbook.charts 中的类">Chart</A> <B>getCellChart</B>(java.lang.String&nbsp;workSheetName,
                          int&nbsp;row,
                          int&nbsp;col)</PRE>
<DL>
<DD>通过工作表名字和行列号获取单元格图表对象。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>workSheetName</CODE> - 工作表名称<DD><CODE>row</CODE> - 行号<DD><CODE>col</CODE> - 列号
<DT><B>返回：</B><DD>单元格图表对象
 <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.addCellChart(ChartConstants.EMOCHART_COLUMN,ChartConstants.EMOCOLUMN_STACKED,"工作表1",15,7); 
 Chart chart = charts.getCellChart("工作表1",15,7);
 System.out.println(chart.getMainType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFloatingChart(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;name)</PRE>
<DL>
<DD>在当前工作表通过名字获得活动图表对象。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>name</CODE> - 图表的名称
<DT><B>返回：</B><DD>图表对象
 <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,"工作表1");