java使用hutool工具导出excel格式文档

java使用hutool工具导出excel

1.导入相关依赖

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>5.0.7</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>3.17</version>
</dependency>

2.实体类

/**
 * @description 用户
 * @author ln
 */
@Data
public class User {
    
	private String id;
    private String name;
    private String nickname;
    private String sex;
    private String age;
  
}

3.service层

public void exportExcel() {
    
    List<User> userList=new ArrayList<>();  
    userList.add(new("1","用户1","yonghu1","女"，"22"));
    userList.add(new("2","用户2","yonghu2","男"，"24"));
	userList.add(new("3","用户3","yonghu3","女"，"24"));
    userList.add(new("4","用户4","yonghu4","男"，"23"));
    
    //通过工具类创建writer，默认创建xls格式
    //导出数据量大时使用BigExcelWriter导出
    //BigExcelWriter writer= ExcelUtil.getBigWriter("d:/excel/user.csv");
	ExcelWriter writer = ExcelUtil.getWriter("d:/excel/user.csv");
 	
    //只导出设置别名字段
    writer.setOnlyAlias(true);
    //自定义标题别名
    writer.addHeaderAlias("name", "姓名");
    writer.addHeaderAlias("sex", "性别");
    writer.addHeaderAlias("age", "年龄");

    writer.write(userList);  

    writer.close();
}