• Post Reply Bookmark Topic Watch Topic
  • New Topic

deleting blank row or null row in java ( HSSF)  RSS feed

 
swapnil kataria
Ranch Hand
Posts: 64
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!