chart.html

永中OFFICE二次开发帮助文档

<A NAME="isSelected()"><!-- --></A><H3>
isSelected</H3>
<PRE>
public boolean <B>isSelected</B>()</PRE>
<DL>
<DD>图表的选取状态。
<P>
<DD><DL>

<DT><B>返回：</B><DD>isSelected 布尔型值，
 若isSelected为true，则表明该轴处于被选取状态；否则不被选取
 <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()); 
 Chart chart = charts.getActiveChart();
 System.out.println("isSelect:" + chart.isSelected());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="isSeriesByRow()"><!-- --></A><H3>
isSeriesByRow</H3>
<PRE>
public boolean <B>isSeriesByRow</B>()</PRE>
<DL>
<DD>获得图表系列是按行还是按列生成。
<P>
<DD><DL>

<DT><B>返回：</B><DD>TRUE 表示按行生成，FALSE 表示按列生成  
 <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()); 
 Chart chart = charts.getActiveChart();
 System.out.println(chart.isSeriesByRow());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="isTableAreaVisible()"><!-- --></A><H3>
isTableAreaVisible</H3>
<PRE>
public boolean <B>isTableAreaVisible</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, sheet.getName()); 
 Chart chart = charts.getActiveChart();
 if(!chart.isTableAreaVisible())
 {
     chart.setTableAreaVisible(true);
 }
 chart.refresh();
 System.out.println("showTable:" + chart.isTableAreaVisible());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="removeChartListener(application.event.ChartListener)"><!-- --></A><H3>
removeChartListener</H3>
<PRE>
public void <B>removeChartListener</B>(<A HREF="../../../../application/event/ChartListener.html" title="application.event 中的接口">ChartListener</A>&nbsp;chartListener)</PRE>
<DL>
<DD>从Chart中移除监听器。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>chartListener</CODE> - Chart监听器对象
 <p>
 <b>例子：</b>
 <pre>
 //插入一张浮动图表，并向其注册事件监听器，当激活图表时弹出"activate"消息对话框，然后移除该事件监听器。
 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 chart = charts.getActiveChart();
 ChartListener chartListener = new ChartListener()
 {
                public void chartChanged(ChartEvent e)
                {
                        if (e.getType() == e.ACTIVATE)
                        {
                                JOptionPane.showMessageDialog(null, "activate");
                        }
                }
 }
 chart.addChartListener(chartListener);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="saveAsTemplate(java.lang.String)"><!-- --></A><H3>
saveAsTemplate</H3>
<PRE>
public void <B>saveAsTemplate</B>(java.lang.String&nbsp;filename)</PRE>
<DL>
<DD>另存为图表模板。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>filename</CODE> - 带路径文件名
 <p>
 <b>例子：</b>
 <pre>
 //首先插入一张图表，然后用户设计后运行以下代码，以下代码将把设计好的图表作为模板"a.ect"保存在C盘根目录下
 Workbook workbook = Application.getWorkbooks().getActiveWorkbook();
 Chart chart = workbook.getCharts().getActiveChart();
 chart.saveAsTemplate("C:\\a.ect");
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当带路径文件名无效</DL>
</DD>
</DL>
<HR>

<A NAME="setChartBarType(int)"><!-- --></A><H3>
setChartBarType</H3>
<PRE>
public void <B>setChartBarType</B>(int&nbsp;typeIndex)</PRE>
<DL>
<DD>图表工具条上选取图表类型。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>typeIndex</CODE> - 图表类型,其取值如下:
 <pre>
         ChartConstants.BARAREA_STACKED:面积图; 
         ChartConstants.BARAREA_STACKED100:百分比堆积面积图。 
         ChartConstants.BARBAR_ClUSTERED:条形图; 
         ChartConstants.BA3DRBAR_ClUSTERED:三维条形图；
         ChartConstants.BARCOLUMN_ClUSTERED：柱形图；
         ChartConstants.BAR3DCOLUMN：三维柱形图；
         ChartConstants.BAR_RADAR:雷达图；
         ChartConstants.BAR_BUBBLE:气泡图；
         ChartConstants.BAR_LINEMARKERS：折线图；
         ChartConstants.BAR_XYSCATTER：散点图；
         ChartConstants.BAR_PIE：饼图；
         ChartConstants.BAR_DOUGHNUT：圆环图
 </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();
 Chart chart = charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN, ChartConstants.EMOCOLUMN_STACKED, sheet.getName());  
 chart.setChartBarType(ChartConstants.BAR_LINEMARKERS);
 </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>
