How to freeze panes with continental nodes

[Espinosa_a_11]

Hi,

I would like to freeze the first row and first column of an Excel report with Knime, but I keep getting this error when I tag them with header and then try and freeze them

Freeze cell A1 means no visual freeze effect. Did you intend to freeze at the top-left corner of cell B2?

I am able to freeze them individually but not together and don’t know why, is this possible?

Thank you!

[Espinosa_a_11]

nevermind! I realized I just didn’t even know how to do it in excel, so once I figured that out I just tagged B2 and nothing else and froze that and it worked

[ScottF]

Thanks for posting the solution you found. And welcome to the forum!

[mlauber71]

@Espinosa_a_11 you can also employ python and openpyxl to format Excel headers

Extra simple workflow to color header row backgrounds in Excel file

@Nazaire I built a slightly different example of the use of OpenPyxl with some configuration. It would determine the number of columns and then set a pre-defined style, auto-size the columns and freeze the top row. [image] The same principles could be applied to other formats. So if you like coding you could do it with OpenPyxl [image] kn_example_python_excel_format_header.knwf (130.1 KB)

Excel file header format with KNIME and OpenPyxl – mlauber71

[Espinosa_a_11]

Oh wow yeah openpyxl looks powerful!

[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]