XlsxWriter has a method of adding frozen panes to an excel file:
import xlsxwriter
workbook = xlsxwriter.Workbook('frozen_panes.xlsx')
worksheet1 = workbook.add_worksheet('Panes 1')
worksheet1.freeze_panes(1, 0)
However, I have to use Pyexcelerate, and I can't find anything in their docs related to froze panes. Does Pyexcelerate have a similar method which would allow me to add frozen panes?
To whom it may concern:
The solution was to get a worksheet and add a Pane with the option freeze = true
.
The class Pane can be seen here:
https://github.com/kz26/PyExcelerate/blob/dev/pyexcelerate/Panes.py