ARIS Community - We Love BPM

How to provide internal hyperlink in an excel workbook

ronak.gupta's picture
by Ronak Gupta in Reports & Macros posted on 2016-05-27

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

10556 Views
0 Likes
4 Comments
There are no attachments
Robert Goldenbaum posted on 2016-05-27

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

 

 

Ronak Gupta posted on 2016-05-27

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

Robert Goldenbaum posted on 2016-05-27

sTabname = "Sheet3"

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

Ronak Gupta posted on 2016-05-27

Thanks a lot Robert :)