Ola a todos, tenho uma função que faz a leitura de um arquivo xlsx e armazena o conteúdo em variáveis
// Faz a leitura do arquivo Excel
FileInputStream fis = new FileInputStream(new File(xml));
List<Filmes> listaFilmes = new ArrayList<Filmes>();
XSSFWorkbook workbook = new XSSFWorkbook(fis);
XSSFSheet sheet = workbook.getSheetAt(0);
Iterator<Row> rowInterator = sheet.iterator();
while (rowInterator.hasNext()) {
Row row = rowInterator.next();
Iterator<Cell> cellIterator = row.cellIterator();
listaFilmes.add(video);
while (cellIterator.hasNext()) {
Cell cell = cellIterator.next();
switch (cell.getColumnIndex()) {
case 0:
video.setTitle(cell.getStringCellValue());
break;
case 1:
video.setEpisode(cell.getNumericCellValue());
break;
case 2:
video.setRatings(cell.getStringCellValue());
break;
case 3:
video.setReleaseYear(cell.getNumericCellValue());
break;
case 4:
video.setRuntime(cell.getNumericCellValue());
break;
case 5:
video.setStudios(cell.getStringCellValue());
break;
case 6:
video.setProgramType(cell.getStringCellValue());
break;
case 7:
video.setGenre(cell.getStringCellValue());
break;
case 8:
video.setSynopsisSmall(cell.getStringCellValue());
break;
case 9:
video.setSynopsisMedium(cell.getStringCellValue());
break;
case 10:
video.setSynopsisLarge(cell.getStringCellValue());
break;
case 11:
video.setSynopsisExtraLarge(cell.getStringCellValue());
break;
case 12:
video.setCast(cell.getStringCellValue());
break;
case 13:
video.setMember(cell.getStringCellValue());
break;
case 14:
video.setCrew(cell.getStringCellValue());
break;
}
}
if (listaFilmes.size() == 0) {
System.out.print("Nenhum dado encontrado");
} else {
video.getTitle();
video.getEpisode();
video.getRatings();
video.getReleaseYear();
video.getRuntime();
video.getStudios();
video.getProgramType();
video.getGenre();
video.getSynopsisSmall();
video.getSynopsisMedium();
video.getSynopsisLarge();
video.getSynopsisExtraLarge();
video.getCast();
video.getMember();
video.getCrew();
video.getArtifacts();
}
}
workbook.close();
o problema é que ele esta pegando somente a ultima linha do arquivo, e gostaria que pegasse a partir da segunda linha em diante,