aspose file tools*
The moose likes Other Java Products and Servers and the fly likes problem crossing over excel file Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "problem crossing over excel file" Watch "problem crossing over excel file" New topic
Author

problem crossing over excel file

nomeaning
Greenhorn

Joined: Sep 16, 2005
Posts: 21
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

Joined: Aug 11, 2006
Posts: 22
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



I know nothing except the fact of my ignorance. -Socrates
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: problem crossing over excel file