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);