C# Excel添加超链接

Posted on 2014-09-24 17:20  且行且歌  阅读(224)  评论(0编辑  收藏  举报

操作当前单元格(关键代码就两行)

Range range = (Range)ExSheet.Cells[i + 2, j + 1];                                                 //要添加的单元格位置
sheet.Hyperlinks.Add(range, "http://blog.sina.com.cn/u/2086403861", Missing.Value, Missing.Value, Missing.Value);                       //添加超链接

Copyright © 2024 且行且歌
Powered by .NET 8.0 on Kubernetes