public List<List<List<String>>> uploadExcel(String filePath) throws FileNotFoundException { //两种方式,一种直接上传的文件MultipartFile,一种用本地的文件:File File file2 = new File(filePath); InputStream inputStream = new FileInputStream(file2); List<List<List<String>>> list = null; try { XSSFWorkbook wb = new XSSFWorkbook(inputStream); list = ExcelReadUtils.getData(wb, 0, null);//3个参数。 } catch (Exception e) { log.info("文件读取失败"); } finally { if (inputStream != null) { try { inputStream.close(); } catch (Exception e) { log.info("文件流关闭失败"); } inputStream = null; } } return list; // return new Result(list);//读取到的list(表(行(列))),直接返回,也可以按需求做别的操作。 }
标签:java,读取,list,excel,inputStream,File,new,sheet,null From: https://www.cnblogs.com/wj123bk/p/17411536.html