手抄报 安全手抄报 手抄报内容 手抄报图片 英语手抄报 清明节手抄报 节约用水手抄报

C# 在Excel中添加带箭头的线条形状

时间:2024-10-18 17:12:13

以下经验内容中,将介绍添加带箭头的线条形状的方法。通过将这些线条形状应用到表坼黉赞楞格,可起到特定指示、连接或转换的作用。具体方法可参考以下C#示例代码。

工具/原料

Spire.XLS for .NET 9.9.0

Visual Studio

文件获取及dll引用:

1、方法1:通过E-iceblue官网下载文件包。下载后,解压文件。将bin文件夹中的Spire.Xls.dll文件添加引用到C# 程序。如下图:

C# 在Excel中添加带箭头的线条形状

2、方法2:可通过Nuget下载。

C#代码示例(供参考)

1、using Spire.Xls;using System.Drawing;namespace AddLines_XLS{ class Program { static 即枢潋雳void Main(string[] args) { //创建workbook类的实例,并获取第一张工作表 Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; //添加水平方向带箭头的线条,并设置线条颜色 var line1 = sheet.TypedLines.AddLine(); line1.Top = 10; line1.Left = 20; line1.Width = 100; line1.Height = 0; line1.Color = Color.Blue; line1.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrow; var line11 = sheet.TypedLines.AddLine(); line11.Top = 40; line11.Left = 20; line11.Width = 100; line11.Height = 0; line11.Color = Color.Blue; line11.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; var line111 = sheet.TypedLines.AddLine(); line111.Top = 70; line111.Left = 20; line111.Width = 100; line111.Height = 0; line111.Color = Color.Blue; line111.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrow; line111.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; //插入倾斜的带箭头的线条,并设置线条颜色 var line_1 = sheet.TypedLines.AddLine(); line_1.Top = 10; line_1.Left = 140; line_1.Width = 60; line_1.Height = 50; line_1.Color = Color.Red; line_1.BeginArrowHeadStyle = ShapeArrowStyleType.LineNoArrow; line_1.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; var line_2 = sheet.TypedLines.AddLine(); line_2.Top = 10; line_2.Left = 180; line_2.Width = 60; line_2.Height = 50; line_2.Color = Color.Red; line_2.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrow; line_2.EndArrowHeadStyle = ShapeArrowStyleType.LineNoArrow; var line_3 = sheet.TypedLines.AddLine(); line_3.Top = 10; line_3.Left = 220; line_3.Width = 60; line_3.Height = 50; line_3.Color = Color.Red; line_3.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrow; line_3.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; //插入肘形箭头连接符 Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape line3 = sheet.TypedLines.AddLine() as Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape; line3.LineShapeType = LineShapeType.ElbowLine; line3.Width = 30; line3.Height = 50; line3.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; line3.Top = 100; line3.Left = 50; Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape line2 = sheet.TypedLines.AddLine() as Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape; line2.LineShapeType = LineShapeType.ElbowLine; line2.Top = 100; line2.Left = 100; line2.Width = 50; line2.Height = 50; line2.EndArrowHeadStyle = ShapeArrowStyleType.LineArrow; line2.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrow; //插入曲线箭头连接符 line3 = sheet.TypedLines.AddLine() as Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape; line3.LineShapeType = LineShapeType.CurveLine; line3.Top = 100; line3.Left = 170; line3.Width = 30; line3.Height = 50; line3.EndArrowHeadStyle = ShapeArrowStyleType.LineArrowOpen; line2 = sheet.TypedLines.AddLine() as Spire.Xls.Core.Spreadsheet.Shapes.XlsLineShape; line2.LineShapeType = LineShapeType.CurveLine; line2.Top = 100; line2.Left = 230; line2.Width = 30; line2.Height = 50; line2.EndArrowHeadStyle = ShapeArrowStyleType.LineArrowOpen; line2.BeginArrowHeadStyle = ShapeArrowStyleType.LineArrowOpen; //保存文档 workbook.SaveToFile("AddLines.xlsx", ExcelVersion.Version2013); } }}

2、箭头线条形状添加效果:

C# 在Excel中添加带箭头的线条形状
© 手抄报圈