How to add a reference to an external Sheet?

May 28, 2013 at 12:15 PM
I'm creating a workbook and need the formula

='C:\Rmv\API\ddl\Rmv.xla'!blp(A" + i + ";$B$1)

in some cells (i is my iterator, of course). I figured out that excel itself saves links to external files by storing the path to the file itself in externalLink.xml and the name of the sheet in the external file as another reference.

How can I create such a link in EPPlus? Thank you for input / examples, best regards from Germany, Dirk
May 28, 2013 at 1:57 PM
Hm I guess this is currently not possible with EPPlus, at least not easy.