This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA 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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: deleting blank row or null row in java ( HSSF)