compression #2974

New Issue

sheetjs · 2023-06-27T07:52:23Z

sheetjs commented

2023-06-27 07:52:23 +00:00

tracking issue for DEFLATE compression quality / performance tradeoff

sheetjs referenced this issue

2023-09-13 16:41:32 +00:00

The file size I exported was about double the actual value #2988

sheetjs referenced this issue

2023-09-14 08:35:58 +00:00

XLSX.utils.json_to_sheet and XLSX.utils.aoa_to_sheet stuck in infinite loop after certain data size #2989

FrostKiwi commented

2023-09-15 06:22:41 +00:00

First-time contributor

Already pretty happy with compression, so this point is not particularly important to us.
Still wanted to share our numbers:
All with dense: true, in case that makes a difference.
10 columns, 883.407 rows, just numbers, one string column, 90% of numbers are the same

Compression OFF: 295 MB
Compression ON: 78 MB
- 26% compression ratio
Resaved with Excel 36 MB
- 12% compression ratio

So compared to default Excel, there is ~14% compression ratio left on the table (for this specific dataset).

Already pretty happy with compression, so this point is not particularly important to us. Still wanted to share our numbers: All with `dense: true`, in case that makes a difference. 10 columns, 883.407 rows, just numbers, one string column, 90% of numbers are the same - Compression OFF: 295 MB - Compression ON: 78 MB - 26% compression ratio - Resaved with Excel 36 MB - 12% compression ratio So compared to default Excel, there is ~14% compression ratio left on the table (for this specific dataset).

Sign in to join this conversation.