1.參考資料
EasyPoi教程：http://easypoi.mydoc.io/#text_197817
碼云地址：https://gitee.com/jeecg/easypoi
如果遇到導(dǎo)入導(dǎo)出Excel或者word喂很，可以使用easypoi，文檔中案例很齊全
一般來(lái)說(shuō)我們常常會(huì)遇到報(bào)表數(shù)據(jù)的導(dǎo)出(Excel)皆刺，下面給出一個(gè)小栗子
2.添加maven依賴(lài)
<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 = "課程名稱(chēng)", width = 25)
private String name;
@Excel(name = "教師名稱(chēng)", 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("語(yǔ)文", "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無(wú)縫融合 Excel導(dǎo)出可以參考文檔 有具體實(shí)例
源碼地址：https://gitee.com/jsjack_wang/JavaDemo
