You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
One difficulty I've encountered in the past is getting the comment size correct. If you do not set the size of a long comment (at least, using xlsxwriter), the comment is very difficult to read without resizing in Excel.
I think the implementation would not be too complicated.
The Styler Tooltips object contains a DataFrame of strings that would serve as the data to the written excel cells.
I expect that xlswriter procedure could check for the existence of a Tooltips object. If none writing to excel is unchanged and performance identical. If it exists then the yielded excel cells would have an extended routine to write the comment as provided by the tooltips string.
Not sure that Tooltips is a widely used feature, however, but if someone was willing to explore this implementation I would help review.
Hi, this seems like an interesting issue that me and my colleague @diogomsmiranda would like to tackle. If we have any doubt about it we'll reply on this thread
Feature Type
Adding new functionality to pandas
Changing existing functionality in pandas
Removing existing functionality in pandas
Problem Description
I wish I could use set_tooltips in the styler to generate notes in an excel workbook (via the to_excel)
Feature Description
No real API change, but have the ExcelFormatter use the information set by styler.set_tooltips to create not on the cells with a tooltip
Alternative Solutions
No idea for an alternative except the statu quo...
Additional Context
No response
The text was updated successfully, but these errors were encountered: