openpyxl
openpyxl copied to clipboard
Error: data loss when saving file
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.
I encountered the same problem. The size of the file is smaller after saving, which means some data is lost.