problem crossing over excel file

[nomeaning]

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]

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

   
       int sheetCount = wb.getNumberOfSheets();
 
for(int sheetNum=0; sheetNum& lt;sheetCount; sheetNum++){
populateDB(wb.getSheetAt(sheetNum));
}
 

 
public void populateDB(HSSFSheet sheet){
 
int rowCount = sheet.getPhysicalNumberOfRows();
int lastRowCount = sheet.getLastRowNum();
int firstRowCount = lastRowCount-rowCount+1;
for(int i = firstRowCount; i& lt;=lastRowCount; i++){
HSSFRow row = sheet.getRow(i);
int cellCount = row.getPhysicalNumberOfCells();
int lastCellCount = row.getLastCellNum();
int firstCellCount = lastCellCount - cellCount + 1;
short k = 0;
for(int j = firstCellCount; j& lt;=lastCellCount; j++){
 
HSSFCell cell = row.getCell(k);
if(cell.getCellType() == cell.CELL_TYPE_NUMERIC){
if(HSSFDateUtil.isCellDateFormatted(cell)) {
Date value = cell.getDateCellValue();
}
else{
Double num = new Double(cell.getNumericCellValue());
 
}
}
 
if(cell.getCellType() == cell.CELL_TYPE_STRING){
if(k==0){
String value = cell.getStringCellValue();
}
 
else{
String value=cell.getStringCellValue();
}
 
}
 
k++;
}
 
}
 
}