First of all I think its better for you to watch at the QuickGuide: http://poi.apache.org/spreadsheet/quick-guide.html There are useful code examples.
Then think about the errormessage.. Cannot get a text value from a numeric formula cell Then watch at your code.. you are checking for formula OR string cells if (c.getCellType() == Cell.CELL_TYPE_FORMULA || c.getCellType() == Cell.CELL_TYPE_STRING) so you are using .getStringCellValue(); also at formula cells - that`s causing your exception. Back to QuickGuide, watch at "Getting the cell contents" and you will see: that should help you -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Search-in-Sheet-tp4949824p4951558.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
