AUTOPOI导入Excel文件(可获取表头数据)
Controller.java部分代码
@Autowired
private IAshContentService ashContentService;
public Result<?> importExcel(HttpServletRequest request, HttpServletResponse response) throws IOException {
MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
Map<String, MultipartFile> fileMap = multipartRequest.getFileMap();
for (Map.Entry<String, MultipartFile> entity : fileMap.entrySet()) {
MultipartFile file = entity.getValue();
InputStream inputStream = file.getInputStream();
HSSFWorkbook wb = new HSSFWorkbook(inputStream);
HSSFSheet sheetAt = wb.getSheetAt(0);
Row