aspose file tools*
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


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "#NUM! in cell (POI)" Watch "#NUM! in cell (POI)" New topic
Author

#NUM! in cell (POI)

michelle mac
Greenhorn

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: http://aspose.com/file-tools
 
subject: #NUM! in cell (POI)