public RestResult annualStatisticToLeadInto(@RequestParam("file") MultipartFile file, @RequestParam("userGuid") String userGuid){
try{
DataResult result = service.insertByExcel(file,userGuid);
if(result.isSuccess()) {
return RestResult.success(result.getMessage());
}else{
return RestResult.fail(result.getMessage());
}
}catch (Exception e){
return RestResult.fail("导入失败");
}
}
public DataResult insertMarjorProjectByExcel(MultipartFile file, String userGuid) {
try {
String fileName = file.getOriginalFilename();
String fileExt = fileName.substring(fileName.lastIndexOf("."));
if (fileExt.equals(xlsx)){
XSSFWorkbook xssfWorkbook = new XSSFWorkbook(file.getInputStream());
XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0);
Integer maxRowNum = xssfSheet.getLastRowNum();
for(int i = 5; i <= maxRowNum; i++){
//检查此行是否是有效数据
XSSFRow xssfRow = xssfSheet.getRow(i);
if(isRowEmpty(fileExt,xssfRow)) {
break;
}
XSSFCell firstCell = xssfRow.getCell(1);
firstCell.setCellType(CellType.STRING);
String mergedRegionValue = null
String name = firstCell.getStringCellValue();
Boolean region = isMergedRegion(xssfSheet, i, 1);
if(workTaskRegion){
mergedRegionValue = getMergedRegionValue(xssfSheet, i, 1);
}else {
mergedRegionValue = name;
}
//写插入数据库的过程
}
}
return DataResult.success("新增成功");
}catch (Exception e){
// TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
return null;
}
}