Jxl操作Excel

注意分为三个部分:前台上传页面，控制层，bean层

前台上传页面upload.jsp

<form action="uuFile.action" enctype="multipart/form-data" method="post">//文件上传一定要加上enctype="multipart /form-data"
        <input type="file" name="excelfile">
        <input type="submit" value="上传">
</form>

excel对应的模型:excel.java

    private int number;
    private int id;
    private String name;
    ...

处理excel的类JxlReadExcel.java 中的读取方法

public static List<Excel> doread(File file){
    Workbook workbook=Workbook.getWorkbook(file);
        Sheet sheet=workbook.getSheet(0);
        Excel e=null;
        List<Excel> list=null;
        //检查是否符合一定的格式
        if((sheet.getCell(0, 0).getContents().equals("id"))&&(sheet.getCell(1, 0).getContents().equals("name"))&&(sheet.getCell(2, 0).getContents().equals("number"))){
            e=new Excel;
            for(int i=0;i<sheet.getRows();i++){
                e.setId(Integer.parseInt(sheet.getCell(0, i).getContents()));  //获取的数据全为String
                    e.setName(sheet.getCell(1,i).getContents());
                    e.setNumber(Integer.parseInt(sheet.getCell(2, i).getContents()));
                    list.add(e);
            }
        }

        workbook.close();
        return list;
}

利用struts2获取文件及相关判断 UploadFile.java

    private File excelfile;
    private String excelfileFileName;
    private List<Excel> list;

    public File getExcelfile() {
        return excelfile;
    }

    public void setExcelfile(File excelfile) {
        this.excelfile = excelfile;
    }
    public String getExcelfileFileName() {
        return excelfileFileName;
    }

    public void setExcelfileFileName(String excelfileFileName) {
        this.excelfileFileName = excelfileFileName;
    }

    public List<Excel> getList() {
        return list;
    }

    public void setList(List<Excel> list) {
        this.list = list;
    }

    @Override
    public String execute() throws Exception {
        // TODO Auto-generated method stub
        System.out.println("zzx "+excelfile);
        System.out.println("zzx"+excelfileContentType);
        System.out.println(excelfileFileName.substring(excelfileFileName.lastIndexOf(".")+1));   //获得扩展名，可进行判断
        System.out.println("zzx"+excelfileFileName);
        list=new JxlReadExcel().main(excelfile);
        if(list==null){
            System.out.println("有错");
            return ERROR;
        }
        return SUCCESS;
    }