Excel Font Changer

Changes the font for every cell on a specified sheet in an XLSX file. This component uses Python and openpyxl which must be installed and available to your KNIME environment.

This is a proof of concept, and may be improved upon in future to allow specification of cell range


26 May 2020 @takbb Brian Bates

Options

File name

Enter the full path to the required Excel file

Required Font

Specify the name of the font to use across all cells

Enter sheet name

Enter name of sheet to which font change should be applied.

Nodes

• String Configuration3 ×
• Component Input1 ×
• Component Output1 ×
• Merge Variables1 ×
• Python Script (legacy)1 ×
• Table Creator1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Python 2 Integration (legacy)
• FeatureKNIME Quick Forms

Links

• No links available