Hyperlink When You Don't Know Worksheet Path

Apr 16, 2012 at 9:07 PM

Hey Guys,

I saw the hyperlink discussions but none of them were of any help. 

Scenario: I create a spreadsheet from scratch. (2 worksheets).

I want Sheet 1.Cell (A1) to have a hyperlink to Sheet 2.Cell(A1)

Since I'm building the worksheet on the server then sending it for download I do not know the path or file name.

Anyone have any ideas?

 

Thanks for your help in advance.

 

the discussion I found below would not work because I need some type of relative path. (http://excelpackage.codeplex.com/discussions/78953)

string hyperlink = (@"file:///c:\poc\sample1.xlsx#'Sheet2'!A1");

worksheet.Cell(row,column).Hyperlink = new Uri(hyperlink, UriKind.RelativeOrAbsolute);