说明

导入和导出使用了阿里巴巴的easyexcel

• 导入和导出均支持单sheet、多sheet
• 支持字典翻译，详情见 字段字典翻译 章节
• 支持脱敏处理，详情见 字段数据脱敏 章节

使用案例

单sheet

导入

ExcelResult<TestDataImportVo> excelResult = ExcelUtil.importExcel(file.getInputStream(), TestDataImportVo.class, true);
List<TestDataImportVo> dataList = excelResult.getList();

导出

List<TestDataPageDto> list = ...;//此处省略数组如何来的
ExcelUtil.exportXlsx(response, "测试数据", "测试数据", list, TestDataPageDto.class);

多sheet

导入

ExcelReader reader = ExcelUtil.createImport(file.getInputStream());
ReadRetVo<TestSheetAVo> sheetA = ExcelUtil.readSheet("班级信息", TestSheetAVo.class, true);
ReadRetVo<TestSheetBVo> sheetB = ExcelUtil.readSheet("学生信息", TestSheetBVo.class, true);
ExcelUtil.finishRead(reader, sheetA, sheetB);

ExcelResult<TestSheetAVo> sheetAResult = ExcelUtil.transResult(sheetA);
ExcelResult<TestSheetBVo> sheetBResult = ExcelUtil.transResult(sheetB);

List<TestSheetAVo> sheetAList = sheetAResult.getList();
List<TestSheetBVo> sheetBList = sheetBResult.getList();

导出

ExcelWriter writer = ExcelUtil.createExport(response, "多sheet表测试");
List<TestSheetAVo> sheetAList = ...;//此处省略数组如何来的
ExcelUtil.writeSheet(writer, "班级信息", sheetAList, TestSheetAVo.class);
List<TestSheetBVo> sheetBList = ...;//此处省略数组如何来的
ExcelUtil.writeSheet(writer, "学生信息", sheetBList, TestSheetBVo.class);
ExcelUtil.finishWrite(writer);