//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; worksheet.Range["A:A"].ColumnWidth = 30; //add a hyperlink link to web page. worksheet.Range["A1:B2"].Hyperlinks.Add(worksheet.Range["A1"], "https://www.google.com/", null, "open google web site.", "Google"); //add a hyperlink link to a range in this document. worksheet.Range["A3:B4"].Hyperlinks.Add(worksheet.Range["A3"], null, "Sheet1!$C$3:$E$4", "Go to sheet1 C3:E4"); //add a hyperlink link to email address. worksheet.Range["A5:B6"].Hyperlinks.Add(worksheet.Range["A5"], "mailto:us.sales@mescius.com", null, "Send an email to sales", "Send an email to sales"); //add a hyperlink link to external file. //change the path to real picture file path. string path = "external.xlsx"; worksheet.Range["A7:B8"].Hyperlinks.Add(worksheet.Range["A7"], path, null, "link to external.xlsx file.", "External.xlsx"); // Save to an excel file workbook.Save("CreateHyperlinks.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) worksheet.Range("A:A").ColumnWidth = 30 'add a hyperlink link to web page. worksheet.Range("A1:B2").Hyperlinks.Add(worksheet.Range!A1, "https://www.google.com/", Nothing, "open google web site.", "Google") 'add a hyperlink link to a range in this document. worksheet.Range("A3:B4").Hyperlinks.Add(worksheet.Range!A3, Nothing, "Sheet1!$C$3:$E$4", "Go to sheet1 C3:E4") 'add a hyperlink link to email address. worksheet.Range("A5:B6").Hyperlinks.Add(worksheet.Range!A5, "mailto:us.sales@mescius.com", Nothing, "Send an email to sales", "Send an email to sales") 'add a hyperlink link to external file. 'change the path to real picture file path. Dim path As String = "external.xlsx" worksheet.Range("A7:B8").Hyperlinks.Add(worksheet.Range!A7, path, Nothing, "link to external.xlsx file.", "External.xlsx") ' save to an excel file workbook.Save("CreateHyperlinks.xlsx")