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中添加带箭头的线条形状
  • jquery如何获取页面所有a标签的链接名称
  • 使用Visual Studio Code发布项目到GitHub上
  • 使用Linux vi/vim编辑器永久设置行号,语法高亮
  • 如何在Ubuntu下安装并且创建django项目
  • java字符串数组中是否包含元素,忽略大小写
  • 热门搜索
    个人如何缴纳社保 有了番号怎么下载 兰芝睡眠面膜怎么用 如何保护地球 微信朋友圈如何只发文字 秦城监狱在哪里 信用卡怎么开通网银 哈弗h6发动机怎么样 排卵测试纸怎么用 粤t是哪里的车牌