chart.html

永中OFFICE二次开发帮助文档

<DT><B>返回：</B><DD>图表右下角的位置
 <p>
 <b>例子：</b>
 <pre>
 //获得图表右下角的位置。
 Workbook book = Application.getWorkbooks().getActiveWorkbook();
 Charts charts = book.getCharts();
 Chart chart = charts.getActiveChart();
 System.out.println("图表右下角的位置 :" + chart.getBottomLocation());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getChartSubType()"><!-- --></A><H3>
getChartSubType</H3>
<PRE>
public int <B>getChartSubType</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();
 System.out.println("SubType:" + chart.getChartSubType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFillAttribute()"><!-- --></A><H3>
getFillAttribute</H3>
<PRE>
public <A HREF="../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A> <B>getFillAttribute</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();
 FillAttribute fill = chart.getFillAttribute();
 System.out.println("fill:" + fill);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getFontAttribute()"><!-- --></A><H3>
getFontAttribute</H3>
<PRE>
public <A HREF="../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A> <B>getFontAttribute</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();
 FontAttribute fontAttribute1 = chart.getFontAttribute();
 System.out.println("Bold:" + fontAttribute1.isBold());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getLineAttribute()"><!-- --></A><H3>
getLineAttribute</H3>
<PRE>
public application.workbooks.workbook.charts.chart.LineAttribute <B>getLineAttribute</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();
 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);
 chart.refresh();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getMainType()"><!-- --></A><H3>
getMainType</H3>
<PRE>
public int <B>getMainType</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();
 System.out.println("ChartType:" + chart.getMainType()); 
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getShapes()"><!-- --></A><H3>
getShapes</H3>
<PRE>
public <A HREF="../../../../application/workbooks/workbook/Shapes.html" title="application.workbooks.workbook 中的类">Shapes</A> <B>getShapes</B>()</PRE>
<DL>
<DD>获得自选图形管理器对象。
<P>
<DD><DL>

<DT><B>返回：</B><DD>自选图形管理器对象
 <p>
 <b>例子：</b>
 <pre>
 //把当前活动的浮动图表插入到工作表2的指定单元格中。
 Workbook book = Application.getWorkbooks().getActiveWorkbook();
 Charts charts = book.getCharts();
 Chart chart = charts.getActiveChart();
 Shapes shapes = chart.getShapes();
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getSourceData()"><!-- --></A><H3>
getSourceData</H3>
<PRE>
public java.lang.String <B>getSourceData</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();
 String ranges = chart.getSourceData();
 System.out.println("SourceData:" + ranges);
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="getTopLocation()"><!-- --></A><H3>
getTopLocation</H3>
<PRE>
public java.lang.String <B>getTopLocation</B>()</PRE>
<DL>
<DD>获得图表左上角的位置，如"B3"
<P>
<DD><DL>

<DT><B>返回：</B><DD>图表左上角的位置
 <p>
 <b>例子：</b>
 <pre>
 //获得图表左上角的位置。
 Workbook book = Application.getWorkbooks().getActiveWorkbook();
 Charts charts = book.getCharts();
 Chart chart = charts.getActiveChart();
 System.out.println("图表左上角的位置 :" + chart.getTopLocation());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasCorner()"><!-- --></A><H3>
hasCorner</H3>
<PRE>
public boolean <B>hasCorner</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();
 if(!chart.hasCorner())
 {
     chart.setHasCorner(true);
 }
 chart.refresh();
 System.out.println("hasCorner:" + chart.hasCorner());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="hasShadow()"><!-- --></A><H3>
hasShadow</H3>
<PRE>
public boolean <B>hasShadow</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();
 if(!chart.hasShadow())
 {
     chart.setHasShadow(true);
 }
 book.getWorksheets().getActiveWorksheet().refresh();
 System.out.println("hasShadow:" + chart.hasShadow());
 </pre></DL>
</DD>
</DL>
<HR>

<A NAME="isLegendVisible()"><!-- --></A><H3>
isLegendVisible</H3>
<PRE>
public boolean <B>isLegendVisible</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();
 System.out.println(chart.isLegendVisible());
 </pre></DL>
</DD>
</DL>
<HR>