I'm using apache poi
While i'm designing my application i found it read the empty cells as numbers
for example an empty cell is read as 5.332664015E9
so i checked and found this number values is in the place of the empty cells from the beginning in the iterator in this code
I checked the excel and I made sure there isn't any formulas or anything in the empty cells.
so what causes that and how to fix this problem?
In that loop (the Iterator<Cell> one) log out the values for CellType, the cell coordinates (row and column), and the value.
Since it's only numeric cells that are the issue you can limit that to the CELL_TYPE_NUMERIC case.
Don't do this with the debugger...you want a "physical" copy of the logged data so you can then post it here, as well as look in the Excel file yourself.
First: very sorry, the application wasn't replacing the empty cells with null values while reading it, it was skipping the empty cells entirely and adding the next cell value to the empty cell.
Second: the problem are solved by changing the following loop