HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("FileName");
// Create a row and put some cells in it. Rows are 0 based.
int i=1;
i++;
HSSFRow row = sheet.createRow((short)i);

row.createCell((short)0).setCellValue("");
row.createCell((short)1).setCellValue("Headings");
i++;

row=sheet.createRow((short)i);
row.createCell((short)0).setCellValue("");
i++;

row=sheet.createRow((short)i);
row.createCell((short)0).setCellValue("");
row.createCell((short)1).setCellValue("Column Name1");
row.createCell((short)2).setCellValue("Column Name2");
.
.// all the row and column like above
.
// Write the output to a file
String savepath="";
ServletContext sc = getServletConfig().getServletContext();

//Code for creating a folder
String path=getServletContext().getRealPath("/");
File f1 = new File(path + "/Excel Export");
if(!f1.exists())
{
f1.mkdir();
}
savepath = sc.getRealPath("/") "Excel Export/""ShareholdingReport.xls";

FileOutputStream fileOut = new FileOutputStream(savepath);
wb.write(fileOut);
fileOut.close();
fileOut=null;
sheet=null;
wb=null;
//End Excel Export