ENH: styler.to_excel to support excel notes as implementation of tooltips

[sdementen]

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

[rhshadrach]

Thanks for the request. The proposed behavior here seems intuitive to me, I'm supportive of this as long as the implementation is reasonable.

cc @attack68 for thoughts.

[rhshadrach]

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.

[attack68]

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.

[Dacops]

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

[Dacops]

take

[diogomsmiranda]

take