jxl自己写的例子

public String writeExcel(){
        Workbook  book = null;
        Cell cell =null;
        try {
            //打开文件
            book = Workbook.getWorkbook(file);
            //获得第一个工作表对象
            Sheet sheet = book.getSheet(0);
            int rows = sheet.getRows();
            //遍历单元格
            for(int i = 1;i<rows;i++){
                    districtTest=new DistrictTest();
                
                    cell = sheet.getCell(1, i);
                    districtTest.setDistrictName(cell.getContents().toString());
                    cell = sheet.getCell(2, i);
                    districtTest.setCode(cell.getContents().toString());
                    
                    districtTest.setCreateTime(new Date());
                    districtTest.setUpdateTime(new Date());
                    districtTest.setIsDele(0);
                    this.utilService.save(districtTest);
                    
            }
            flag="1";
            return "districtTest_show0";
        } catch (Exception e) {
            // TODO: handle exception
            Loggers.error("----DistrictTestAction的writeExcel方法错误"+e.getMessage());
            e.printStackTrace();
        }
        return ERROR;
    }

//导出excel
    public String exportExcel(){
        WritableWorkbook workbook = null;
        HttpServletResponse response =ServletActionContext.getResponse();
        response.setHeader("Content-Disposition", "attachment; filename="+
        "excel0"+".xls"); 
        try {
            String hql = "from DistrictTest where isDele=0";
            //workbook = Workbook.createWorkbook(new File("E:/yang.xls"));
            districtTestList =  (List<DistrictTest>) utilService.getHqlAll(hql);
            outputStream = response.getOutputStream();
            workbook = Workbook.createWorkbook(outputStream);
            WritableSheet sheet = workbook.createSheet("sheet1", 0);
            Label label = new Label(0, 0, "序号");
            Label label1 = new Label(1, 0, "区县名称");
            Label label2 = new Label(2, 0, "编码");
            sheet.addCell(label);
            sheet.addCell(label1);
            sheet.addCell(label2);
            for(int i=0;i<districtTestList.size();i++){
                int j = i;
                Label label3 = new Label(0, i+1, " "+(++j));
                sheet.addCell(label3);
                if(districtTestList.get(i).getDistrictName()!=null&&!" ".equals(districtTestList.get(i).getDistrictName())){
                
                    Label lable4 = new Label(1, i+1, districtTestList.get(i).getDistrictName().toString());
                    sheet.addCell(lable4);
                }else{
                    
                    Label lable4 = new Label(1, i+1, " ");
                    sheet.addCell(lable4);
                }
                if(districtTestList.get(i).getCode()!=null&&!" ".equals(districtTestList.get(i).getCode())){
                    Label lable5 = new Label(2, i+1, districtTestList.get(i).getCode().toString());
                    sheet.addCell(lable5);
                }else{
                    Label lable5 = new Label(2, i+1, " ");
                    sheet.addCell(lable5);
                }
            }
            workbook.write();
            outputStream.flush();
            
            System.out.println("下载excel成功");
            flag="1";
            return districtList();
        } catch (Exception e) {
            // TODO: handle exception
            Loggers.error("----DistrictTestAction的exportExcel方法错误"+e.getMessage());
            e.printStackTrace();
        }finally{
            if(workbook!=null){
                try {
                    workbook.close();
                } catch (Exception e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                } 
            }
            if(outputStream!=null){
                try {
                    outputStream.close();
                } catch (IOException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
        
        }
        
        
        
        
        return ERROR;
    }