JSP-读取Excel
读取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(i);