Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem crossing over excel file

 
nomeaning
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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<de celdas>);
objeto2 = new Objeto2(ArrayList<de celdas>);
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..

Jadler.
 
Abhishek Makkar
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try working with the following method snippet, pass a worksheet with following code to get the value, then you can use any collection and populate the db

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic