ENH: show warning when exporting dataframe and hitting excel truncating limit #56954
Closed
1 of 3 tasks
Labels
Docs
Enhancement
IO Excel
read_excel, to_excel
Warnings
Warnings that appear or should be added to pandas
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
The text was updated successfully, but these errors were encountered: