欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

java导出Excel,

来源: javaer 分享于  点击 37807 次 点评:252

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;
        }

    }

相关文章

    暂无相关文章
相关栏目:

用户点评