Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Reading large files #1326

Closed
1 of 5 tasks
manuraffl30 opened this issue May 2, 2024 · 3 comments
Closed
1 of 5 tasks

Reading large files #1326

manuraffl30 opened this issue May 2, 2024 · 3 comments
Labels
performance question

Comments

@manuraffl30
Copy link

NPOI Version Used

2.7.0

File Type

  • XLSX
  • XLS
  • DOCX
  • XLSM
  • OTHER

Use Case

Reading Excelfiles > 200 Kilobyte
Reading Excelsheets > 80 Kilobyte

Description

I have a problem with reading "large" Excel-Files / Sheets
is or will there be a feature that "allows" reading those files?
@Bykiev
Copy link
Collaborator

Bykiev commented May 2, 2024

For large files you can use SXSSFWorkbook

@tonyqus
Copy link
Member

tonyqus commented May 2, 2024 •
edited
Loading

What's the issue you encountered? Out of memory? Or slowness

Can you give an estimation of how many rows and columns you have in each Excel sheet?

@manuraffl30
Copy link
Author

@tonyqus
I assume that the issue i ran into was slowness but I just found the problem.
There were some sheets with loads of emty cells in my workbook, after removing all of them the filesize went from 980 kb to ~500 kb and now everything just works fine with XSSFWorkbook, thanks for the fast answers and sorry for "wasting" your time.

@tonyqus tonyqus closed this as completed May 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
performance question
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tonyqus @Bykiev @manuraffl30