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[];

             //设置工作表的名称

             sheet.Name = "柱状图";

             sheet.GridLinesVisible = false;

             //创建柱状图

             Chart chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);

             //指定用于生成图表的数据区域

             chart.DataRange = sheet.Range["A2:G6"];

             chart.SeriesDataFromRange = false;

             //指定图表所在的位置

             chart.LeftColumn = ;

             chart.TopRow = ;

             chart.RightColumn = ;

             chart.BottomRow = ;

             //设置图表的名称及字体格式

             chart.ChartTitle = "上半年产品销售情况(单位：万美元)";

             chart.ChartTitleArea.IsBold = true;

             chart.ChartTitleArea.Size = ;

             //设置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 = ;

             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 = ; i < images.Length; i++)

               {

                  //将图表保存为图片

                   images[i].Save(string.Format("img-{0}.png", i), ImageFormat.Png);

                }

         }

     }

 }