Blank rows/columns in exported file #2920

Open
opened 2023-04-17 12:36:39 +00:00 by shadoworion · 6 comments

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?
Owner

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
Author

It still the same behavior with this option

It still the same behavior with this option
Owner

Can you share a more detailed example?

Can you share a more detailed example?
Author

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
Author

Can you share a more detailed example?

Do you need something else?
You understand a problem?

> Can you share a more detailed example? Do you need something else? You understand a problem?
Owner

Based on the sample, we need to revisit the ZIP compression

Based on the sample, we need to revisit the ZIP compression
Sign in to join this conversation.
No Milestone
No Assignees
2 Participants
Notifications
Due Date
The due date is invalid or out of range. Please use the format 'yyyy-mm-dd'.

No due date set.

Dependencies

No dependencies set.

Reference: sheetjs/sheetjs#2920
No description provided.