easypoi 模板导出

easypoi工具导出表格实用性较高，根据模板轻松导出需求表格，表格样式可在模板中设定。自己写个了简单的模板导出例子。项目导入eclipse，maven引入工具包，即可使用。

package com.easypoi;

import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.apache.poi.ss.usermodel.Workbook;

import cn.afterturn.easypoi.excel.ExcelExportUtil;
import cn.afterturn.easypoi.excel.entity.TemplateExportParams;

public class easypoi {
	 
		public static void main（String[] args） throws Exception{
		       TemplateExportParams params = new TemplateExportParams（
		                “doc/统计表.xlsx“0）;
		        Mapject> map = new HashMapject>（）;
		        Listject>> mapList = new ArrayListject>>（）;
		        for （int i = 0; i < 4; i++） {
		            Mapject> testMap = new HashMapject>（）;
		            testMap.put（“index“ i）;
		            testMap.put（“name“ “小明“+i）;
		            testMap.put（“age“ “年龄“+i）;
		            testMap.put（“dept“ “部门“+i）;
		            mapList.add（testMap）;
		        }
		        map.put（“maplist“ mapList）;
		        Workbook workbook = ExcelExportUtil.exportExcel（params map）;
		        File savefile = new File（“D:/excel/“）;
		        if （!savefile.exists（）） {
		            savefile.mkdirs（）;
		        }
		        FileOutputStream fos = new FileOutputStream（“D:/excel/统计表.xlsx“）;
		        workbook.write（fos）;
		        fos.close（）;
		}
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       1431  2019-02-28 15:27  easypoiDemo\com.easypoi\.classpath

     文件        977  2019-02-28 15:27  easypoiDemo\com.easypoi\.project

     文件         87  2019-02-28 15:28  easypoiDemo\com.easypoi\.settings\org.eclipse.core.resources.prefs

     文件        430  2019-02-28 15:27  easypoiDemo\com.easypoi\.settings\org.eclipse.jdt.core.prefs

     文件         90  2019-02-28 15:27  easypoiDemo\com.easypoi\.settings\org.eclipse.m2e.core.prefs

     文件        172  2019-02-28 15:27  easypoiDemo\com.easypoi\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml

     文件        170  2019-02-28 15:27  easypoiDemo\com.easypoi\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件       9475  2019-02-28 15:27  easypoiDemo\com.easypoi\doc\统计表.xlsx

     文件        950  2019-02-28 15:27  easypoiDemo\com.easypoi\pom.xml

     文件       1546  2019-02-28 15:27  easypoiDemo\com.easypoi\src\main\java\com\easypoi\easypoi.java

     文件       2382  2019-02-28 15:28  easypoiDemo\com.easypoi\target\classes\com\easypoi\easypoi.class

     文件        115  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\MANIFEST.MF

     文件        256  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\maven\com.easypoi\com.easypoi\pom.properties

     文件        950  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\maven\com.easypoi\com.easypoi\pom.xml

     文件       3892  2019-02-28 15:28  easypoiDemo\com.easypoi\target\com.easypoi-0.0.1-SNAPSHOT.jar

     文件        121  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-archiver\pom.properties

     文件          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\compile\default-compile\createdFiles.lst

     文件         94  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\compile\default-compile\inputFiles.lst

     文件          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\testCompile\default-testCompile\inputFiles.lst

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\maven\com.easypoi\com.easypoi

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\src\main\java\com\easypoi

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\maven\com.easypoi

     目录          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\compile\default-compile

     目录          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\testCompile\default-testCompile

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\src\main\java\com

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\com\easypoi

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\target\classes\meta-INF\maven

     目录          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\compile

     目录          0  2019-02-28 15:28  easypoiDemo\com.easypoi\target\maven-status\maven-compiler-plugin\testCompile

     目录          0  2019-02-28 15:27  easypoiDemo\com.easypoi\src\main\java

............此处省略21个文件信息