Hi, I have used Apache POI to read excel sheet and the cell contents Now it may happen that either or more of the cells in a row are empty. >From what I read the cell iterator returns the null cells but while iterating over it cells.next points to the next non-null field. I want to dump the contents as they are in the sheet into a database So basically a null field has to be null. So I wrote a routine which would check the cell.getColumnNumber and the count that I maintained to check whether it is indeed the right cell. But cell.hasNext() used in the loop makes the pointer move to the next cell and due to which the entire loop goes haywire. Could someone help me with this? I think I am trying to complicate matters and there is an easy way out.
Bunch of Thanks :) Patssay -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-Excel-sheet-cell-contents-tp3286664p3286664.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]
