Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes Other Open Source Projects and the fly likes #NUM! in cell (POI) Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Reply 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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: #NUM! in cell (POI)
 
Similar Threads
doubt readinf excel using poi could not find thread for poi
Read MS Excel Sheet Formula Execution Value Without Opening it
Formula not rendered with POI 3.6
Accessing Date columns from Excel worksheets
Reading the Date and time values from excel sheet