java中使用jxl导出excel总结

 这两天用到jxl导出excel，总结一下。

使用的jar包  jxl-2.4.2.jar            

 String fileName = "dev_status_" + date + ".xls";
               
                // 设置输出的格式
                response.reset();
                response.setContentType("bin");
                response.addHeader("Content-Disposition", "attachment; filename=\"" + fileName + "\"");
                //数据流
                os= response.getOutputStream();
          

           WritableWorkbook  wbook = Workbook.createWorkbook(os);
            // 建立excel文件，工作表名称
            WritableSheet wsheet = wbook.createSheet("exportList", 0);
           
            //设置列宽  列坐标  列宽大小
            wsheet.setColumnView(0, 6);
            wsheet.setColumnView(1, 15);
            wsheet.setColumnView(2, 35);
           
            //冻结前三列和第一行
            SheetSettings ss = wsheet.getSettings();
            //冻结第一行
            ss.setVerticalFreeze(1);
            //冻结前三列
            ss.setHorizontalFreeze(3);
           
            // // 定义格式 字体 下划线 斜体 粗体 颜色
            WritableFont wfont =
                new WritableFont(WritableFont.ARIAL, 11, WritableFont.BOLD, false,
                    jxl.format.UnderlineStyle.NO_UNDERLINE, jxl.format.Colour.BLACK);
           
            // 单元格定义
            WritableCellFormat titleFormat = new WritableCellFormat(wfont);
           
            //居中
            titleFormat.setAlignment(jxl.format.Alignment.CENTRE);
            titleFormat.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);
            //自动换行设置
            titleFormat.setWrap(true);

 

使用方法：
          //列坐标，行坐标，单元格内容，单元格格式

          Label   label = new Label(0, 0, no, titleFormat);