JSP-读取Excel(JAVA)

读取Excel入库

前端用插件，后端用流读取，废话不多说直接上代码:

后端接收

public String importBusinExcel(HttpServletRequest request, String operater) {
   
        try {
   
            MultipartHttpServletRequest multipartRequest = (MultipartHttpServletRequest) request;
            List<MultipartFile> fileList = multipartRequest.getFiles("excel");
            String type = fileList.get(0).getOriginalFilename();
            if (type.endsWith(".xls"))
                type = "xls";
            else if (type.endsWith(".xlsx"))
                type = "xlsx";
            File file = new File("temp");
            FileUtils.copyInputStreamToFile(fileList.get(0).getInputStream(), file);

            List<BusinOrderVo> list = new ArrayList<>();

            if (type.equals("xls")) {
   
                FileInputStream fs = new FileInputStream(file);
                HSSFWorkbook workbook = new HSSFWorkbook(fs);
                HSSFSheet sheet = workbook.getSheetAt(0);

                for (int i = 1; i <= sheet.getLastRowNum(); i++) {
   
                    Row row = sheet.getRow