Hyperlink to a cell on another workbook - EPPlus

Question

I want to add an hyperlink to a cell of another workbook. I am able to refer the whole file but I have issues when referring an specific cell.

The generated hyperlink is well formed because when I click on modify hyperlink and then OK (without modifying it) on the generated Excel file then the hyperlink starts to work.

I have already tried with all the constructors of Uri, I tried to calculate the cell value but I don't find the solution. Here's my code.

This works:

resultSheet.Cells[currentRow, 10].Hyperlink = new Uri(message.myReference.filePath, UriKind.Absolute);

This doesn't work until clicking on modify and then ok on the generated Excel file.

resultSheet.Cells[currentRow, 10].Hyperlink = new Uri(message.myReference.filePath + "#'" + message.myReference.sheetName + "'!" + "A" + message.myReference.cellRow, UriKind.Absolute);

I would really appreciate any kind of help because I'm kinda stuck on this silly issue.

score 1 · Answer 1 · answered May 04 '17 at 06:48

1

I've tried using the Interop library and this works for me. Maybe you can use a similar sort of logic or idea.

Range whereHyperLinkWillBe = activeWorksheet.get_Range("O3", Type.Missing);
string filePathOfHyerlinkDestination = "C:\\Users\\Desktop\\HyerlinkFile.xlsx";
string hyperlinkTargetAddress = "Sheet1!B4";
activeWorksheet.Hyperlinks.Add(whereHyperLinkWillBe, filePathOfHyerlinkDestination ,hyperlinkTargetAddress, "Hyperlink Sample", "Hyperlink Title");

answered May 04 '17 at 06:48

hackslash47

71
5

Thanks for your help! I found a solution by manually creating the hyperlink formula using EPPlus and I will post it during the day :) – Pablo Maldonado May 04 '17 at 09:43
@PabloMaldonado Awesome! Good job! – hackslash47 May 04 '17 at 11:48

score 1 · Answer 2 · answered Apr 02 '19 at 02:37

1

The official method is to use new ExcelHyperLink(), see

ws.Cells["K13"].Hyperlink = new ExcelHyperLink("Statistics!A1", "Statistics");

https://github.com/JanKallman/EPPlus/wiki/Formatting-and-styling

answered Apr 02 '19 at 02:37

LoJo

142
2
11

score 0 · Accepted Answer · answered May 04 '17 at 11:50

So I found the answer, I was able to do it by using the formula attribute of the cell as follow by adding the hyperlink reference and the value that I wanted to show on the cell:

resultSheet.Cells[currentRow, 10].Formula = "HYPERLINK(\"" + filePath + "#'" + sheetName + "'!" + rowLetter + rowNumber + "\",\"" + "message to show on the cell" + "\")";
resultSheet.Cells[currentRow, 10].Calculate();

Hyperlink to a cell on another workbook - EPPlus

3 Answers3