# ComplexExcelPoi

**Repository Path**: MagicToDo/complex-excel-poi

## Basic Information

- **Project Name**: ComplexExcelPoi
- **Description**: 基于apache.poi的多层复杂表头组装
- **Primary Language**: Java
- **License**: MulanPSL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-03-28
- **Last Updated**: 2025-03-28

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# ComplexExcelPoi

#### 介绍
基于apache.poi的多层复杂表头组装

这个方法源于CSDN大佬     https://blog.csdn.net/qq_28430851/article/details/80496125

我个人只是优化了一下、以支持xssf和sxssf导出大量数据

想测试的话拉取后直接运行即可，个人测试良好，其他想研究的看代码注释

![image-20250328164321990](https://netr4fhflp4p.xiaomiqiu.com:443/markdown/202503281643207.png)



#### 使用说明

依赖

```yaml
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>
```

基础类

 [Column.java](src\main\java\com\lytodo\excelpoi\excel\Column.java) 

 [ExcelTool.java](src\main\java\com\lytodo\excelpoi\excel\ExcelTool.java) 

 [TreeTool.java](src\main\java\com\lytodo\excelpoi\excel\TreeTool.java)