How to freeze entire header row in openpyxl?

Question

How to freeze entire header row in openpyxl? So far I can only freeze the column:

# only freeze the column (freeze vertically)
cell = ws.cell('{}{}'.format(col, row_idx+1))  
worksheet.freeze_panes = cell

Solution

Make sure cell isn't on row one - freeze_panes will freeze rows above the given cell and columns to the left.

---

Example:

from openpyxl import Workbook
wb = Workbook()
ws = wb.active
c = ws['B2']
ws.freeze_panes = c
wb.save('test.xlsx')

---

This will give you a blank worksheet with both row 1 and column A frozen.

Comments

[mvbentes]

Or you could just do wb["Sheet_name"].freeze_panes = "B2"

[rosch]

Probably obvious: use 'A2' instead of 'B2' to only freeze the header row.

[Chris]

@mvbentes You should consider posting this as an answer.

[Denis]

A suggestion to complete Paul's solution: freeze panes only after inserting some data. Otherwise, the freezed row will be empty if you insert data with an ws.append([…]).

[run_the_race]

@mvbentes comment of wb["Sheet_name"].freeze_panes = "B2" will work in write only mode too.