openpyxl icon indicating copy to clipboard operation
openpyxl copied to clipboard

Error: data loss when saving file

Open bluntsword1986 opened this issue 11 months ago • 1 comments

When saving file with wb.save("sample.xlsx"), some cells with larger characters may lose some data, but the values of the cells in memory are correct. Some people analyze that the possible reason is that the contents of one cell are not saved completely, howerever the saving of another cell begins.

bluntsword1986 avatar Mar 24 '24 15:03 bluntsword1986

I encountered the same problem. The size of the file is smaller after saving, which means some data is lost.

bioinfotec avatar May 20 '24 17:05 bioinfotec