Development/Python

xlsxwriter 엑셀 틀 고정 (EX. xlsxwriter freeze first row 첫 행 틀 고정)

Best Junior 2019. 4. 10. 13:28

### worksheet.freeze_panes() ### Python > import xlsxwriter

 

 

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

worksheet.freeze_panes('A2') # Same using A1 notation.

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

worksheet.freeze_panes('B1') # Same using A1 notation.

worksheet.freeze_panes(1, 2) # Freeze first row and first 2 columns.

worksheet.freeze_panes('C2') # Same using A1 notation.