Blank rows/columns in exported file #2920

New Issue

shadoworion · 2023-04-17T12:36:39Z

shadoworion commented

2023-04-17 12:36:39 +00:00

First-time contributor

Exporting a file with the writeFile function will export a file with a specific size (depending on data), for example, 1.5MB.
Then if I enter the file via Excel and delete all blank rows after all data, it will degrade to 750KB.
Why? Is it possible to export the file without this file enlargement?

Exporting a file with the writeFile function will export a file with a specific size (depending on data), for example, 1.5MB. Then if I enter the file via Excel and delete all blank rows after all data, it will degrade to 750KB. Why? Is it possible to export the file without this file enlargement?

sheetjs commented

2023-04-17 16:11:07 +00:00

https://docs.sheetjs.com/docs/miscellany/errors/#generated-xlsx-files-are-very-large

For ZIP-based exports (XLSX / XLSM / XLSB / ODS), pass the option compression: true to enable compression

https://docs.sheetjs.com/docs/miscellany/errors/#generated-xlsx-files-are-very-large For ZIP-based exports (XLSX / XLSM / XLSB / ODS), pass the option `compression: true` to enable compression

sheetjs closed this issue

2023-04-17 16:11:07 +00:00

shadoworion commented

2023-04-18 06:45:23 +00:00

First-time contributor

It still the same behavior with this option

shadoworion reopened this issue

2023-04-18 06:45:23 +00:00

sheetjs commented

2023-04-18 06:46:00 +00:00

Can you share a more detailed example?

shadoworion commented

2023-04-18 06:58:34 +00:00

First-time contributor

For example, "Input.xlsx" - 28KB - this file exported with "sheetjs"
File "Input-afterdelete.xlsx" - 16.5KB - same file after deleting all empty rows (155-1048576)

I see this behaviour with more big files, and it will be more problematic, for example:
From: 1.5MB - To: 750KB
From: 15MB - To: 4.5MB

For example, "Input.xlsx" - 28KB - this file exported with "sheetjs" File "Input-afterdelete.xlsx" - 16.5KB - same file after deleting all empty rows (155-1048576) I see this behaviour with more big files, and it will be more problematic, for example: From: 1.5MB - To: 750KB From: 15MB - To: 4.5MB

Input.xlsx

27 KiB

Input-afterdelete.xlsx

16 KiB

shadoworion commented

2023-04-20 15:57:57 +00:00

First-time contributor