sheetjs/sheetjs
34
Fork 30
Code Issues 177 Pull Requests 13 Wiki Activity

Blank rows/columns in exported file #2920

New Issue
Open
opened 2023-04-17 12:36:39 +00:00 by shadoworion · 6 comments
shadoworion commented 2023-04-17 12:36:39 +00:00
Copy Link

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
Owner
Copy Link

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
shadoworion commented 2023-04-18 06:45:23 +00:00
Author
Copy Link

It still the same behavior with this option

It still the same behavior with this option
sheetjs commented 2023-04-18 06:46:00 +00:00
Owner
Copy Link

Can you share a more detailed example?

Can you share a more detailed example?
shadoworion commented 2023-04-18 06:58:34 +00:00
Author
Copy Link

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
Author
Copy Link

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?
sheetjs commented 2023-04-20 15:59:52 +00:00
Owner
Copy Link

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 Branch/Tag Specified
Branches Tags
Labels
Clear labels   
DBF

   
Dates

   
Defined Names

   
Features

   
Formula

   
HTML

   
Images

   
Infrastructure

   
Integration

   
International

   
ODS

   
Operations

   
Performance

   
PivotTables

   
Pro

   
Protection

   
Read Bug

   
SSF

   
SYLK

   
Style

   
Write Bug

   
good first issue
No Label
DBF
Dates
Defined Names
Features
Formula
HTML
Images
Infrastructure
Integration
International
ODS
Operations
Performance
PivotTables
Pro
Protection
Read Bug
SSF
SYLK
Style
Write Bug
good first issue
Milestone
Clear milestone
No items
No Milestone
Assignees
Clear assignees
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.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?