Comments (3)
Judging from the stacktrace, the cell value is null when that error occurs. There should always be an error in that case (though it could certainly be made clearer). Are you sure the sheet has a value there? If so, can you post an example file?
from excel-streaming-reader.
Yes you are correct .The cell value is empty.So how one can handle this scenario.I think currently this method is not able to handle null condition.
from excel-streaming-reader.
Looks like the way I wrote this technically violates the terms of the interface:
java.util.Date getDateCellValue()
Get the value of the cell as a date. For strings we throw an exception. For blank cells we return a null.
double getNumericCellValue()
Get the value of the cell as a number. For strings we throw an exception. For blank cells we return a 0. For formulas or error cells we return the precalculated value;
So, it should just return a null unless the value is not parseable.
from excel-streaming-reader.
Related Issues (20)
- The supplied data appears to be in the OLE2 Format HOT 2
- Getting org.apache.poi.xssf.model.SharedStringsTable.getEntryAt(I) Error with POI 5.0.0 HOT 4
- New release planned with Apache POI 5.x (4.1.2 contains vulnerabilities)? HOT 1
- spliterator is not supported with Apache POI 5.2.0 (Unsupported operation getPhysicalNumberOfRows) HOT 1
- 内存溢出问题
- StreamingWorkbook#getSheetIndex(String) and StreamingWorkbook#getSheet(String) behavior is inconsistent with poi-ooxml HOT 6
- This cannot be used for reading which has image HOT 1
- Can I get data formateed value from a numberic cell HOT 2
- Can I get data formateed value from a numberic cell
- NoSuchMethodError on getSharedStringsTable HOT 1
- FileNotFoundException exception for MultipartFile resource file
- Unable to read xlsx file using Excel steaming reader HOT 2
- read picture HOT 5
- Unable read excell cell text if cell has line break HOT 1
- Is this project still active or should we look for alternatives? HOT 3
- High CPU utilisation spikes recorded HOT 3
- Unable to load the cells which are blank HOT 5
- Unable to read large excel files HOT 6
- XSSFWorkbook change orientation to landscape
- `org.xml.sax.SAXNotRecognizedException: http://xml.org/sax/properties/ on Android
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 excel-streaming-reader.