none
How to add hyperlink to the sheet inside excel? RRS feed

  • Question

  • I am new to Excel, I want to know it;s possible to add hyperlink to sheet inside this Excel? eg, I have 10 sheet of content,and the 11th sheet is for links of the previous 10 sheets, when i add corresponding  link cell the excel jump directly to the sheet. I use Excel 2013 and C# language.

    Thank you!

     
    Friday, June 12, 2015 7:56 AM

Answers

  • Using Excel Interop in c#, example
    "A20:A20" is the location of the link.
    "FAQ"is the name of the target worksheet.
    "A20"is the cell that after clicking the link, Excel will set the cursor to.
    Just change the target separately for your needs.

    var range = GetRange("A20:A20");
                range.Cells.Hyperlinks.Add(range,"#FAQ!A20", Type.Missing, "TEST LINK TOOLTIP", "TEST LINK");
     
    
                private Excel.Range GetRange(object cell1)
                {
                      return (Excel.Range)worksheet.get_Range(cell1);
                }

    Old post here:
    http://www.experts-exchange.com/Programming/Languages/.NET/Q_27912390.html
    Another way you can refer this article: Add Excel Hyperlinks in C#

    • Marked as answer by L.HlModerator Wednesday, June 24, 2015 11:33 PM
    Friday, June 12, 2015 7:59 AM