rocket mass heater kickstarter
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


Win a copy of Elasticsearch in Action this week in the Big Data forum!
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

 
Don't get me started about those stupid light bulbs.
 
subject: deleting blank row or null row in java ( HSSF)