指向另一个工作表中的单元格的EPPlus超链接

using OfficeOpenXml;
using System.IO;

var fileInfo = new FileInfo("example.xlsx");
using (var package = new ExcelPackage(fileInfo))
{
    var sheet1 = package.Workbook.Worksheets.Add("Sheet1");
    var sheet2 = package.Workbook.Worksheets.Add("Sheet2");
    
    // 接下来，添加数据和超链接
}

sheet1.Cells["A1"].Value = "Go to Sheet2 A1";
sheet2.Cells["A1"].Value = "Hello, this is Sheet2!";

// 创建一个指向 Sheet2 的 A1 单元格的超链接
sheet1.Cells["A1"].Hyperlink = new Uri("'Sheet2'!A1", UriKind.Relative);
sheet1.Cells["A1"].Style.Font.UnderLine = true;
sheet1.Cells["A1"].Style.Font.Color.SetColor(System.Drawing.Color.Blue);

package.Save();

using OfficeOpenXml;
using System.IO;

class Program
{
    static void Main()
    {
        var fileInfo = new FileInfo("example.xlsx");
        using (var package = new ExcelPackage(fileInfo))
        {
            var sheet1 = package.Workbook.Worksheets.Add("Sheet1");
            var sheet2 = package.Workbook.Worksheets.Add("Sheet2");

            // 添加数据
            sheet1.Cells["A1"].Value = "Go to Sheet2 A1";
            sheet2.Cells["A1"].Value = "Hello, this is Sheet2!";

            // 添加超链接
            sheet1.Cells["A1"].Hyperlink = new Uri("'Sheet2'!A1", UriKind.Relative);
            sheet1.Cells["A1"].Style.Font.UnderLine = true;
            sheet1.Cells["A1"].Style.Font.Color.SetColor(System.Drawing.Color.Blue);

            // 保存
            package.Save();
        }
    }
}