title: Hyperlink to a cell on another workbook - EPPlus
body: <p>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.  </p>
  
  <p>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.  </p>
  
  <p>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.</p>
  
  <p>This works:  </p>
  
  <pre><code>resultSheet.Cells[currentRow, 10].Hyperlink = new Uri(message.myReference.filePath, UriKind.Absolute);
  </code></pre>
  
  <p>This doesn't work until clicking on modify and then ok on the generated Excel file.  </p>
  
  <pre><code>resultSheet.Cells[currentRow, 10].Hyperlink = new Uri(message.myReference.filePath + "#'" + message.myReference.sheetName + "'!" + "A" + message.myReference.cellRow, UriKind.Absolute);
  </code></pre>
  
  <p>I would really appreciate any kind of help because I'm kinda stuck on this silly issue. </p>