/**
* @author CaptainFM
* 读取 excel表格,兼容2003和2007
*/
@ApiResponses({
@ApiResponse(code = 200,message = “导入成功”),
@ApiResponse(code = 3012,message = “失败”),
})
//查询公司人员配置
@RequestMapping(value = “/excle”)
public Result excle (@RequestParam Integer id, HttpServletRequest request, @RequestParam(name = “file”) MultipartFile file) throws Exception {
String suffix= file.getOriginalFilename().substring(file.getOriginalFilename().lastIndexOf("."));
if (!suffix.equals(".xls") && !suffix.equals(".xlsx")) {
System.out.println("文件类型错误");
}
try {
//以输入流创建一个excel工作簿
Workbook workbook = Workbook.getWorkbook(file.getInputStream());
//取第一个工作表,getRows取到工作表的行数
Sheet sheet = workbook.getSheet(0);
for(int i = 1;i<sheet.getRows();