C# 添加、删除Excel文本框

【C#】using Spire.Xls;using Spire.Xls.Core;using Spire.Xls.Core.Spreadsheet.Shapes;using System.Drawing; namespace AddTextBox_XLS{    class Program    {        static void Main(string[] args)        {            //加载Excel文档            Workbook workbook = new Workbook();            workbook.LoadFromFile('test.xlsx');             //获取第一个工作表            Worksheet sheet = workbook.Worksheets[0];             //插入第一个文本框并设置文本框位置和大小            ITextBox textBox = sheet.TextBoxes.AddTextBox(11, 1, 50, 230);             //设置文本框文本和对齐方式            textBox.Text = '人事部验核确认！（仅内部传阅）';            textBox.HAlignment = CommentHAlignType.Center;            textBox.VAlignment = CommentVAlignType.Center;             //设置文本框字体，颜色，大小            ExcelFont font = workbook.CreateFont();            font.FontName = 'Arial';            font.Size = 12;            font.IsBold = true;            font.Color = Color.Red;            (new RichText(textBox.RichText)).SetFont(0, textBox.Text.Length - 1, font);             //设置文本框背景色            XlsTextBoxShape shape = sheet.TextBoxes[0] as XlsTextBoxShape;            shape.Fill.FillType = ShapeFillType.SolidColor;            shape.Fill.ForeKnownColor = ExcelColors.White;             //插入第二个文本框并设置文本框位置和大小            ITextBoxShape shape2 = sheet.TextBoxes.AddTextBox(15, 1, 150, 150);             //加载图片并用图片填充文本框            shape2.Fill.CustomPicture('1.png');            shape2.Fill.FillType = ShapeFillType.Picture;             //获取第二个文本框            XlsTextBoxShape shape3 = sheet.TextBoxes[1] as XlsTextBoxShape;             //设置文本框边框为0            shape3.Line.Weight = 0;             //保存文档            workbook.SaveToFile('TextBox.xlsx', ExcelVersion.Version2013);            System.Diagnostics.Process.Start('TextBox.xlsx');        }    }}

【C#】 using Spire.Xls;using Spire.Xls.Core.Spreadsheet.Shapes; namespace RemoveTextBox_XLS{    class Program    {        static void Main(string[] args)        {            //加载Excel文档            Workbook workbook = new Workbook();            workbook.LoadFromFile('sample.xlsx');             //获取第一个工作表            Worksheet sheet = workbook.Worksheets[0];             //获取第二个文本框            XlsTextBoxShape textboxshape = sheet.TextBoxes[1] as XlsTextBoxShape;             //删除文本框            textboxshape.Remove();             //保存文档            workbook.SaveToFile('DeleteTextBox.xlsx', ExcelVersion.Version2013);            System.Diagnostics.Process.Start('DeleteTextBox.xlsx');        }    }}

安装该类库后，在项目中引用Spire.Xls.dll即可，dll文件可在安装路径下的Bin文件夹中获取