8000 to_excel should (optionally) freeze panes · Issue #15160 · pandas-dev/pandas · GitHub
[go: up one dir, main page]
Skip to content

to_excel should (optionally) freeze panes #15160

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
jnothman opened this issue Jan 19, 2017 · 4 comments
Closed

to_excel should (optionally) freeze panes #15160

jnothman opened this issue Jan 19, 2017 · 4 comments
Labels
Enhancement IO Excel read_excel, to_excel
Milestone
0.20.0

Comments

@jnothman
Copy link
Contributor

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.
@sinhrks sinhrks added Enhancement IO Excel read_excel, to_excel labels Jan 19, 2017
@jreback
Copy link
Contributor
jreback commented Jan 19, 2017

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

@jreback jreback added this to the Next Major Release milestone Jan 19, 2017
@chris-b1
Copy link
Contributor

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
8000

@jnothman
Copy link
Contributor Author
jnothman commented Jan 21, 2017 via email

This was referenced Feb 2, 2017
Closed
Closed
@jreback jreback modified the milestones: 0.20.0, Next Major Release Feb 7, 2017
@jnothman
Copy link
Contributor Author
jnothman commented Feb 16, 2017 via email

@jeffcarey jeffcarey mentioned this issue Mar 6, 2017
Closed
2 tasks
jreback pushed a commit that referenced this issue Mar 7, 2017
@jeffcarey @jreback
CLN: Moved freeze_panes validation to io/excel.py (#15160)
1123982 
follow up to #15160

Author: Jeff Carey <jeff.carey@gmail.com>

Closes #15592 from jeffcarey/enh-15160-touchup2 and squashes the following commits:

81cb86f [Jeff Carey] Cleaned up freeze_panes validation code
a802fc7 [Jeff Carey] Moved freeze_panes validation to io/excel.py
AnkurDedania pushed a commit to AnkurDedania/pandas that referenced this issue Mar 21, 2017
@jeffcarey @AnkurDedania
ENH: Added ability to freeze panes from DataFrame.to_excel() (pandas-…
43aba17 
…dev#15160)

closes pandas-dev#15160

Author: Jeff Carey <jeff.carey@gmail.com>

Closes pandas-dev#15291 from jeffcarey/enh-15160 and squashes the following commits:

cef8fce [Jeff Carey] ENH: Added ability to freeze panes from DataFrame.to_excel()
AnkurDedania pushed a commit to AnkurDedania/pandas that referenced this issue Mar 21, 2017
@jeffcarey @AnkurDedania
CLN: Moved freeze_panes validation to io/excel.py (pandas-dev#15160)
69902bd 
follow up to pandas-dev#15160

Author: Jeff Carey <jeff.carey@gmail.com>

Closes pandas-dev#15592 from jeffcarey/enh-15160-touchup2 and squashes the following commits:

81cb86f [Jeff Carey] Cleaned up freeze_panes validation code
a802fc7 [Jeff Carey] Moved freeze_panes validation to io/excel.py
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Enhancement IO Excel read_excel, to_excel
Projects
None yet
Milestone
0.20.0
Development

Successfully merging a pull request may close this issue.

ENH: Added ability to freeze panes from DataFrame.to_excel() (#15160) jeffcarey/pandas
4 participants
@jnothman @jreback @sinhrks @chris-b1
0