没有找到合适的产品?
联系客服协助选型:023-68661681
提供3000多款全球软件/控件产品
针对软件研发的各个阶段提供专业培训与技术咨询
根据客户需求提供定制化的软件开发服务
全球知名设计软件,显著提升设计质量
打造以经营为中心,实现生产过程透明化管理
帮助企业合理产能分配,提高资源利用率
快速打造数字化生产线,实现全流程追溯
生产过程精准追溯,满足企业合规要求
以六西格玛为理论基础,实现产品质量全数字化管理
通过大屏电子看板,实现车间透明化管理
对设备进行全生命周期管理,提高设备综合利用率
实现设备数据的实时采集与监控
利用数字化技术提升油气勘探的效率和成功率
钻井计划优化、实时监控和风险评估
提供业务洞察与决策支持实现数据驱动决策
原创|使用教程|编辑:龚雪|2015-08-27 09:22:25.000|阅读 1204 次
概述:Aspose.Words使用教程之从零创建OOXML图表
# 界面/图表报表/文档/IDE等千款热门软控件火热销售中 >>
相关链接:
文档类已经添加进了新的插入图表方法,所以,让我们看看如何使用DocumentBuilder.InsertChart方法将一个简单的列图表插入到文档。
如下所示:
C#
Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Add chart with default data. You can specify different chart types and sizes. Shape shape = builder.InsertChart(ChartType.Column, 432, 252); // Chart property of Shape contains all chart related options. Chart chart = shape.Chart; // Get chart series collection. ChartSeriesCollection seriesColl = chart.Series; // Delete default generated series. seriesColl.Clear(); // Create category names array, in this example we have two categories. string[] categories = new string[] { "AW Category 1", "AW Category 2" }; // Adding new series. Please note, data arrays must not be empty and arrays must be the same size. seriesColl.Add("AW Series 1", categories, new double[] { 1, 2 }); seriesColl.Add("AW Series 2", categories, new double[] { 3, 4 }); seriesColl.Add("AW Series 3", categories, new double[] { 5, 6 }); seriesColl.Add("AW Series 4", categories, new double[] { 7, 8 }); seriesColl.Add("AW Series 5", categories, new double[] { 9, 10 }); doc.Save(MyDir + @"TestInsertChartColumn.docx");
Visual Basic
Dim doc As New Document() Dim builder As New DocumentBuilder(doc) ' Add chart with default data. You can specify different chart types and sizes. Dim shape As Shape = builder.InsertChart(ChartType.Column, 432, 252) ' Chart property of Shape contains all chart related options. Dim chart As Chart = shape.Chart ' Get chart series collection. Dim seriesColl As ChartSeriesCollection = chart.Series ' Delete default generated series. seriesColl.Clear() ' Create category names array, in this example we have two categories. Dim categories() As String = {"AW Category 1", "AW Category 2"} ' Adding new series. Please note, data arrays must not be empty and arrays must be the same size. seriesColl.Add("AW Series 1", categories, New Double() {1, 2}) seriesColl.Add("AW Series 2", categories, New Double() {3, 4}) seriesColl.Add("AW Series 3", categories, New Double() {5, 6}) seriesColl.Add("AW Series 4", categories, New Double() {7, 8}) seriesColl.Add("AW Series 5", categories, New Double() {9, 10}) doc.Save(MyDir & "TestInsertChartColumn.docx")
这段代码会产生如下结果:
有四种不同的加载添加方法:
1.插入列图表
C#
Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert Column chart. Shape shape = builder.InsertChart(ChartType.Column, 432, 252); Chart chart = shape.Chart; // Use this overload to add series to any type of Bar, Column, Line and Surface charts. chart.Series.Add("AW Series 1", new string[] { "AW Category 1", "AW Category 2" }, new double[] { 1, 2 }); doc.Save(MyDir + @"TestInsertColumnChart.docx");
Visual Basic
Dim doc As New Document() Dim builder As New DocumentBuilder(doc) ' Insert Column chart. Dim shape As Shape = builder.InsertChart(ChartType.Column, 432, 252) Dim chart As Chart = shape.Chart ' Use this overload to add series to any type of Bar, Column, Line and Surface charts. chart.Series.Add("AW Series 1", New string() { "AW Category 1", "AW Category 2" }, New Double() { 1, 2 }) doc.Save(MyDir & "TestInsertColumnChart.docx")
结果如下:
2.插入散点图
C#
Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert Scatter chart. Shape shape = builder.InsertChart(ChartType.Scatter, 432, 252); Chart chart = shape.Chart; // Use this overload to add series to any type of Scatter charts. chart.Series.Add("AW Series 1", new double[] { 0.7, 1.8, 2.6 }, new double[] { 2.7, 3.2, 0.8 }); doc.Save(MyDir + @"TestInsertScatterChart.docx");
Visual Basic
Dim doc As New Document() Dim builder As New DocumentBuilder(doc) ' Insert Scatter chart. Dim shape As Shape = builder.InsertChart(ChartType.Scatter, 432, 252) Dim chart As Chart = shape.Chart ' Use this overload to add series to any type of Scatter charts. chart.Series.Add("AW Series 1", New Double() {0.7, 1.8, 2.6}, New Double() {2.7, 3.2, 0.8}) doc.Save(MyDir & "TestInsertScatterChart.docx")
结果如下:
3.插入面积图
C#
Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert Area chart. Shape shape = builder.InsertChart(ChartType.Area, 432, 252); Chart chart = shape.Chart; // Use this overload to add series to any type of Area, Radar and Stock charts. chart.Series.Add("AW Series 1", new DateTime[] { new DateTime(2002, 05, 01), new DateTime(2002, 06, 01), new DateTime(2002, 07, 01), new DateTime(2002, 08, 01), new DateTime(2002, 09, 01)}, new double[] { 32, 32, 28, 12, 15 }); doc.Save(MyDir + @"TestInsertAreaChart.docx");
Visual Basic
Dim doc As New Document() Dim builder As New DocumentBuilder(doc) ' Insert Area chart. Dim shape As Shape = builder.InsertChart(ChartType.Area, 432, 252) Dim chart As Chart = shape.Chart ' Use this overload to add series to any type of Area, Radar and Stock charts. chart.Series.Add("AW Series 1", New DateTime() {New DateTime(2002, 5, 1), New DateTime(2002, 6, 1), New DateTime(2002, 7, 1), New DateTime(2002, 8, 1), New DateTime(2002, 9, 1)}, New Double() {32, 32, 28, 12, 15}) doc.Save(MyDir & "TestInsertAreaChart.docx")
结果如下:
4.插入气泡式图表
C#
Document doc = new Document(); DocumentBuilder builder = new DocumentBuilder(doc); // Insert Bubble chart. Shape shape = builder.InsertChart(ChartType.Bubble, 432, 252); Chart chart = shape.Chart; // Use this overload to add series to any type of Bubble charts. chart.Series.Add("AW Series 1", new double[] { 0.7, 1.8, 2.6 }, new double[] { 2.7, 3.2, 0.8 }, new double[] { 10, 4, 8 }); doc.Save(MyDir + @"TestInsertBubbleChart.docx");
Visual Basic
Dim doc As New Document() Dim builder As New DocumentBuilder(doc) ' Insert Bubble chart. Dim shape As Shape = builder.InsertChart(ChartType.Bubble, 432, 252) Dim chart As Chart = shape.Chart ' Use this overload to add series to any type of Bubble charts. chart.Series.Add("AW Series 1", New Double() {0.7, 1.8, 2.6}, New Double() {2.7, 3.2, 0.8}, New Double() {10, 4, 8}) doc.Save(MyDir & "TestInsertBubbleChart.docx")
结果如下:
本站文章除注明转载外,均为本站原创或翻译。欢迎任何形式的转载,但请务必注明出处、不得修改原文相关链接,如果存在内容上的异议请邮件反馈至chenjj@dpuzeg.cn
文章转载自:慧都控件网在 Excel 中,工作表名称通常能够反映其用途或所含内容,提取这些名称有助于理清整个工作簿的结构。对于新用户或协作者来说,仅凭这些名称就能快速掌握各表中的数据类型。本文将演示如何使用 Java 获取 Excel 文件中的所有工作表名称,帮助你更高效地管理和理解工作簿数据。
本文主要介绍如何使用DevExpress WPF Grid控件中如何获取行句柄,欢迎下载最新版组件体验!
Microsoft Excel 允许您通过选择数据透视表,然后单击“插入”>“时间轴”来创建时间轴。Aspose.Cells 则还可允许您使用Worksheet.Timelines.Add()方法创建时间轴 。
本教程演示DevExpress WinForms的Banded Grid View 是如何进行用户自定义的,欢迎下载最新版组件体验!
服务电话
重庆/ 023-68661681
华东/ 13452821722
华南/ 18100878085
华北/ 17347785263
客户支持
技术支持咨询服务
服务热线:400-700-1020
邮箱:sales@dpuzeg.cn
关注我们
地址 : 重庆市九龙坡区火炬大道69号6幢