In order to display multiple records on the excel file, make sure to use the same HSSFRow object for both the column heading and column values. In other words, change the line
HSSFRow row = sheet.createRow((short)index); to rowhead = sheet.createRow((short)index);