File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "problem crossing over excel file" Watch "problem crossing over excel file" New topic

problem crossing over excel file


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:


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..

Abhishek Makkar

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
I agree. Here's the link:
subject: problem crossing over excel file
It's not a secret anymore!