I have an instance of where the call getNumericCellValue is failing because it thinks that the cell value is null. I can see in the debugger (eclipse) that the cell type is indeed 0 (zero), which means numeric, and the cell in question is not null, the record value is not null, but the program consistently fails at the same place.
The spreadsheet is an .xls file that 4 rows x 10 columns. The program itself is 80 +/- lines long. The getStringCellValue works perfectly fine on the remainder of the spreadsheet. I have used the POI API on another project and it worked fine. The spreadsheet was 100X more complicated and 100x bigger. I have exited eclipse, saved the spreadsheet to a different name, started a new spreadsheet. No difference. I have exported the program, it fails too. I am at a loss as to what to do next. Suggestions? I have some screen shots of both the debugger and spreadsheet if that would help. This is the first time to post so I don't know the standard policy is on this. Thanks Kevin
