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.