aspose file tools*
The moose likes Other Java Products and Servers and the fly likes deleting blank row or null row in java ( HSSF) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "deleting blank row or null row in java ( HSSF)" Watch "deleting blank row or null row in java ( HSSF)" New topic
Author

deleting blank row or null row in java ( HSSF)

swapnil kataria
Ranch Hand

Joined: Feb 26, 2011
Posts: 64
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

 
It is sorta covered in the JavaRanch Style Guide.
 
subject: deleting blank row or null row in java ( HSSF)