CODEWITHSUNDEEP
pythonexcelfreezexlsxwriter
mongotop
mongotop

Reputation: 5774

how to freeze a row and a columns in an excel file using xlsxwriter in python

I want to freeze the first row and the first column in my excel file using xlsxwriter in python, I tried the bellow code, and seems like that it freeze just the column, when I remove the second line on the code that freeze the column, it freezes the first row, seems like the second line in the code overwrite the first one.

worksheet.freeze_panes(1, 0) # # Freeze the first row.
worksheet.freeze_panes(0, 1) # Freeze the first column.

I checked the documentation here , seems like no help there.
Thanks!

Upvotes: 3

Views: 7555

Answers (1)

mongotop
mongotop

Reputation: 5774

I found this linne and it did the work for me!!

worksheet.freeze_panes(1, 1) # # Freeze the first row and column

Upvotes: 5

Related Questions