java生成树形Excel_java poi导出树形结构到excel文件

maven pom.xml下载poi包

org.apache.poi

poi

3.17

org.apache.poi

poi-ooxml

3.17

org.apache.poi

poi-ooxml-schemas

3.17

首先是实体类，也就是我们的数据集合

import java.util.List;

import com.baomidou.mybatisplus.annotation.TableField;

import com.baomidou.mybatisplus.annotation.TableId;

import com.baomidou.mybatisplus.annotation.TableName;

import lombok.Data;

import lombok.experimental.Accessors;

@Data

@Accessors(chain = true)

@TableName("test")

public class TestDomain {

private String phone;

private String parentPhone;

@TableId

private String id;

private String parentId;

@TableField(exist = false)

private List children;

/**列数*/

@TableField(exist = false)

private Integer colNumber;

}

再写个接口接收前端的导出请求，这里是使用的springboot 框架

@GetMapping("/test")

public void test(HttpServletResponse response, HttpServletRequest request) throws IOException {

// 查询数据库

List testDomains = testMapper.selectList(null);

// 封装成树形结构

TestTreeHandler testTreeHandler = new TestTreeHandler(testDomains);

List treeList = testTreeHandler.buildTree();

//创建poi导出数据对象

SXSSFWorkbook sxssfWorkbook = new SXSSFWorkbook();

<