How to provide internal hyperlink in an excel workbook

Posted by Ronak Gupta

Posted on Fri, 05/27/2016 - 08:17 in Reports & Macros

We want to set hyperlink in an excel workbook using ARIS script. For an example some data is present in sheet 1 and want to set hyperlink to that data. If i click on Redirect to sheet 2 then it should open sheet 2..if i click on Redirect to sheet 3 then it should open sheet 3 ...and so on.

Is there any method to open the existing sheet of same excel through hyperlink, Kindly suggest.

Thanks and Regards

Ronak Gupta

ARIS

ARIS Express

ARIS Report

ARIS Report Scripting

ARIS script

22.4k

by Robert Goldenbaum

Posted on Fri, 05/27/2016 - 08:36

Hi,

yes, this is possible...

Report class XlsCell - Method setHyperlink( String sLabel, String sHyperlinkAddress )

With the target like this:

"'" + sTabname + "'!A1"

The problem (at least in 7.2) is here that the hyperlink then seems to be just some normal text. So I am setting the format afterwards to underline blue for this cell...

BR Robert

by Ronak Gupta Author

Posted on Fri, 05/27/2016 - 09:17

Thanks Robert for your quick reply.

how should i provide the value in place of String sHyperlinkAddress . what would be the logic behind that. can you please elaborate.

Thanks and Regards

Ronak

by Robert Goldenbaum

Posted on Fri, 05/27/2016 - 09:30

sTabname = "Sheet3"

sHyperlinkAddress = "'" + sTabname + "'!A1"

by Ronak Gupta Author

Posted on Fri, 05/27/2016 - 09:31

Thanks a lot Robert :)

How to provide internal hyperlink in an excel workbook

Featured achievement

Leaderboard

Follow us

View posts by tag