Free Support Forum - aspose.com

Hyperlink to named Range in same document

Aspose.Cells Product Family
#1

Hi,

at the documentation an internal Hyperlink will added like this:

worksheet.Hyperlinks.AddInternalLink("B3", 1 , 1, "Sheet2!B9");

(is this an old version? Now use only Add?)

but by creating the Hyperlink i don't now the row number at this time and i can't get the cell name,

so i want to use a named Range wich i generate later on (this is based on ids from db, so i know it).

Is this possible, i don't found anything at the forum or the documentation.

THX

Phil

#2

Only replace "B9" with the name of the range and its done.

#3

Hi Phil,

Thanks for considering Aspose.

Yes, Hyperlinks.AddInternalLink is obsoleted now. You may use Hyperlinks.Add() for adding internal and external hyperlinks for you need.

And yes, you may replace the address string with range name.

E.g..,

worksheet.Hyperlinks.AddInternalLink("B3", 1 , 1, "Range1");

If you require further help, feel free to contact us any time. And we will be glad to helping you.

Thank you.