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.
I want to achieve the exact same thing, but programmatically, using Aspose 7.0.1. How to do that?
Thanks for your posting.
Please see the following reference document to add internal link in a cell.
Adding Hyperlinks to Link Data
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”);
Thats great you were able to find out the solution yourself.
Please feel free to post your any other question.