@Data
public class importUserPj extends BaseRowModel {
@ExcelProperty(value = "工号",index = 0)
@NumberFormat(value = "0")
private String jobCode;
@ExcelProperty(index = 1)
private String nickName;
@ExcelProperty(index =2)
private String joinTimeStr;
@ExcelProperty(index =3)
private String xueLi;
@ExcelProperty(index =4)
private String ziGe;
@ExcelProperty(index =5)
private String zhiWu;
}
@Slf4j
@Data
@NoArgsConstructor
@AllArgsConstructor
public class ExcelListener<T> extends AnalysisEventListener<T> {
private List<T> dataList = new ArrayList<>();
private T titleMap;
@Override
public void invoke(T result, AnalysisContext context) {
Integer rowIndex = context.readRowHolder().getRowIndex();
if (rowIndex == 0) {
this.titleMap = result;
} else {
if (result instanceof QuestionsExcelData) {
}
dataList.add(result);
}
log.info("解析数据第{}行,数据为:{}", rowIndex, result);
}
@Override
public void doAfterAllAnalysed(AnalysisContext analysisContext) {
log.info("解析完成!");
}
}
@RestController
@RequestMapping("/system/user")
public class importUser {
@PostMapping("/importData")
public BaseResult importu(MultipartFile file, boolean updateSupport) throws IOException {
InputStream inputStream = file.getInputStream();
ExcelListener listener = new ExcelListener();
ExcelReader excelReader = new ExcelReader(inputStream, ExcelTypeEnum.XLS, null, listener);
excelReader.read(new Sheet(2, 1, importUserPj.class));
List<importUserPj> list = listener.getDataList();
return null;
}
}