
<%@ page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@ page import="org.apache.poi.hssf.usermodel.HSSFCellStyle"%>
<%@ page import="org.apache.poi.hssf.usermodel. HSSFFooter"%>
<%@ page import="org.apache.poi.hssf.util.Region"%>
<%@ page contentType="application/vnd.ms-excel" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%
try{
    HSSFWorkbook hwb = new HSSFWorkbook();
    HSSFSheet sheet = hwb.createSheet("new sheet");
	 HSSFFooter footer = sheet.getFooter();
    footer.setRight( "Page " + HSSFFooter.page() + " of " + HSSFFooter.numPages() );
   
    for(int i=0;i<20;i++)
			{
		HSSFRow row = sheet.createRow((short) 1+i);
    
        HSSFCell cell = row.createCell((short) 1);
        cell.setCellValue("rajesh");
		}

		
         FileOutputStream fileOut = new FileOutputStream("c:\\excel\\footerExcel.xls");
        hwb.write(fileOut);
        fileOut.close();

      
  out.println("Your excel file has been generated");
            
        } catch ( Exception ex ) {
          
        }
     

%>