How to define an internal link in a cell?

Aspose.Cells Product Family
1

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.

2

Hi,

Thanks for your posting.

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

3

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.

4

Hi,

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

Please feel free to post your any other question.