创建超链接

https://blog.51cto.com/u_15926533/5987872

 

            // 获取要创建链接的Sheet
            Excel.Worksheet sheet1 = workbook.Worksheets["Sheet1"];
            Excel.Worksheet sheet2 = workbook.Worksheets["Sheet2"];

            // 创建Sheet2的链接
            Excel.Hyperlink hyperlink = sheet1.Hyperlinks.Add(
                sheet1.Range["G1"], // 超链接要放在哪个单元格
                "", // 默认显示的文本，这里为空
                sheet2.Name + "!A1", // 要跳转的Sheet和单元格
                "点我跳转到Sheet2" // 鼠标悬停时显示的提示信息
            );

 

 

using Excel = Microsoft.Office.Interop.Excel;

// 创建超链接
public static void CreateHyperlink(Excel.Range cell, string linkAddress, string linkText)
{
    cell.Hyperlinks.Add(cell, linkAddress, Type.Missing, linkText, linkText);
}

// 返回链接
public static string GetHyperlinkAddress(Excel.Range cell)
{
    if (cell.Hyperlinks.Count > 0)
    {
        return cell.Hyperlinks[1].Address;
    }
    else
    {
        return null;
    }
}

 

 

 

Excel.Range cell = worksheet.Range["A2"];
worksheet.Hyperlinks.Add(cell, "", sheet1Address, Type.Missing, Type.Missing);