Meaningless Drivel is fun!*
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 Murach's Java Servlets and JSP this week in the Servlets 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)
 
Similar Threads
Reading the Date and time values from excel sheet
Formula not rendered with POI 3.6
Accessing Date columns from Excel worksheets
doubt readinf excel using poi could not find thread for poi
Read MS Excel Sheet Formula Execution Value Without Opening it