mos-excel集成文档

mos-excel集成文档
spring boot 集成
添加依赖

<dependency>
   <groupId>org.mos.excel</groupId>
   <artifactId>mos-excel</artifactId>
   <version>1.0.0-20200807.024930-1</version>
</dependency>

代码使用

controller:
@ApiOperation("Excel数据导入")
@RequestMapping("importExcel.do")
@ResponseBody
public RestResponse importExcel(@RequestParam(value = "file") MultipartFile excelFile,
                                   @RequestParam(value = "busId") String busId, HttpSession session) {
    List<Object> importDataList = ExcelUtil.readExcel(excelFile, new ImportDataBo());
    // 根据业务自行 do something
}

业务对象ImportDataBo.java
/**
 * 用户数据对象
 * 
 * @author Lee
 */
public class ImportDataBo extends BaseRowModel {
    /**
     * 用户姓名
     */
    @ExcelProperty(index = 0)
    private String userName;
    /**
     * 地址
     */
    @ExcelProperty(index = 1)
    private String userAddress;
    public String getUserName() {
        return userName;
    }
    public String getUserAddress() {
        return userAddress;
    }
    public void setUserName(String userName) {
        this.userName = userName;
    }
    public void setUserAddress(String userAddress) {
        this.userAddress = userAddress;
    }
}