我在一個回圈了創建了四個單元格,并且對其賦值,然后對每個單元格添加同一個超鏈接,結果發現只有第四個超鏈接有效,各位大佬,該如何解決?
代碼如下:
namespace interfaceclass
{
class Program
{
static void Main(string[] args)
{
HSSFWorkbook wb = new HSSFWorkbook();
ISheet sh = wb.CreateSheet("zhiyuan");
HSSFHyperlink link1 = new HSSFHyperlink(HyperlinkType.File);
link1.Address = @"D:\\file\\automation\\measurement.jpg";
IRow row3 = sh.CreateRow(3);
int n=0;
for (n = 0; n < 4; n++)
{
ICell cell4 = row3.CreateCell(n + 1);
cell4.SetCellValue(n);
cell4.Hyperlink.Address = @"D:\\file\\automation\\measurement.jpg";
}
using (FileStream stm = File.OpenWrite(@"mylink.xls"))
{
wb.Write(stm);
Console.Write("OK");
}
}
}
}
uj5u.com熱心網友回復:
轉載請註明出處,本文鏈接:https://www.uj5u.com/net/119087.html
標籤:C#
下一篇:vs2012沒MySql資料源
