I'm using the Apache POI library, but I have some data that I don't want to be read - So I need the program to start reading the file from a specific row.
I want all the data from the cells and rows which comes after row 10, until the document is empty. I have tried with the following code.
Workbook workbook = new XSSFWorkbook(inputStream);
Sheet firstSheet = workbook.getSheetAt(0);
Iterator<Row> iterator = firstSheet.iterator();
Row getSchool = firstSheet.getRow(10);
Iterator<Cell> cellIterator = getSchool.cellIterator();
while (iterator.hasNext())
{
while (cellIterator.hasNext())
{
...
}
}
But it will only give me all the data from the cells in row 10.
I'll be looking forward to hear from you :-).
See Question&Answers more detail:os