my dog learned polymorphism*
The moose likes Other Open Source Projects and the fly likes #NUM! in cell (POI) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "#NUM! in cell (POI)" Watch "#NUM! in cell (POI)" New topic

#NUM! in cell (POI)

michelle mac

Joined: Jul 29, 2006
Posts: 1
I know this is probably not the best place to ask such question but I am really desperate, so please help.

I am using POI to read an excel and store the parsed values into database. My problem is I want to read log message when I encounter a cell containing problematic values such as #NUM!, #VALUE!. I was trying to do that by check the cell type, then I discover when a cell conains value #NUM!, the getCellType() would actually return 3 (blank cell). Can anybody advice me what to do? thank you so much!
Don't get me started about those stupid light bulbs.
subject: #NUM! in cell (POI)
Similar Threads
Reading the Date and time values from excel sheet
Read MS Excel Sheet Formula Execution Value Without Opening it
Formula not rendered with POI 3.6
Accessing Date columns from Excel worksheets
doubt readinf excel using poi could not find thread for poi