File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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!
I agree. Here's the link:
subject: #NUM! in cell (POI)
It's not a secret anymore!