to_excel should (optionally) freeze panes

[jnothman]

DataFrame.to_excel() is currently helpful in styling column and row headers distinctly from values. One other simple feature Excel provides to manage headers is "freeze panes". Panes can be frozen such that the column and row headers are fixed. This is achieved in openpyxl with worksheet.freeze_panes = top_left_value_cell and in xlwt with worksheet.freeze_panes(bottommost_header_row, leftmost_header_col).

I think making this available, as an option or by default, would give a valuable usability boost to the exported Excel spreadsheets.

[jreback]

sure lots of thinks that pandas could do with the updates in the openpyxl style API. love to have PR's!

[chris-b1]

Here's the same for xlsxwriter. My preference would be not have it as a default, but agree it would be a nice addition.

http://xlsxwriter.readthedocs.io/example_panes.html

[jnothman]

The other header display feature that might be woeth having as an option is an AutoFilter.

…

On 20 January 2017 at 23:39, chris-b1 ***@***.***> wrote: Here's the same for xlsxwriter. My preference would be not have it as a default, but agree it would be a nice addition. http://xlsxwriter.readthedocs.io/example_panes.html — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#15160 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAEz6wVGhKQXvPiugDQpcP_STKumNVrpks5rUKsGgaJpZM4Lns3W> .

[jnothman]

yay! thanks

…

On 17 Feb 2017 4:48 am, "Jeff Reback" ***@***.***> wrote: Closed #15160 <#15160> via 9b5d848 <9b5d848> . — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#15160 (comment)>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAEz6-g2EHKp2vayA0DFjpmE5TjOopqWks5rdIvOgaJpZM4Lns3W> .