i am trying to read Excel Sheet in
java,
autally it has 4 rows containing data,
but when I tries to get value of total no. of rows by using
sheet.getLastRowNum()
it returns 9,
then i print the row reference in a loop, it shows row no. 8 and 9 as null but from 5 to 9 each row is actually blank,
for 5,6,7 it prints object value
for 8,9 it prints null,
is there is way to remove such rows before start reading