How to freeze panes with continental nodes

[mlauber71]

@Espinosa_a_11 there also is a component by @takbb that might make it easier to apply some formats. And indeed OpenPyxl is very powerful and if you ask ChatGPT to write some code it is also OK to handle even if you are not a full-time programmer.

Column Header - Edit

Hi @suseearun , I’ve put together a quick demo of my XLSX Simple Excel Format Apply component. [image] If you install the Continental Nodes extension, you can use this component without knowledge of how to use the Continental Nodes themselves. The component will do it all for you, for the type of basic formatting you are looking for. It can handle basic colour settings, and font sizes, and also formatting of dates and numerics, e.g. [image]