java用jxl实现导出execl表格

//先将需要导出的数据放到list中

//然后将list中的数据放到execl表中

 

@RequestMapping(params="exportExecl")
    public String exportExecl( HttpServletRequest request) throws IOException{
        List<Lanmu> list=new ArrayList<Lanmu>();
        list=lanmuBiz.findLmxx();
        int sure = ExcelUtils.createExcel(list,request);//生成execl
        if(sure==200){
            File file=new File("F://myeclipse+tomcat+jdk//apache-tomcat-7.0.26//webapps//Manage_ssm//exportLanmuExcel");
            Desktop.getDesktop().open(file);//打开文件所在位置
            return "redirect:lmxx.do?findLmxx";
            
        }else{
            return "view/luntan/errorExcel";
        }
    }
    

public class ExcelUtils {
    
    private static final int SUCCESS = 200;
    private static final int FAIL = 500;
    
    public static int createExcel(List<Lanmu> list, HttpServletRequest req) {
        try {
            String path = "/exportLanmuExcel";
            path = req.getSession().getServletContext().getRealPath(path);
    
            File file  = new File(path);
            if(!file.exists()){
                file.mkdirs();
            }
            OutputStream os = new FileOutputStream(path + "/" + "lanmuList" + ".xls");
            //创建工作薄
            WritableWorkbook workbook = Workbook.createWorkbook(os);
            //创建新的一页
            WritableSheet sheet = workbook.createSheet("First Sheet", 0);
            //构造表头
            sheet.mergeCells(0, 0, 2, 0);//添加合并单元格，第一个参数是起始列，第二个参数是起始行，第三个参数是终止列，第四个参数是终止行
            WritableFont bold = new WritableFont(WritableFont.ARIAL,12,WritableFont.BOLD);//设置字体种类和黑体显示,字体为Arial,字号大小为10,采用黑体显示
            WritableCellFormat titleFormate = new WritableCellFormat(bold);//生成一个单元格样式控制对象
            titleFormate.setAlignment(jxl.format.Alignment.CENTRE);//单元格中的内容水平方向居中
            titleFormate.setVerticalAlignment(jxl.format.VerticalAlignment.CENTRE);//单元格的内容垂直方向居中
            Label title = new Label(0,0,"lanmuList",titleFormate);
            sheet.setRowView(0, 600, false);//设置第一行的高度
            sheet.addCell(title);           
            //设置每一列的宽度
            for(int i=0;i<=2;i++){
                 sheet.setColumnView(i, 15);
            }
     
            //创建要显示的具体内容
            WritableFont color = new WritableFont(WritableFont.ARIAL,10,WritableFont.BOLD);//选择字体
            WritableCellFormat colorFormat = new WritableCellFormat(color);
            Label a1 = new Label(0,1,"序号",colorFormat);
            sheet.addCell(a1);
            Label a2 = new Label(1,1,"栏目名称",colorFormat);
            sheet.addCell(a2);
            Label a3 = new Label(2,1,"栏目状态",colorFormat);
            sheet.addCell(a3);
           
            //获取数据，将数据赋值到execl表格中
            for (int i = 2; i < list.size()+2; i++) {
                Lanmu ap = list.get(i-2);
                int xh = i-2; 
                String name = ap.getName(); 
                String state=ap.getState();
                if("1".equals(state)){
                    state = "普通用户栏目";
                }else{
                    state = "管理员栏目";
                }
    
                // 创建第一个sheet
                Label b1 = new Label(0,i,xh+"");
                sheet.addCell(b1);
                Label b2 = new Label(1,i,name);
                sheet.addCell(b2);
                Label b3 = new Label(2,i,state);
                sheet.addCell(b3);
              
            
            }
            //把创建的内容写入到输出流中，并关闭输出流
            workbook.write();
            workbook.close();
            os.close();
            return SUCCESS;
        } catch (Exception e) {
            e.printStackTrace();
            return FAIL;
        }
        
    }

}