We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

How to define an internal link in a cell?

Hello,

In one cell, I want to display a link to another sheet. Doing that using Excel 2007, I click on “Insert”, “Hyperlink”, and then in the popup, I select “Place in This Document”, and the Sheet name.
(cf. screenshot)

I want to achieve the exact same thing, but programmatically, using Aspose 7.0.1. How to do that?

Regards.

Hi,

Thanks for your posting.

Please see the following reference document to add internal link in a cell.
Adding Hyperlinks to Link Data

Hello,

Thanks for this reference. I finally found the solution just after posting my question ! Sorry for that.

The solution is:

mySheet.getHyperlinks().add(“A1”, 1, 1, “otherSheet!A1”);

Regards.

Hi,

Thats great you were able to find out the solution yourself.

Please feel free to post your any other question.