1.參考資料

EasyPoi教程：http://easypoi.mydoc.io/#text_197817
碼云地址：https://gitee.com/jeecg/easypoi

如果遇到導(dǎo)入導(dǎo)出Excel或者word，可以使用easypoi，文檔中案例很齊全
一般來說我們常常會遇到報表數(shù)據(jù)的導(dǎo)出(Excel)，下面給出一個小栗子

2.添加maven依賴

<dependency>
  <groupId>org.jeecg</groupId>
  <artifactId>easypoi-base</artifactId>
  <version>${easypoi.version}</version>
</dependency>
<dependency>
  <groupId>org.jeecg</groupId>
  <artifactId>easypoi-web</artifactId>
  <version>${easypoi.version}</version>
</dependency>
<dependency>
  <groupId>org.jeecg</groupId>
  <artifactId>easypoi-annotation</artifactId>
  <version>${easypoi.version}</version>
</dependency>

3.Java導(dǎo)出Excel

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;
import org.jeecgframework.poi.excel.annotation.Excel;
import org.jeecgframework.poi.excel.annotation.ExcelTarget; 
import java.io.Serializable;

@Data
@ExcelTarget("courseDomain")
@NoArgsConstructor
@AllArgsConstructor
@ToString
public class CourseDomain implements Serializable {

    @Excel(name = "課程名稱", width = 25)
    private String name;

    @Excel(name = "教師名稱", width = 25)
    private String teacherName;

    @Excel(name = "學(xué)生數(shù)量", width = 10)
    private int studentNumber;

    @Excel(name = "描述", width = 40)
    private String desc;
}   

public static void main(String[] args) throws Exception {
    List<CourseDomain> domainList = new ArrayList<CourseDomain>();
    domainList.add(new CourseDomain("語文", "tom", 33, "很有趣"));
    domainList.add(new CourseDomain("數(shù)學(xué)", "jack", 13, "可能有點(diǎn)難"));
    domainList.add(new CourseDomain("C++", "jackson", 133, "我們很有興趣"));

    ExportParams params = new ExportParams("課程詳情", null, "課程詳情");
    Workbook workbook = ExcelExportUtil.exportExcel(params, CourseDomain.class, domainList);
    File targetFile = new File("temp.xls");
    FileOutputStream fos = new FileOutputStream(targetFile);
    workbook.write(fos);
    fos.close();
}

5.SpringMVC無縫融合 Excel導(dǎo)出可以參考文檔 有具體實(shí)例

源碼地址：https://gitee.com/jsjack_wang/JavaDemo