
GITHUB . COM {
}
Detected CMS Systems:
- Wordpress (2 occurrences)
Title:
BUG: `Styler.to_excel` does not export styles and formats correctly Β· Issue #42276 Β· pandas-dev/pandas
Description:
This is a tracker / explainer for the various issues: (#21221) (#25185) (#30008) (#34438) Essentially these issues record 3 things: Set_table_styles Styler.set_table_styles is not exported to excel. This will not be changed (at least by ...
Website Age:
17 years and 8 months (reg. 2007-10-09).
Matching Content Categories {π}
- Dating & Relationships
- Telecommunications
- Graphic Design
Content Management System {π}
What CMS is github.com built with?
Github.com relies on WORDPRESS.
Traffic Estimate {π}
What is the average monthly size of github.com audience?
ππ Tremendous Traffic: 10M - 20M visitors per month
Based on our best estimate, this website will receive around 10,000,019 visitors per month in the current month.
However, some sources were not loaded, we suggest to reload the page to get complete results.
check SE Ranking
check Ahrefs
check Similarweb
check Ubersuggest
check Semrush
How Does Github.com Make Money? {πΈ}
Subscription Packages {π³}
We've located a dedicated page on github.com that might include details about subscription plans or recurring payments. We identified it based on the word pricing in one of its internal links. Below, you'll find additional estimates for its monthly recurring revenues.How Much Does Github.com Make? {π°}
Subscription Packages {π³}
Prices on github.com are in US Dollars ($).
They range from $4.00/month to $21.00/month.
We estimate that the site has approximately 4,989,889 paying customers.
The estimated monthly recurring revenue (MRR) is $20,957,532.
The estimated annual recurring revenues (ARR) are $251,490,385.
Wordpress Themes and Plugins {π¨}
What WordPress theme does this site use?
It is strange but we were not able to detect any theme on the page.
What WordPress plugins does this website use?
It is strange but we were not able to detect any plugins on the page.
Keywords {π}
excel, border, stylertoexcel, css, issues, bug, attack, apply, formatting, style, styler, tehunter, styles, issue, tracker, sign, code, styling, header, cells, todo, commented, contributor, solid, red, projects, doesnt, writing, stylersettablestyles, milestone, error, color, set, return, navigation, open, source, pull, requests, actions, security, export, formats, correctly, class, stylerformat, column, row, headers, reflected,
Topics {βοΈ}
tehunter edits contributor personal information bug 2px solid red formatting constructs allowed _index made compatible comment metadata assignees complex css rules pseudo css attribute + border-bottom-width html indirect references body section starting valid border style border-bottom-color + border-bottom-style tracker / explainer projects milestone potential issue source type projects parsing code border-bottom exporting formatting bug/enh apply formatting border styles css language dynamically code border structure border specification border color border style github excel offers header section body cells styler class export styles excel styling row headers write xlsx cell basis header cells nth-child header cell cell translator ambiguous cases base implementation preliminary filtering ctx object doesnt react
Payment Methods {π}
- Braintree
Questions {β}
- Already have an account?
- Also with xlsxwriter and openpyxl as different writers?
Schema {πΊοΈ}
DiscussionForumPosting:
context:https://schema.org
headline:BUG: `Styler.to_excel` does not export styles and formats correctly
articleBody:This is a tracker / explainer for the various issues:
- (#21221)
- (#25185)
- (#30008)
- (#34438)
Essentially these issues record 3 things:
### Set_table_styles
`Styler.set_table_styles` is **not** exported to excel. This will not be changed (at least by me). To write xlsx, excel styling needs to be attached on a per-cell basis, whereas in HTML indirect references can be created in the CSS language that the browser will parse, for example `thead th` will apply to all header cells in the header section, and `tbody th:nth-child(3n+0)` will apply to every third header cell in the body section starting with first. Without writing our own HTML to cell translator for the CSS language it is therefore impossible to map and account for all the complex CSS rules that can be used within `set_table_styles`. **This is well documented**.
Todo:
- [x] We will instead propose changes that allow styling to header cells, to complement that already in place for body cells, (#41995)
### Exporting formatting
The number of possible formatting constructs allowed by Python is greater than what excel offers. Excel also has specified structures that differ from Pythons structures. It is impossible to dynamically code these relationships in some ambiguous cases. Therefore this will not be implemented.
Todo:
- [ ] There is currently a pseudo CSS attribute: `number-format` which can be used to apply specific Excel based formatting. This should be much better documented with examples.
### Border styles bug
Borders in CSS can be specified in many different ways, and the parsing code to translate this into excel's border structure is broken
Todo
- [x] Review the border CSS translation code and propose a solution, if only to document a single way of getting this to work.
(#45312)
### Hiding and Concatening
The Styler uses the base implementation of DataFrame.to_excel. It does not do any preliminary filtering and/or alteration of the `ctx` object to format cells in the right place. It also doesnt react to hidden indexes and/or elements.
Todo
- [x] document some of the missing features in Styler.to_excel.
- [ ] review how this can be implemented or insert a series of small PRs gradually improving the consistency.
author:
url:https://github.com/attack68
type:Person
name:attack68
datePublished:2021-06-28T07:46:52.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:17
url:https://github.com/42276/pandas/issues/42276
context:https://schema.org
headline:BUG: `Styler.to_excel` does not export styles and formats correctly
articleBody:This is a tracker / explainer for the various issues:
- (#21221)
- (#25185)
- (#30008)
- (#34438)
Essentially these issues record 3 things:
### Set_table_styles
`Styler.set_table_styles` is **not** exported to excel. This will not be changed (at least by me). To write xlsx, excel styling needs to be attached on a per-cell basis, whereas in HTML indirect references can be created in the CSS language that the browser will parse, for example `thead th` will apply to all header cells in the header section, and `tbody th:nth-child(3n+0)` will apply to every third header cell in the body section starting with first. Without writing our own HTML to cell translator for the CSS language it is therefore impossible to map and account for all the complex CSS rules that can be used within `set_table_styles`. **This is well documented**.
Todo:
- [x] We will instead propose changes that allow styling to header cells, to complement that already in place for body cells, (#41995)
### Exporting formatting
The number of possible formatting constructs allowed by Python is greater than what excel offers. Excel also has specified structures that differ from Pythons structures. It is impossible to dynamically code these relationships in some ambiguous cases. Therefore this will not be implemented.
Todo:
- [ ] There is currently a pseudo CSS attribute: `number-format` which can be used to apply specific Excel based formatting. This should be much better documented with examples.
### Border styles bug
Borders in CSS can be specified in many different ways, and the parsing code to translate this into excel's border structure is broken
Todo
- [x] Review the border CSS translation code and propose a solution, if only to document a single way of getting this to work.
(#45312)
### Hiding and Concatening
The Styler uses the base implementation of DataFrame.to_excel. It does not do any preliminary filtering and/or alteration of the `ctx` object to format cells in the right place. It also doesnt react to hidden indexes and/or elements.
Todo
- [x] document some of the missing features in Styler.to_excel.
- [ ] review how this can be implemented or insert a series of small PRs gradually improving the consistency.
author:
url:https://github.com/attack68
type:Person
name:attack68
datePublished:2021-06-28T07:46:52.000Z
interactionStatistic:
type:InteractionCounter
interactionType:https://schema.org/CommentAction
userInteractionCount:17
url:https://github.com/42276/pandas/issues/42276
Person:
url:https://github.com/attack68
name:attack68
url:https://github.com/attack68
name:attack68
InteractionCounter:
interactionType:https://schema.org/CommentAction
userInteractionCount:17
interactionType:https://schema.org/CommentAction
userInteractionCount:17
External Links {π}(2)
Analytics and Tracking {π}
- Site Verification - Google
Libraries {π}
- Clipboard.js
- D3.js
- Lodash
Emails and Hosting {βοΈ}
Mail Servers:
- aspmx.l.google.com
- alt1.aspmx.l.google.com
- alt2.aspmx.l.google.com
- alt3.aspmx.l.google.com
- alt4.aspmx.l.google.com
Name Servers:
- dns1.p08.nsone.net
- dns2.p08.nsone.net
- dns3.p08.nsone.net
- dns4.p08.nsone.net
- ns-1283.awsdns-32.org
- ns-1707.awsdns-21.co.uk
- ns-421.awsdns-52.com
- ns-520.awsdns-01.net