writeexcel.jsp

来自「J2EE独立开发制作」· JSP 代码 · 共 55 行

<%@ page language="java"  contentType ="text/html;charset=gb2312" %> 
 <%@ page import= "java.util.*,org.apache.poi.hssf.usermodel.HSSFWorkbook,org.apache.poi.hssf.usermodel.HSSFSheet,org.apache.poi.hssf.usermodel.HSSFRow,org.apache.poi.hssf.usermodel.HSSFCell,java.io.* " %> 
 <% 
    HSSFWorkbook wb  =   new  HSSFWorkbook();
    HSSFSheet sheet  =  wb.createSheet( " sheet1 " );

     // 以下以写表头
     // 表头为第一行 
     HSSFRow row  =  sheet.createRow(( short )0);

    HSSFCell cell1  =  row.createCell(( short )0);
    HSSFCell cell2  =  row.createCell(( short )1);
    HSSFCell cell3  =  row.createCell(( short )2);

    cell1.setEncoding(( short )1);
    cell1.setCellType( 1 );
    cell2.setEncoding(( short )1);
    cell2.setCellType( 1 );
    cell3.setEncoding(( short )1);
    cell3.setCellType( 1 );

     // 定义表头的内容 
     cell1.setCellValue( " 测试 " );
    cell2.setCellValue( " 测试2 " );
    cell3.setCellValue( " 测试3 " );

     for  ( int i = 0 ; i < 4 ; i ++ )   {
         // 定义数据从第二行开始        
         row  =  sheet.createRow(( short ) i  +   1 );
        cell1  =  row.createCell(( short )  0 );
        cell2  =  row.createCell(( short )  1 );
        cell3  =  row.createCell(( short )  2 );

        cell1.setEncoding(( short )1);
        cell1.setCellType( 1 );
        cell2.setEncoding(( short )1);
        cell2.setCellType( 1 );
        cell3.setEncoding(( short )1);
        cell3.setCellType( 1 );

         // 填充内容 
 
        cell1.setCellValue( " ggg " );
        cell2.setCellValue( " 00000 " );
        cell3.setCellValue( " sun " );

    } 
	String filename=application.getRealPath("/")+"test.xls";
	FileOutputStream fo=new FileOutputStream(filename);
    wb.write(fo);
	out.println("excel 文件生成，存放在"+filename);
    
	
 %>