Excelwriter freeze position of a sheet itself (not at row or column level)?

25 views Asked by At

I'm using excelwriter engine. My excel file has more than 50 sheets/tabs with the first being a 'summary' sheet (which has internal links for other 50 tabs). I'm looking for a freeze option at the sheet level itself, so that summary sheet's position would always be frozen and horizontal scrolling can be avoided in order to move to first sheet.

I have tried freeze_panes but it can be used at rows and columns level inside a sheet. similar stuff with set_scrollarea or set_sheet_view etc.

0

There are 0 answers