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 :-).
Refer below:
Remove below condition if you are not looking for any particular column data
You're only getting the data from row 11 here:
See the documentation for Sheet.getRow(int rownum)
Check the examples in the documentation on how to Iterate over rows and cells.
You can use something like:
If you want to iterate over all cells in a row check how to Iterate over cells, with control of missing / blank cells.
The
CellIterator
will only return the cells defined in the file, which is largely those with values or stylings, but it depends on Excel.You could specify a Row.MissingCellPolicy as:
Here's an example: