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
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
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
sTabname = "Sheet3"
sHyperlinkAddress = "'" + sTabname + "'!A1"