<%@ page pageEncoding="utf-8" %>

<%@ page language="java" contentType="text/html; charset=GBK" %><%@ page import="java.util.*" %>

<%@ page import="java.io.OutputStream" %>

<%@ page import="jxl.Workbook" %>

<%@ page import="jxl.write.WritableCellFormat" %>

<%@ page import="jxl.write.WritableSheet" %>

<%@ page import="jxl.write.WritableWorkbook" %>

<%@ page import="jxl.write.WriteException" %>

<%@ page import="java.text.SimpleDateFormat" %>

<%  

    response.reset();

    response.setContentType("application/vnd.ms-excel");

    response.setHeader("Content-Disposition", "filename=Member.xls");//attachment// WritableWorkbook是JexcelApi的一个类。

// 以下可以理解为创建一个excel文件，然后在excel里面创建一个表

    OutputStream os = response.getOutputStream();//取得输出流

    WritableWorkbook workbook = Workbook.createWorkbook(os);

    WritableSheet sheet = workbook.createSheet("First Sheet", 0);// 组织excel文件的内容

    jxl.write.Label label = null;

    int excelCol = 0;

    int row = 0;

    try {

        label = new jxl.write.Label(excelCol++, row, "帐号");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "姓名");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "身份证");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "联系电话");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "生日");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "城市");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "职业");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "已购音箱型号");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "试听与否");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol++, row, "邮箱");

        sheet.addCell(label);

        label = new jxl.write.Label(excelCol, row, "注册时间");

        sheet.addCell(label);

        //jxl.write.Number number = null;

        jxl.write.DateTime dateTime;

        jxl.write.DateFormat customDateFormat = new jxl.write.DateFormat("yyyy-MM-dd");//时间格式

        WritableCellFormat dateFormat = new WritableCellFormat(customDateFormat);        for(int i=0;i<10;i++){

            excelCol = 0;

            row = i + 1;            SimpleDateFormat formatDate = new SimpleDateFormat("yyyy-MM-dd");     

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            /*字串格式*/

            try{

                label = new jxl.write.Label(excelCol++, row, formatDate.format("100"));

                sheet.addCell(label);

            }catch (Exception e){

                //Maybe somebody fogot to input his birthday ,I need do nothing here!

            }            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            label = new jxl.write.Label(excelCol++, row, "100");

            sheet.addCell(label);            /*时间格式*/

         

                    //label = new jxl.write.Label(excelCol, row, formatDate.format(rr.getCreateTime()));

            //sheet.addCell(label);

        }

    } catch (Exception e) {

        e.printStackTrace();

    } finally{

//      生成excel文件

        workbook.write();

        workbook.close();

        os.close();

    }

%>