The XLS Hyperlinker adds hyperlinks to cells.Hyperlinks need to be provided in URL encoded form, e.g. space characters being replaced by %20 and usage of slashes instead of backslashes in the file:/ protocol. Encoding or protocol errors can only partly be checked within this node and will most likely cause the respective links to fail in your spreadsheet application. The maximum number of hyperlinks allowed in a single workbook is 20,000. This node does not change the text format of the affected cells. A desired formatting (such as blue and underlined text) can be achieved via the XLS Font Formatter node. This node defines a formatting instruction only which needs to be written to an xlsx file via the XLS Formatter (apply) node subsequently.
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.
A zipped version of the software site can be downloaded here.
Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.Try NodePit Runner!
Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to firstname.lastname@example.org, follow @NodePit on Twitter, or chat on Gitter!
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.