java导出Excel

public boolean exportExcel(HttpServletResponse response, List list){
        try
        {
            SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmss");
            String filename = sdf.format(new Date())+".xls";
            OutputStream os = response.getOutputStream();// 取得输出流  
            response.reset();// 清空输出流  
            response.setHeader("Content-disposition", "attachment; filename="+filename);// 设定输出文件头  
            response.setContentType("application/vnd.ms-excel");// 定义输出类型
               
            WritableWorkbook wbook = Workbook.createWorkbook(os); // 建立excel文件  
            String tmptitle = ""; // 标题  
            WritableSheet wsheet = wbook.createSheet(tmptitle, 0); // sheet名称 
               
            WritableFont wfont = new jxl.write.WritableFont(WritableFont.ARIAL, 14,WritableFont.BOLD,
                               false, UnderlineStyle.NO_UNDERLINE,Colour.BLACK);  
            WritableCellFormat wcfFC = new WritableCellFormat(wfont); 
            wcfFC.setBackground(Colour.WHITE);

            // 开始生成主体内容               
            wsheet.addCell(new Label(0, 0, ""));  
            wsheet.addCell(new Label(1, 0, "")); 

            for(int i=0;i<list.size();i++){  
                List temp = (List)list.get(i);
                wsheet.addCell(new Label(0, i+1, (String)temp.get(0)));   

                wsheet.addCell(new Label(1, i+1, (String)temp.get(1)));  

            }          
            // 主体内容生成结束          
            wbook.write(); // 写入文件  
            wbook.close(); 
            os.close(); // 关闭流
            return true;
        } catch(Exception e) {
            log.error(e.getMessage());
            return false;
        }

    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值