java生成excel文件

首先下载jexcelapi_2_6_12.tar.gz，解压后将里面的jxl.jar复制到WEB-INF/lib目录下面
　　　　 String filePath = request.getParameter("filePath");
        filePath=filePath.replaceAll("\\\\", "/");
        FileOutputStream os = new FileOutputStream(new File(filePath));
       //创建工作薄
        WritableWorkbook workbook = Workbook.createWorkbook(os);
        //创建新的一页
        WritableSheet sheet = workbook.createSheet("First Sheet",0);
        //创建要显示的内容,创建一个单元格，第一个参数为列坐标，第二个参数为行坐标，第三个参数为内容
        try{
            ResultSet rs = null;
            SQLBean dbMsg = new SQLBean();
            dbMsg.getConncetion();
            dbMsg.getStatement();
            String sql = request.getParameter("sql");
            rs = dbMsg.getResultSet(sql);
            Label tmp = new Label(0,0,"园类型");
            sheet.addCell(tmp);
            tmp = new Label(1,0,"楼标号");
            sheet.addCell(tmp);
            tmp = new Label(2,0,"用户名");
            sheet.addCell(tmp);
            tmp = new Label(3,0,"联系方式");
            sheet.addCell(tmp);
            tmp = new Label(4,0,"订餐类型");
            sheet.addCell(tmp);
            tmp = new Label(5,0,"订餐名称");
            sheet.addCell(tmp);
            tmp = new Label(6,0,"订餐份数");
            sheet.addCell(tmp);
            tmp = new Label(7,0,"支付总金额");
            sheet.addCell(tmp);
            tmp = new Label(8,0,"付款方式");
            sheet.addCell(tmp);
            tmp = new Label(9,0,"订单时间");
            sheet.addCell(tmp);
            int row = 0;
            while(rs.next()){
                ++row;
                for(int i=1; i<=10; ++i){
                    tmp = new Label(i-1,row, rs.getString(i));
                    sheet.addCell(tmp);
                }
            }
        } catch (Exception e){
            out.println("数据生成错误!");
        } finally{
            //把创建的内容写入到输出流中，并关闭输出流
            workbook.write();
            workbook.close();
            os.close();
        }