C# 插入图形（shape）到Excel文档

1、下载安装该类库后，注意在项目程序中添加引用Spire.Xls.dll文件（dll文件可在安装路径下的Bin文件夹中获取）

1、using System.Drawing;

using Spire.Xls;

using Spire.Xls.Core;

namespace Add_shapes_to_Excel

{

    class Program

    {

        static void Main(string[] args)

        {

            //创建实例

            Workbook workbook = new Workbook();

            //获取第一个工作表

            Worksheet sheet = workbook.Worksheets[0];

            //添加“太阳”形状的图形，并填充颜色

            IPrstGeomShape Triangle = sheet.PrstGeomShapes.AddPrstGeomShape(2, 2, 170, 160, PrstGeomShapeType.Sun);

            Triangle.Fill.ForeColor = Color.Orange;

            Triangle.Fill.FillType = ShapeFillType.SolidColor;            

            Triangle.Text = "IT'S A SUNNY DAY";//添加文本

            //添加“禁止”标志的图形，并填充渐变颜色

            IPrstGeomShape heart = sheet.PrstGeomShapes.AddPrstGeomShape(2, 7, 140, 140, PrstGeomShapeType.NoSmoking);

            heart.Fill.ForeColor = Color.Red;

            heart.Fill.FillType = ShapeFillType.Gradient;

            //添加云朵形状的图形

            IPrstGeomShape Cloud = sheet.PrstGeomShapes.AddPrstGeomShape(15, 2, 160, 160, PrstGeomShapeType.Cloud);          

            //设置图形阴影效果

            Cloud.Shadow.Angle = 90;

            Cloud.Shadow.Distance = 10;

            Cloud.Shadow.Size = 100;

            Cloud.Shadow.Color = Color.SteelBlue;

            Cloud.Shadow.Blur = 30;

            Cloud.Shadow.Transparency = 1;

            Cloud.Shadow.HasCustomStyle = true;

            //添加五角星形状的图形，并加载图片来填充图形

            IPrstGeomShape cloud = sheet.PrstGeomShapes.AddPrstGeomShape(15, 7, 160, 160, PrstGeomShapeType.Star5);

            cloud.Fill.CustomPicture(Image.FromFile("sm.png"), "sm.png");

            cloud.Fill.FillType = ShapeFillType.Picture;

            //保存并打开文档

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

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

        }

    }

}

运行程序后，生成文档。形状添加效果如下图：

1、Spire.xls能支持的图形种类很多，常见的Office Excel中的图形，这个类库也都能实现，