Continental nodes: update default font or allow changing font

[takbb]

Hi @cbirch , I’m tagging in @Continental_KNIME_Extension_Developer for better visibility of your question.

In the meantime… as you mentioned other solutions using python, I have revisited one of those solutions, which was mentioned here:

Change the default font of the tables

Hi @CarolinaPR , Unfortunately I could not see any mechanisms within the existing XLS nodes for specifying the default font either. The XLS Font Formatter node appears to format everything except for the actual chosen font. I could not find any other nodes that would assist directly either. So I came up with only one solution, unless somebody else has another suggestion. But it does require Python 3 to be available. Do you have Python 3 and the openpyxl package installed for use with your KNI…

The “Excel Font Changer” component included on that link was written in 2021, and used the (now) legacy python nodes.

I have created a new version for use with KNIME 5, to use the new python extension environment rather than the older legacy python nodes.

Excel Font Changer 5 – takbb

You will still need to have the openpyxl module installed.

You would include this component in the workflow after the XLS Formatter (Apply) node. Make sure the spreadsheet isn’t open when executing or it will fail! If you need to automatically open the spreadsheet after changing the font, you could additionally pass a path variable representing the spreadsheet to my Open Path component:

Open Path – takbb