Comments (3)
For large files you can use SXSSFWorkbook
from npoi.
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?
from npoi.
@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.
from npoi.
Related Issues (20)
- fixed "Cannot add more than 65535 shapes" HOT 10
- fixed AutoFilter record size with multibyte strings. HOT 1
- fixed System.ArgumentException: 'Invalid CellReference: 'Sheet1' HOT 2
- Validation cannot handle double quote
- fixed System.InvalidOperationException: 'The hyperlink for cell A1 references relation rId1, but that didn't exist!'
- CICD script doesn't update the version number of the nuget package after updating to 2.7.1
- NPOI setting a new workbook ThemesTable copied from another workbook ThemesTable does nothing HOT 1
- ExcelToHtmlConverter dont assign class to tr tag
- GitHub: Missing release info/changelog for 2.7.1 HOT 3
- CreateColumn return System.ArgumentOutOfRangeException: Index was out of range
- The backport of POI Bug 60370 introduces a bug with PromptBox and ErrorBox text encoding HOT 1
- ByteArrayOutputStream is not disposed in NPOI.Util.IOUtils.ToByteArray method. Potential Memory leak HOT 2
- Reading Docs With DesignType,throw POIXMLException Error
- Wrong picture size in merged cell after picture.Resize() was invoked.
- Security vulnerabilities in SixLabors.ImageSharp HOT 4
- XSSFWorkbook write issue
- Remove picture...
- npoi-examples not available HOT 4
- 安装了最新版的库,处理同样多的数据,变慢了一半! HOT 4
- Inconsistent new lines in worksheets
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from npoi.