c#读取excel内容并画出图表作用多种图例

Question

如题所述

Answer 1

可以通过下面的代码示例方法参考如何在C#程序中创建Excel图表，可选择图表类型，图例样式设置等：

using System;

using Spire.Xls;

using System.Drawing.Imaging;

using System.Drawing;

namespace ExplodePieChart

{

class Program

{

static void Main(string[] args)

{

//加载Excel文档

Workbook workbook = new Workbook();

workbook.LoadFromFile("test.xlsx");

//获取工作表

Worksheet ws = workbook.Worksheets[0];

//创建饼状图表

Chart chart = ws.Charts.Add(ExcelChartType.Pie);

chart.DataRange = ws.Range["B2:B6"];

chart.SeriesDataFromRange = false;

chart.LeftColumn = 1;

chart.TopRow = 7;

chart.RightColumn = 9;

chart.BottomRow = 26;

chart.ChartTitle = "年销售额";

chart.ChartTitleArea.IsBold = true;

chart.ChartTitleArea.Size = 12;

Spire.Xls.Charts.ChartSerie cs = chart.Series[0];

cs.CategoryLabels = ws.Range["A2:A6"];

cs.Values = ws.Range["B2:B6"];

cs.DataPoints.DefaultDataPoint.DataLabels.HasValue = true;

chart.PlotArea.Fill.Visible = false;

//设置图例

chart.HasLegend = true;

chart.Legend.Position = LegendPositionType.Right;

chart.Legend.FrameFormat.Fill.FillType = ShapeFillType.SolidColor;

chart.Legend.FrameFormat.Fill.ForeColor = Color.LightPink;          

//设置饼图整体分离程度

for (int i = 0; i < chart.Series.Count; i++)

{

chart.Series[i].DataFormat.Percent = 20;

}

//保存生成的excel文档

workbook.SaveToFile("ExplodePieChart.xlsx",ExcelVersion.Version2013);

System.Diagnostics.Process.Start("ExplodePieChart.xlsx");

运行程序后，就可以生成含图表的excel文档，可在项目文件夹Debug下查看，

图表效果