Icon

Excel Change Font using python openpyxl component

Demo workflow to show proof of concept for using openpyxl to change thefont name for every cell in a specified sheet of an XLS. The only node required for performing the font change is the Excel FontChanger component. The other nodes and components in this workfloware for the purposes of creating a demonstration. THE MAIN EVENT!LOLPut in a font namee.g. ArialTimes New RomanCourier NewAlgerianWingdings ;-)"SampleOutput.xlsx"Convert the path var created byExcel Writer to a StringGenerate 200rows of dataUse Vernalis nodeto turn Knime URI stringinto absolute file pathThis component then opens theoutput for you to view in Excel Excel Font Changer Excel Writer Path to String(Variable) Data Generator KNIME URI Resolver(Variable) Open File or Folder Demo workflow to show proof of concept for using openpyxl to change thefont name for every cell in a specified sheet of an XLS. The only node required for performing the font change is the Excel FontChanger component. The other nodes and components in this workfloware for the purposes of creating a demonstration. THE MAIN EVENT!LOLPut in a font namee.g. ArialTimes New RomanCourier NewAlgerianWingdings ;-)"SampleOutput.xlsx"Convert the path var created byExcel Writer to a StringGenerate 200rows of dataUse Vernalis nodeto turn Knime URI stringinto absolute file pathThis component then opens theoutput for you to view in ExcelExcel Font Changer Excel Writer Path to String(Variable) Data Generator KNIME URI Resolver(Variable) Open File or Folder

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: @takbb Brian Bates
Created at: 2021-05-26
On NodePit since: 2021-05-26
Last update: 2024-04-27
Created with KNIME version: v4.3.3

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!