📄 chart.html
字号:
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setChartLocationInCell(java.lang.String, int, int)">setChartLocationInCell</A></B>(java.lang.String sheetName,
int row,
int column)</CODE>
<BR>
将图表插入到指定的单元格中。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setChartLocationInSheet(java.lang.String)">setChartLocationInSheet</A></B>(java.lang.String sheetName)</CODE>
<BR>
将图表放到指定的工作表上面。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setChartType(int, int)">setChartType</A></B>(int type,
int subType)</CODE>
<BR>
设置图表的类型。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setFillAttribute(application.workbooks.workbook.style.fill.FillAttribute)">setFillAttribute</A></B>(<A HREF="../../../../application/workbooks/workbook/style/fill/FillAttribute.html" title="application.workbooks.workbook.style.fill 中的类">FillAttribute</A> fillAttr)</CODE>
<BR>
设置填充属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setFontAttribute(application.workbooks.workbook.style.font.FontAttribute)">setFontAttribute</A></B>(<A HREF="../../../../application/workbooks/workbook/style/font/FontAttribute.html" title="application.workbooks.workbook.style.font 中的类">FontAttribute</A> fontAttribute)</CODE>
<BR>
设置字体属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setHasCorner(boolean)">setHasCorner</A></B>(boolean hasCorner)</CODE>
<BR>
设置图表是否有圆角效果。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setHasShadow(boolean)">setHasShadow</A></B>(boolean hasShadow)</CODE>
<BR>
设置是否有阴影。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setLineAttribute(application.workbooks.workbook.charts.chart.LineAttribute)">setLineAttribute</A></B>(application.workbooks.workbook.charts.chart.LineAttribute lineAttr)</CODE>
<BR>
设置边框属性。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setSelected(boolean)">setSelected</A></B>(boolean isSelected)</CODE>
<BR>
设置图表的选取状态。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setSeriesByRow(boolean)">setSeriesByRow</A></B>(boolean isRow)</CODE>
<BR>
设置图表系列是按行或按列生成。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setSourceData(java.lang.String, boolean)">setSourceData</A></B>(java.lang.String rangeSource,
boolean flag)</CODE>
<BR>
设置图表数据源。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#setTableAreaVisible(boolean)">setTableAreaVisible</A></B>(boolean isShow)</CODE>
<BR>
图表工具条是否显示数据表。</TD>
</TR>
<TR BGCOLOR="white" CLASS="TableRowColor">
<TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1">
<CODE> void</CODE></FONT></TD>
<TD><CODE><B><A HREF="../../../../application/workbooks/workbook/charts/Chart.html#showLegend(boolean)">showLegend</A></B>(boolean isShow)</CODE>
<BR>
是否显示图例。</TD>
</TR>
</TABLE>
<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>
<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="addChartListener(application.event.ChartListener)"><!-- --></A><H3>
addChartListener</H3>
<PRE>
public void <B>addChartListener</B>(<A HREF="../../../../application/event/ChartListener.html" title="application.event 中的接口">ChartListener</A> 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="addTitle(int, java.lang.String)"><!-- --></A><H3>
addTitle</H3>
<PRE>
public void <B>addTitle</B>(int titleType,
java.lang.String text)</PRE>
<DL>
<DD>添加标题。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>titleType</CODE> - 为整型数值<DD><CODE>text</CODE> - 标题名称 <pre> ChartConstants.CHART_TITLE 图表标题 ChartConstants.X_TITLE 图表X轴标题 ChartConstants.Y_TITLE 图表Y轴标题 ChartConstants.XSCALE_TITLE 图表X轴刻度标题 ChartConstants.YSCALE_TITLE 图表Y轴刻度标题 ChartConstants.SECOND_Y_TITLE 图表Y次轴刻度标题 </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()); Chart chart = charts.getActiveChart(); chart.addTitle(ChartConstants.CHART_TITLE, "chart"); </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> - 当标题内容的长度已超出范围(128)<DT><B>另请参见：</B><DD><A HREF="../../../../application/constants/ChartConstants.html" title="application.constants 中的接口"><CODE>ChartConstants</CODE></A></DL>
</DD>
</DL>
<HR>
<A NAME="applyChartStyle(int)"><!-- --></A><H3>
applyChartStyle</H3>
<PRE>
public void <B>applyChartStyle</B>(int style)</PRE>
<DL>
<DD>应用图表样式。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>style</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.applyChartStyle(5); </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当参数越界</DL>
</DD>
</DL>
<HR>
<A NAME="applyChartTemplate(java.lang.String)"><!-- --></A><H3>
applyChartTemplate</H3>
<PRE>
public void <B>applyChartTemplate</B>(java.lang.String templateFileName)</PRE>
<DL>
<DD>应用图表模板。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>templateFileName</CODE> - 自定义图表模板名称。取“图表向导--图表模板”中图表的名称，也可以是自定义图表模板的路径。 如指定的图表名称不存在，则抛出异常。 <p> <b>例子：</b> <pre> //对图表应用图表模板"D:\\ChartTemplates\\渐蓝饼图.ect"。 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.applyChartTemplate("D:\\ChartTemplates\\渐蓝饼图.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="floatChartInToCell(int, int)"><!-- --></A><H3>
floatChartInToCell</H3>
<PRE>
public void <B>floatChartInToCell</B>(int row,
int 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="floatChartInToCell(java.lang.String, int, int)"><!-- --></A><H3>
floatChartInToCell</H3>
<PRE>
public void <B>floatChartInToCell</B>(java.lang.String worksheetName,
int row,
int column)</PRE>
<DL>
<DD>把当前激活的浮动图表插入到指定工作表指定的单元格中。
<P>
<DD><DL>
<DT><B>参数：</B><DD><CODE>worksheetName</CODE> - 指定的工作表名称(若worksheetName为Null,表示当前工作表)<DD><CODE>row</CODE> - 指定插入的行<DD><CODE>column</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.floatChartInToCell("工作表2", 15, 7); </pre>
<DT><B>抛出：</B>
<DD><CODE><A HREF="../../../../application/exceptions/MacroRunException.html" title="application.exceptions 中的类">MacroRunException</A></CODE> - 当名称无效</DL>
</DD>
</DL>
<HR>
<A NAME="getBottomLocation()"><!-- --></A><H3>
getBottomLocation</H3>
<PRE>
public java.lang.String <B>getBottomLocation</B>()</PRE>
<DL>
<DD>获得图表右下角的位置，如"G7"
<P>
<DD><DL>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -