How to create a working link anchor in an EXCEL document with the report generation toolkit?

[IngoB]

I am using the latest report generation toolkit and want to add links on the first worksheet pointing to the other worksheets in the same document.

I am using the "Append Hypertext Link Anchor to Report" VI. The links are created, but don't work when clicking them.

Question now is: How does a link to a cell on a different worksheet needs to look like?

It can not be that complicated but all variations I tried did not work and I could not find any information about this problem. So any help is appreciated!

Thanks and Regards,

Ingo

[BrianInTheForest · Accepted solution]

You have to go down to NI_ReportGenerationToolkit.lvib:Excel_Insert_Link.vi On the Hyperlinks invoke node you will need to wire the subaddress node to the cell location you want to link to.

[IngoB]

Thanks, Brian, for your support! - It's working.

It's hard to understand why NI did not pass this parameter to the top of the call chain...

I also needed some time to understand the syntax of the string passed to the subaddress node:

The name of the worksheet needs to be framed by single quotation marks and the following cell address must preceeded by an exclamation point (!).

A working link pointing to cell "A1" of "Worksheet 1" looks like:

'Worksheet 1'!A1

Maybe also of interest: If you want to point the link to a worksheet inside the document itself, the parameter "address" (URL of link - href) can be left empty.

Thanks and Regards,

Ingo