废话不多说上代码
public static void main(String[] args) throws Exception {
List<List<Object>> dataList = new ArrayList<List<Object>>();
List<Object> data1 = new ArrayList<Object>();
data1.add("小明");data1.add("男");data1.add(25);
dataList.add(data1);
List<Object> data2 = new ArrayList<Object>();
data2.add("小白");data2.add("男");data2.add(26);
dataList.add(data2);
List<Object> data3 = new ArrayList<Object>();
data3.add("小红");data3.add("男");data3.add(27);
dataList.add(data3);
//载入模板
String templateName = "templates/export.xls";
InputStream is = SimpleGridJxls.class.getClass().getResourceAsStream(templateName);
Context context = new Context();
context.putVar("headers", Arrays.asList("姓名" , "性别" , "年龄"));
context.putVar("dataList", dataList);
OutputStream os = new FileOutputStream(new File("d:\\test\\out_simpleGrid.xls"));
//指定Sheet文件解析
JxlsHelper.getInstance().processTemplate(is, os, context);
os.flush();
os.close();
is.close();
}
}