Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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!

like image 842
mongotop Avatar asked Nov 08 '25 02:11

mongotop


1 Answers

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

worksheet.freeze_panes(1, 1) # # Freeze the first row and column
like image 99
mongotop Avatar answered Nov 10 '25 15:11

mongotop



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!