getDateCellValue not working as desired. about excel-streaming-reader HOT 3 CLOSED

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.