<HR>

<A NAME="setChartLocationAsSheet(java.lang.String)"><!-- --></A><H3>
setChartLocationAsSheet</H3>
<PRE>
public void <B>setChartLocationAsSheet</B>(java.lang.String&nbsp;sheetName)</PRE>
<DL>
<DD>将图表生成指定的工作表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sheetName</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();
 Chart chart = charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN, ChartConstants.EMOCOLUMN_STACKED, sheet.getName());
 chart.setChartLocationAsSheet("图表工作表");</DL>
</DD>
</DL>
<HR>

<A NAME="setChartLocationInCell(java.lang.String, int, int)"><!-- --></A><H3>
setChartLocationInCell</H3>
<PRE>
public void <B>setChartLocationInCell</B>(java.lang.String&nbsp;sheetName,
                                   int&nbsp;row,
                                   int&nbsp;column)</PRE>
<DL>
<DD>将图表插入到指定的单元格中。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sheetName</CODE> - 指定的工作表名称<DD><CODE>row</CODE> - 指定插入的行(行号从1开始)<DD><CODE>column</CODE> - 指定插入的列(列号从1开始)
 <p>
 <b>例子：</b>
 <pre>
 //将浮动图表作为工作表单元格中的对象定位到工作表1的(1,1)单元格位置。
 Workbook book = Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range = sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 Chart chart = charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN, ChartConstants.EMOCOLUMN_STACKED, sheet.getName());
 chart.setChartLocationInCell("工作表1", 1, 1);  
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setChartLocationInSheet(java.lang.String)"><!-- --></A><H3>
setChartLocationInSheet</H3>
<PRE>
public void <B>setChartLocationInSheet</B>(java.lang.String&nbsp;sheetName)</PRE>
<DL>
<DD>将图表放到指定的工作表上面。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>sheetName</CODE> - 指定的工作表名称
 <p>
 <b>例子：</b>
 <pre>
 //将浮动图表作为工作表中的对象定位到工作表2。
 Workbook book = Application.getWorkbooks().getActiveWorkbook();
 Worksheet sheet = book.getWorksheets().getActiveWorksheet();    
 Range range = sheet.getRange("A5:E12");
 range.fillRandom();
 Charts charts = book.getCharts();
 Chart chart = charts.addFloatingChart(ChartConstants.EMOCHART_COLUMN, ChartConstants.EMOCOLUMN_STACKED, sheet.getName());
 chart.setChartLocationInSheet("工作表2");</DL>
</DD>
</DL>
<HR>

<A NAME="setChartType(int, int)"><!-- --></A><H3>
setChartType</H3>
<PRE>
public void <B>setChartType</B>(int&nbsp;type,
                         int&nbsp;subType)</PRE>
<DL>
<DD>设置图表的类型。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>type</CODE> - 图表主类型索引<DD><CODE>subType</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()); 
 Chart chart = charts.getActiveChart();
 chart.setChartType(ChartConstants.EMOCHART_BAR, ChartConstants.EMOBAR_STACKED);
 System.out.println("ChartType:" + chart.getMainType());
 System.out.println("SubType:" + chart.getChartSubType());
 </pre></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;fillAttr)</PRE>
<DL>
<DD>设置填充属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fillAttr</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()); 
 Chart chart = charts.getActiveChart();
 FillAttribute fill = chart.getFillAttribute();
 fill.getTextureAttribute().setTextureIndex(2);
 chart.setFillAttribute(fill);
 </pre></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;fontAttribute)</PRE>