chart.html

永中OFFICE二次开发帮助文档

<DL>
<DD>设置字体属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>fontAttribute</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();
 FontAttribute fontAttribute = chart.getFontAttribute();
 fontAttribute.setBold(true);
 chart.setFontAttribute(fontAttribute);
 FontAttribute fontAttribute1 = chart.getFontAttribute();
 System.out.println("Bold:" + fontAttribute1.isBold());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setHasCorner(boolean)"><!-- --></A><H3>
setHasCorner</H3>
<PRE>
public void <B>setHasCorner</B>(boolean&nbsp;hasCorner)</PRE>
<DL>
<DD>设置图表是否有圆角效果。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>hasCorner</CODE> - 布尔型值，如为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(); 
 if(!chart.hasCorner())
 {
     chart.setHasCorner(true);
 }
 System.out.println("hasCorner:" + chart.hasCorner());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setHasShadow(boolean)"><!-- --></A><H3>
setHasShadow</H3>
<PRE>
public void <B>setHasShadow</B>(boolean&nbsp;hasShadow)</PRE>
<DL>
<DD>设置是否有阴影。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>hasShadow</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();
 if(!chart.hasShadow())
 {
     chart.setHasShadow(true);
 }
 System.out.println("hasShadow:" + chart.hasShadow());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setLineAttribute(application.workbooks.workbook.charts.chart.LineAttribute)"><!-- --></A><H3>
setLineAttribute</H3>
<PRE>
public void <B>setLineAttribute</B>(application.workbooks.workbook.charts.chart.LineAttribute&nbsp;lineAttr)</PRE>
<DL>
<DD>设置边框属性。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>lineAttr</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();
 LineAttribute lineAttr = chart.getLineAttribute();
 lineAttr.setBorderType(ChartConstants.BORDER_CUSTOM);
 lineAttr.setLineStyle(ChartConstants.LINESTYLE_SOLID);
 lineAttr.setColor(255, 0, 0);
 lineAttr.setWidth(ChartConstants.FIRST_WIDTH);
 chart.setLineAttribute(lineAttr);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSelected(boolean)"><!-- --></A><H3>
setSelected</H3>
<PRE>
public void <B>setSelected</B>(boolean&nbsp;isSelected)</PRE>
<DL>
<DD>设置图表的选取状态。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>isSelected</CODE> - 布尔型值，
 若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();
 if(!chart.isSelected())
 {
     chart.setSelected(false);
 }
 System.out.println("isSelect:" + chart.isSelected()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSeriesByRow(boolean)"><!-- --></A><H3>
setSeriesByRow</H3>
<PRE>
public void <B>setSeriesByRow</B>(boolean&nbsp;isRow)</PRE>
<DL>
<DD>设置图表系列是按行或按列生成。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>isRow</CODE> - 行列标志 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();
 chart.setSeriesByRow(true);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="setSourceData(java.lang.String, boolean)"><!-- --></A><H3>
setSourceData</H3>
<PRE>
public void <B>setSourceData</B>(java.lang.String&nbsp;rangeSource,
                          boolean&nbsp;flag)</PRE>
<DL>
<DD>设置图表数据源。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>rangeSource</CODE> - 图表数据源<DD><CODE>flag</CODE> - 布尔型值，按行按列标志，当为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();
 chart.setSourceData("='工作表1'!A5:E12", false);
 String ranges = chart.getSourceData();
 System.out.println("SourceData:" + ranges);
 </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当给定的区域地址错误或越界</DL>
</DD>
</DL>
<HR>

<A NAME="setTableAreaVisible(boolean)"><!-- --></A><H3>
setTableAreaVisible</H3>
<PRE>
public void <B>setTableAreaVisible</B>(boolean&nbsp;isShow)</PRE>
<DL>
<DD>图表工具条是否显示数据表。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>isShow</CODE> - 布尔型值，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();
 if(!chart.isTableAreaVisible())
 {
     chart.setTableAreaVisible(true);
 }
 System.out.println("showTable:" + chart.isTableAreaVisible());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="showLegend(boolean)"><!-- --></A><H3>
showLegend</H3>
<PRE>
public void <B>showLegend</B>(boolean&nbsp;isShow)</PRE>
<DL>
<DD>是否显示图例。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>isShow</CODE> - 布尔型值，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();
 chart.showLegend(true);
 </pre></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;下一个类</FONT></TD>
<TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2">
  <A HREF="../../../../index.html?application/workbooks/workbook/charts/Chart.html" target="_top"><B>框架</B></A>  &nbsp;
&nbsp;<A HREF="Chart.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>