表单/ajax上传excel文件

form表单提交：

<form id="upload-form" method="post" action="/import" enctype="multipart/form-data">
    <div>
        <input type="file" name="excelfile" id="excelfile"/>
        <input type="hidden" name="fileType" value="10"/>
    </div>
    <input type="submit"  id="upload" value="上传"/>
</form>

ajax异步上传：

<form id="upload-form" method="post" action="/import" enctype="multipart/form-data">
    <input type="file" name="excelfile" id="excelfile" value="" />
    <input type="hidden" name="fileType" value="10">
    <input type="button"  id="upload" value="上传"/>
</form>

js:
    $("#upload").click(function(){
        var formdata = new FormData(document.getElementById("upload-form"));
        $.ajax({
            url:"/import",
            type:"post",
            data:formdata,
            contentType:false, //- 必须false才会自动加上正确的Content-Type
            processData: false, //- 必须false才会避开jQuery对 formdata 的默认处理,XMLHttpRequest会对 formdata 进行正确的处理
            success:function(){
                alert("ok");
            },
            error:function(){
                alert("fail");
            }
        });
    });

后台代码：

    @RequestMapping(value = "/import")
    public ModelAndView importExcel(@RequestParam(value = "excelfile") MultipartFile file, String fileType,         HttpServletRequest request){
        try {
            List<Map> list = readExcelFile(file);
        } catch (Exception e) {
            e.printStackTrace();
        }
        ModelAndView mv = new ModelAndView("search");
        return mv;
    }

    private List<Map> readExcelFile(MultipartFile file) throws Exception {

        String fileName = file.getOriginalFilename();//获取文件名
        long size = file.getSize();
        String format = fileName.substring(fileName.lastIndexOf(".")+1);
        System.out.println("文件名:"+fileName+",大小:"+size/1024+"kb,格式:"+format);

        Workbook workbook = null;
        InputStream inputStream = file.getInputStream();
        //- excel 2003
        if("xls".equals(format)){
            workbook = new HSSFWorkbook(inputStream);
        }else if ("xlsx".equals(format)){
            workbook = new XSSFWorkbook(inputStream);
        }else {
            throw new Exception("文件格式非法！");
        }
        /** 读取第一个sheet */
        List<Map> result = new ArrayList<>();
        int sheets = workbook.getNumberOfSheets();
        if(sheets > 0){
            Sheet sheet = workbook.getSheetAt(0);
            result = readSheet(sheet);
        }
        inputStream.close();
        return result;
    }

    /**
     * 解析sheet.
     *     sheet前三列分别为对应到bean的字段、字段类型、excel表头
     *
     * @param sheet
     * @return
     */
    private List<Map> readSheet(Sheet sheet) {
        List<Map> result = new ArrayList<Map>();
        int totalRows = sheet.getPhysicalNumberOfRows();//- Excel行数
        int totalCells = 0;//- Excel列数
        String[] fields = null; //- 存储对应bean的字段名称
        Row firstRow = sheet.getRow(0);
        if (totalRows > 0 && firstRow != null) {
            totalCells = firstRow.getPhysicalNumberOfCells();
            fields = new String[totalCells];
            for (int c = 0; c < totalCells; c++) {
                fields[c] = firstRow.getCell(c).getStringCellValue();
            }
        }else
            return result;

        /** 循环Excel的行, 第四行是正文开始 */
        for (int r = 4; r < totalRows; r++) {
            Row row = sheet.getRow(r);
            if (row == null){
                continue;
            }
            Map map = new HashMap();
            /** 循环Excel的列 */
            for (int c = 0; c < totalCells; c++) {
                Cell cell = row.getCell(c);
                if (null != cell) {
                    //- cell是数值类型
                    if(cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC){
                        map.put(fields[c], cell.getNumericCellValue());
                    }
                    //- cell是字符串类型
                    else if(cell.getCellType() == HSSFCell.CELL_TYPE_STRING){
                        map.put(fields[c], cell.getStringCellValue());
                    }
                }
            }
            result.add(map);
        }
        return result;
    }

处理excel的maven依赖：

    <dependency>
       <groupId>org.apache.poi</groupId>
        <artifactId>poi</artifactId>
        <version>3.12</version>
        <exclusions>
            <exclusion>
                <artifactId>commons-codec</artifactId>
                <groupId>commons-codec</groupId>
            </exclusion>
        </exclusions>
    </dependency>
    <dependency>
        <groupId>org.apache.poi</groupId>
        <artifactId>poi-ooxml</artifactId>
        <version>3.12</version>
    </dependency>