what is easypoi?
easypoi
是一款简化版的poi
工具,让你不需要太多的poi
知识就能够使用poi完成Excel和word的各种操作。
easypoi
官方文档,点击官方文档
怎使用easypoi
?
1、创建一个springboot
项目,在pom.xml
中引入依赖
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-base</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-web</artifactId>
<version>4.1.0</version>
</dependency>
<dependency>
<groupId>cn.afterturn</groupId>
<artifactId>easypoi-annotation</artifactId>
<version>4.1.0</version>
</dependency>
2、编写easypoiutil
public class EasyPoiUtils {
/**
* 导出excel
* @param pojoClass
* @param dataSet
* @param path
* @param filename
* @throws IOException
*/
public static void exportExcel(Class<?> pojoClass, Collection<?> dataSet,String path,String filename) throws IOException {
File savefile = new File(path);
if (!savefile.exists()) {
savefile.mkdirs();
}
Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(), pojoClass, dataSet);
FileOutputStream fos = new FileOutputStream(path+filename);
workbook.write(fos);
fos.close();<