java - regarding the changes done in code to achieve the excel outcome -

i stuck in issue of excel generation through poi want achieve shown in picture on row 6 header should aaa , row 7 should blank , on row 8 there should header bbb , rest row 9 existing data should continue adjustments need made

i using below code

hssfrow abcrow = worksheet.createrow((short) rownumber++);         hssfcell ghjcell = abc.createcell((short)0);         ghj.setcellstyle(cellstylereportname);         ghj.setcellvalue("aaa");          rownumber++;          hssfrow abcdrow = worksheet.createrow((short) rownumber++);         hssfcell ghjj = abcdrow.createcell((short)0);         ghjj.setcellstyle(cellstyle00); 

please advise how can achieve

6th row   --->aaa 7th row   --->should blank 8th row    ---->bbb 9th row       ---> noral exisiting data 

, changes need done in code please advise

if understanding problem, can solved easily. use following:-

    worksheet1.createrow(6).createcell(0).setcellvalue("aaa");     worksheet1.createrow(8).createcell(0).setcellvalue("bbb");     worksheet1.createrow(9).createcell(0).setcellvalue("do whatever u want now"); 

this create 2 rows of 6 , 8 row number keeping 7 null. can whatever want. per suggestion, please initialize 7th row , keep blank, instead of keeping null.

please let me know not satisfying requirement.