wood burning stoves 2.0*
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 Murach's Java Servlets and JSP this week in the Servlets 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

 
Consider Paul's rocket mass heater.
 
subject: deleting blank row or null row in java ( HSSF)
 
Similar Threads
strange checkbox problem
GridLayout with less/more components.
Dirty read is experienced for the same thread????
How to replace the value in a row with previous row value if it is null or 0.
Need some help!!!