Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

#NUM! in cell (POI)  RSS feed

michelle mac
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!