excelize icon indicating copy to clipboard operation
excelize copied to clipboard

File not compressed? Xlsx 50 Mb to 1.5mb

Open IAkumaI opened this issue 3 years ago • 1 comments

I create file with stream writer. Nothing special, just text (file attached). File has size ~50Mb. But if I open it and save via Excel/Numbers to same xlsx format - file size will be 1.5 Mb.

Why there is so large difference?

File created by exelize (just in zip for github): treolink.ru.xlsx.zip

File open&exported via Numbers: treolink--2.xlsx

IAkumaI avatar Feb 08 '22 08:02 IAkumaI

Thanks for your issue. For faster generate speed and lower memory usage, the non-numeric type cell value won't be stored as a shared string in streaming mode currently. If you want to get a smaller size for generating spreadsheet files, please use the normal mode functions, such as SetSheetRow or SetCellValue, please also reference pull request #1123.

xuri avatar Feb 08 '22 11:02 xuri

I'll close this issue, if you have any questions, please let me know to reopen this anytime.

xuri avatar Mar 16 '23 02:03 xuri