|issue with HSSFCell.getStringCellValue()|
issue with HSSFCell.getStringCellValue() 2005-04-28 - By Sanjiv Jivan
I have a spreadsheet with a postal code column. In my app, we treat postal
codes as Strings.
The problem is that when reading the postal code cell values from the
spreadsheet using HSSFCell.getStringCellValue(), it raises an exception when
the postal code happens to contain only numbers. Excel might be converting
the data type to number for such cells implicitly but there's no reason that
I should not be able to read these as Strings. I think that the
getStringCellValue() should simply read the value as number and do a
toString() and return instead of raising an exception.
Earn $52 per hosting referral at Lunarpages.