| | |
| | | |
| | | import cn.hutool.core.collection.CollUtil; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import io.swagger.annotations.Api; |
| | | import io.swagger.annotations.ApiOperation; |
| | | import lombok.AllArgsConstructor; |
| | | import lombok.Data; |
| | | import org.springframework.web.bind.annotation.GetMapping; |
| | | import org.springframework.web.bind.annotation.RequestMapping; |
| | | import org.springframework.web.bind.annotation.RestController; |
| | | |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import jakarta.servlet.http.HttpServletResponse; |
| | | import java.util.ArrayList; |
| | | import java.util.HashMap; |
| | | import java.util.List; |
| | |
| | | * |
| | | * @author Lion Li |
| | | */ |
| | | @Api(value = "测试Excel功能", tags = {"测试Excel功能"}) |
| | | @RestController |
| | | @RequestMapping("/demo/excel") |
| | | public class TestExcelController { |
| | |
| | | /** |
| | | * 单列表多数据 |
| | | */ |
| | | @ApiOperation(value = "单列表多数据") |
| | | @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"); |
| | | 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); |
| | | ExcelUtil.exportTemplate(CollUtil.newArrayList(map, list), "单列表.xlsx", "excel/单列表.xlsx", response); |
| | | } |
| | | |
| | | /** |
| | | * 多列表多数据 |
| | | */ |
| | | @ApiOperation(value = "多列表多数据") |
| | | @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"); |
| | | 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")); |
| | |
| | | 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); |
| | | 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); |
| | | } |
| | | |