ENH: show warning when exporting dataframe and hitting excel truncating limit · Issue #56954 · pandas-dev/pandas (original) (raw)

Feature Type

• Adding new functionality to pandas
• Changing existing functionality in pandas
• Removing existing functionality in pandas

Problem Description

I wish I can see a warning when I save a pandas dataframe to excel, and one of the columns contain super long strings, and these strings are truncated, possibly due to a limit on the Excel side.

Feature Description

detect string length and Show a warning when the some contents of a cell exceed Excel length/size limit, to let the users know that the data won't be saved fully if choose to export to excel. (csv is probably better)

Alternative Solutions

show warning all the time or add this to pd.to_excel documentation

Additional Context

No response