I created an excel sheet with python xlsxwriter. When i resaved it with libreoffice calc the size decreased by more than 60 percent. why is it ? Is there any way i can mimic this in python to reduce my file size?
The size sometimes reduces if you have empty cells on the list. Similar behavior is when you move in Excel to cell A1 and then save, the file size decreases. But you generated the file, so this behaviour may not necessarily apply.
Excel sheet size reduced on resaving