Hi Hugo, Bit less information to diagnose, I believe object~1 to object~n are the row data read from the sheet right? And the problem is saveInDB() method storing data from other sheet instead of serially processing the 1st sheet? R u really sure that data from other rows r lot or its written randomly? R u by any chance keeping these objects in any HashMap or Hashtable? These r all wild guesses. I believe its nothing to do with POI API..but the application logic.
Cheers Joe -----Original Message----- From: Hugo Osorio [mailto:[EMAIL PROTECTED] Sent: 30 March 2007 03:37 To: [email protected] Subject: problem hssf java hi i hope somebody give me a help, i have problems in cells, rows, and sheets loops in a excel book using poi as soon as i cross and validate all of the cells in a row, before go to the second row i construct the read objects from the cells, like this: objeto1 = new Objeto1(ArrayList); objeto2 = new Objeto2(ArrayList); objeto3 etc., so i belive that in objeto1 i already have some attributes all filled to do with them whatever i want... so i will write in the database using jdbc i have made an instance of a variable in this very class. and the instance is related to a class where i have write to the database, after all of the constructions of these objects objeto1, objeto2, etc i say: saveInDatabase.saveObjeto1(objeto1); this last instruction has messed up my loops and it does not jump to the next row, instead, it goes to the other sheet... passing by (ignoring) the remaining rows in the sheet...i dont know why.. if somebody has an idea thank you very much.. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
