如果你仅需一个Java导出excel的工具，👇就可以满足你的临时需求，当然代码下面这么写肯定是不规范的，可以稍后完善！
添加依赖
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<dependency>
<groupId>cn.hutool</groupId>
<artifactId>hutool-all</artifactId>
<version>5.7.4</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.0.0</version>
</dependency>
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>5.0.0</version>
</dependency>
|
数据类
1
2
3
4
5
6
7
| @Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class IPData {
private String ip;
}
|
Export方法示例
1
2
3
4
5
6
7
8
9
10
| public void export(List<IPData> rows) throws FileNotFoundException {
ExcelWriter writer = ExcelUtil.getWriter(true);
writer.renameSheet("所有数据");
writer.addHeaderAlias("ip", "IP");
writer.write(rows, true);
writer.setOnlyAlias(true);
FileOutputStream fileOutputStream = new FileOutputStream("/Users/gaolei/Desktop/IP1.xlsx");
writer.flush(fileOutputStream);
writer.close();
}
|
