package org.dromara.demo.controller;
|
|
import cn.hutool.core.collection.CollUtil;
|
import jakarta.servlet.http.HttpServletResponse;
|
import lombok.AllArgsConstructor;
|
import lombok.Data;
|
import lombok.RequiredArgsConstructor;
|
import org.dromara.common.excel.core.ExcelResult;
|
import org.dromara.common.excel.utils.ExcelUtil;
|
import org.dromara.demo.domain.vo.ExportDemoVo;
|
import org.dromara.demo.listener.ExportDemoListener;
|
import org.dromara.demo.service.IExportExcelService;
|
import org.springframework.http.MediaType;
|
import org.springframework.web.bind.annotation.*;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* 测试Excel功能
|
*
|
* @author Lion Li
|
*/
|
@RequiredArgsConstructor
|
@RestController
|
@RequestMapping("/demo/excel")
|
public class TestExcelController {
|
|
private final IExportExcelService exportExcelService;
|
|
/**
|
* 单列表多数据
|
*/
|
@GetMapping("/exportTemplateOne")
|
public void exportTemplateOne(HttpServletResponse response) {
|
Map<String, String> map = new HashMap<>();
|
map.put("title", "单列表多数据");
|
map.put("test1", "数据测试1");
|
map.put("test2", "数据测试2");
|
map.put("test3", "数据测试3");
|
map.put("test4", "数据测试4");
|
map.put("testTest", "666");
|
List<TestObj> list = new ArrayList<>();
|
list.add(new TestObj("单列表测试1", "列表测试1", "列表测试2", "列表测试3", "列表测试4"));
|
list.add(new TestObj("单列表测试2", "列表测试5", "列表测试6", "列表测试7", "列表测试8"));
|
list.add(new TestObj("单列表测试3", "列表测试9", "列表测试10", "列表测试11", "列表测试12"));
|
ExcelUtil.exportTemplate(CollUtil.newArrayList(map, list), "单列表.xlsx", "excel/单列表.xlsx", response);
|
}
|
|
/**
|
* 多列表多数据
|
*/
|
@GetMapping("/exportTemplateMuliti")
|
public void exportTemplateMuliti(HttpServletResponse response) {
|
Map<String, String> map = new HashMap<>();
|
map.put("title1", "标题1");
|
map.put("title2", "标题2");
|
map.put("title3", "标题3");
|
map.put("title4", "标题4");
|
map.put("author", "Lion Li");
|
List<TestObj1> list1 = new ArrayList<>();
|
list1.add(new TestObj1("list1测试1", "list1测试2", "list1测试3"));
|
list1.add(new TestObj1("list1测试4", "list1测试5", "list1测试6"));
|
list1.add(new TestObj1("list1测试7", "list1测试8", "list1测试9"));
|
List<TestObj1> list2 = new ArrayList<>();
|
list2.add(new TestObj1("list2测试1", "list2测试2", "list2测试3"));
|
list2.add(new TestObj1("list2测试4", "list2测试5", "list2测试6"));
|
List<TestObj1> list3 = new ArrayList<>();
|
list3.add(new TestObj1("list3测试1", "list3测试2", "list3测试3"));
|
List<TestObj1> list4 = new ArrayList<>();
|
list4.add(new TestObj1("list4测试1", "list4测试2", "list4测试3"));
|
list4.add(new TestObj1("list4测试4", "list4测试5", "list4测试6"));
|
list4.add(new TestObj1("list4测试7", "list4测试8", "list4测试9"));
|
list4.add(new TestObj1("list4测试10", "list4测试11", "list4测试12"));
|
Map<String, Object> multiListMap = new HashMap<>();
|
multiListMap.put("map", map);
|
multiListMap.put("data1", list1);
|
multiListMap.put("data2", list2);
|
multiListMap.put("data3", list3);
|
multiListMap.put("data4", list4);
|
ExcelUtil.exportTemplateMultiList(multiListMap, "多列表.xlsx", "excel/多列表.xlsx", response);
|
}
|
|
/**
|
* 导出下拉框
|
*
|
* @param response /
|
*/
|
@GetMapping("/exportWithOptions")
|
public void exportWithOptions(HttpServletResponse response) {
|
exportExcelService.exportWithOptions(response);
|
}
|
|
/**
|
* 多个sheet导出
|
*/
|
@GetMapping("/exportTemplateMultiSheet")
|
public void exportTemplateMultiSheet(HttpServletResponse response) {
|
List<TestObj1> list1 = new ArrayList<>();
|
list1.add(new TestObj1("list1测试1", "list1测试2", "list1测试3"));
|
list1.add(new TestObj1("list1测试4", "list1测试5", "list1测试6"));
|
List<TestObj1> list2 = new ArrayList<>();
|
list2.add(new TestObj1("list2测试1", "list2测试2", "list2测试3"));
|
list2.add(new TestObj1("list2测试4", "list2测试5", "list2测试6"));
|
List<TestObj1> list3 = new ArrayList<>();
|
list3.add(new TestObj1("list3测试1", "list3测试2", "list3测试3"));
|
list3.add(new TestObj1("list3测试4", "list3测试5", "list3测试6"));
|
List<TestObj1> list4 = new ArrayList<>();
|
list4.add(new TestObj1("list4测试1", "list4测试2", "list4测试3"));
|
list4.add(new TestObj1("list4测试4", "list4测试5", "list4测试6"));
|
|
List<Map<String, Object>> list = new ArrayList<>();
|
Map<String, Object> sheetMap1 = new HashMap<>();
|
sheetMap1.put("data1", list1);
|
Map<String, Object> sheetMap2 = new HashMap<>();
|
sheetMap2.put("data2", list2);
|
Map<String, Object> sheetMap3 = new HashMap<>();
|
sheetMap3.put("data3", list3);
|
Map<String, Object> sheetMap4 = new HashMap<>();
|
sheetMap4.put("data4", list4);
|
|
list.add(sheetMap1);
|
list.add(sheetMap2);
|
list.add(sheetMap3);
|
list.add(sheetMap4);
|
ExcelUtil.exportTemplateMultiSheet(list, "多sheet列表", "excel/多sheet列表.xlsx", response);
|
}
|
|
/**
|
* 导入表格
|
*/
|
@PostMapping(value = "/importWithOptions", consumes = MediaType.MULTIPART_FORM_DATA_VALUE)
|
public List<ExportDemoVo> importWithOptions(@RequestPart("file") MultipartFile file) throws Exception {
|
// 处理解析结果
|
ExcelResult<ExportDemoVo> excelResult = ExcelUtil.importExcel(file.getInputStream(), ExportDemoVo.class, new ExportDemoListener());
|
return excelResult.getList();
|
}
|
|
@Data
|
@AllArgsConstructor
|
static class TestObj1 {
|
private String test1;
|
private String test2;
|
private String test3;
|
}
|
|
@Data
|
@AllArgsConstructor
|
static class TestObj {
|
private String name;
|
private String list1;
|
private String list2;
|
private String list3;
|
private String list4;
|
}
|
|
}
|
