Icon

12_​XLS_​Hyperlinker

Apply Formatting Instructions to XLS File Defining Hyperlinks After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. Pass up to 20,000 hyperlinks in String columns directly to the XLSHyperlinker node. Links must be URL encoded, e.g. a spacecharacter needs to be encoded as %20. Local files can be addressedvia the file:/ protocol. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details. Define font marking the cells with hyperlinks The XLS Font Formatter node requires a tag to apply its format to. This is deriveddynamically from the hyperlink input table here.hyperlinks as URL encodedString cell contentstransform toXLS Control Tabletransform hyperlinksto XLS formattinginstructionstag "link" tounderlined,blue fontto unpivoted/long layoutreplace any Valueby "link"back towide layoutXLS Formatter(apply) Table Creator XLS ControlTable Generator XLS Hyperlinker XLS Font Formatter XLS ControlTable Generator Rule Engine XLS ControlTable Generator Apply Formatting Instructions to XLS File Defining Hyperlinks After having collected all formatting instructionsfrom the XLS Formatter nodes, apply these toyour XLS file. Pass up to 20,000 hyperlinks in String columns directly to the XLSHyperlinker node. Links must be URL encoded, e.g. a spacecharacter needs to be encoded as %20. Local files can be addressedvia the file:/ protocol. This example workflow is licensed under the MIT License. SeeLICENSE.txt in the workflow directory for details. Define font marking the cells with hyperlinks The XLS Font Formatter node requires a tag to apply its format to. This is deriveddynamically from the hyperlink input table here.hyperlinks as URL encodedString cell contentstransform toXLS Control Tabletransform hyperlinksto XLS formattinginstructionstag "link" tounderlined,blue fontto unpivoted/long layoutreplace any Valueby "link"back towide layoutXLS Formatter(apply) Table Creator XLS ControlTable Generator XLS Hyperlinker XLS Font Formatter XLS ControlTable Generator Rule Engine XLS ControlTable Generator

Nodes

Extensions

Links