In my workbook I can have many sheets, and I have been asked to create an index sheet as the first sheet that contains hyperlinks to the other sheets in the workbook. How do I make a sheet or cell the target of a hyperlink?
Currently Aspose.Excel only supports hyplerlinks to URL. I will add the feature to support hyperlinks to current workbook. It will be available in the next week.
Thanks for your patience.
Please download the latest hotfix.
You can use the following code to add an internal link.
worksheet.Hyperlinks.AddInternalLink(0, 0, 1 , 1, “Sheet2!B2”);
worksheet.Hyperlinks.AddInternalLink(“B3”, 1 , 1, “Sheet2!B9”);