ExcelCell.Hyperlink - non-Uri links

Topics: Developer Forum, User Forum
Jan 30, 2008 at 10:48 PM
Is it possible to set a cell hyperlink to another worksheet in the same workbook?

For example - sheet1, sheet2; cell A1 in sheet1 references cell A1 in sheet2 (hyperlink = sheet2!A1)
Jan 5, 2010 at 8:59 PM

yeah,i just figured out how to do it...

 

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

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

 

this is the code!!!