C# 创建EXCEL图表并保存为图片的实例

using Spire.Xls;using System.Drawing;using System.Drawing.Imaging;namespace CreateChart_XLS{ class Program { static void Main(string[] args) {  //创建一个Workbook类实例，加载Excel文档  Workbook workbook = new Workbook();  workbook.LoadFromFile(@"C:/Users/Administrator/Desktop/Sample.xlsx");  //获取第一个工作表  Worksheet sheet = workbook.Worksheets[0];  //设置工作表的名称  sheet.Name = "柱状图";  sheet.GridLinesVisible = false;  //创建柱状图  Chart chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);  //指定用于生成图表的数据区域  chart.DataRange = sheet.Range["A2:G6"];  chart.SeriesDataFromRange = false;  //指定图表所在的位置  chart.LeftColumn = 1;  chart.TopRow = 9;  chart.RightColumn = 12;  chart.BottomRow = 26;  //设置图表的名称及字体格式  chart.ChartTitle = "上半年产品销售情况(单位：万美元)";  chart.ChartTitleArea.IsBold = true;  chart.ChartTitleArea.Size = 12;  //设置X轴坐标名称及字体格式  chart.PrimaryCategoryAxis.Title = "产品类别";  chart.PrimaryCategoryAxis.Font.IsBold = true;  chart.PrimaryCategoryAxis.TitleArea.IsBold = false;    //设置Y轴坐标名称及字体格式  chart.PrimaryValueAxis.Title = "销售额";    chart.PrimaryValueAxis.HasMajorGridLines = false;  chart.PrimaryValueAxis.TitleArea.TextRotationAngle = 90;  chart.PrimaryValueAxis.MinValue = 0.5;  chart.PrimaryValueAxis.TitleArea.IsBold = false;  //设置图例的位置  chart.Legend.Position = LegendPositionType.Right;  //保存文档  workbook.SaveToFile("ColumnChart.xlsx", ExcelVersion.Version2013);  //加载生成图表后的Excel文档  workbook.LoadFromFile("ColumnChart.xlsx");  //遍历工作簿，诊断是否包含图表  Image[] images = workbook.SaveChartAsImage(sheet);  for (int i = 0; i < images.Length; i++)  {   //将图表保存为图片   images[i].Save(string.Format("img-{0}.png", i), ImageFormat.Png);  } } }}