Java 使用 hutool工具类导出excel（生成模板等）

关于什么是hutool，可查看：https://gitee.com/loolly/hutool

添加依赖

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-all</artifactId>
    <version>5.5.9</version>
</dependency>
<!-- 导出excel使用poi-->
<dependency>
	<groupId>org.apache.poi</groupId>
	<artifactId>poi-ooxml</artifactId>
	<version>4.1.2</version>
</dependency>

上代码

可用于excel模板生成功能

import cn.hutool.core.date.DateUtil;
import cn.hutool.poi.excel.BigExcelWriter;
import cn.hutool.poi.excel.ExcelUtil;
import com.google.common.collect.Lists;
 
import java.util.Date;
import java.util.List;
 
public class ExcelExport {
 
    public static void main(String[] args) {
        List<StudentBean> rows = Lists.newArrayList();
        rows.add(new StudentBean("张三", 21, 80, "合格", DateUtil.date()));
        rows.add(new StudentBean("李四", 21, 96, "优秀", DateUtil.date()));
        rows.add(new StudentBean("王五", 21, 78, "不及格", DateUtil.date()));
 
        // 通过工具类创建writer
        BigExcelWriter writer = ExcelUtil.getBigWriter("d:/grade_score.xlsx");
        //自定义标题别名
        writer.addHeaderAlias("name", "姓名");
        writer.addHeaderAlias("age", "年龄");
        writer.addHeaderAlias("score", "分数");
        writer.addHeaderAlias("isPass", "是否通过");
        writer.addHeaderAlias("examDate", "考试时间");
        // 合并单元格后的标题行，使用默认标题样式
        writer.merge(4, "一班成绩单");
        // 一次性写出内容，使用默认样式，强制输出标题
        writer.write(rows, true);
        // 关闭writer，释放内存
        writer.close();
    }
 
    //学生内部类
    static class StudentBean {
        private String name;
        private Integer age;
        private Integer score;
        private String isPass;
        private Date examDate;
		public String getName() {
			return name;
		}
		public void setName(String name) {
			this.name = name;
		}
		public Integer getAge() {
			return age;
		}
		public void setAge(Integer age) {
			this.age = age;
		}
		public Integer getScore() {
			return score;
		}
		public void setScore(Integer score) {
			this.score = score;
		}
		public String getIsPass() {
			return isPass;
		}
		public void setIsPass(String isPass) {
			this.isPass = isPass;
		}
		public Date getExamDate() {
			return examDate;
		}
		public void setExamDate(Date examDate) {
			this.examDate = examDate;
		}
        
    }
 
}

导出后