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!

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

How to freeze panes with continental nodes

KNIME Extensions

mlauber71 June 12, 2024, 6:09pm 4

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

3 Likes