maven依赖
<dependency>
<groupId>net.sourceforge.jexcelapi</groupId>
<artifactId>jxl</artifactId>
<version>2.6.10</version>
</dependency>
java代码
public static void writeExcel(List<Map<String,Object>> resultMapList) {
//开始写入excel,创建模型文件头 文章id 文章标题 创建时间
String[] titleA = {"文章id", "文章标题", "创建时间"};
//创建Excel文件,B库CD表文件
File fileA = new File("e:/TestFile1.xls");
if (fileA.exists()) {
//如果文件存在就删除
fileA.delete();
}
try {
fileA.createNewFile();
//创建工作簿
WritableWorkbook workbookA = Workbook.createWorkbook(fileA);
//WritableWorkbook workbookA = null;
//创建sheet
WritableSheet sheetA = workbookA.createSheet("sheet1", 0);
Label labelA = null;
//设置列名
for (int i = 0; i < titleA.length; i++) {
labelA = new Label(i, 0, titleA[i]);
sheetA.addCell(labelA);
}
//获取数据源 resultMapList
int k = 1;
for(Map<String,Object> map:resultMapList){
// resultMapList
labelA = new Label(0, k, (String) map.get("id"));
sheetA.addCell(labelA);
labelA = new Label(1, k, (String) map.get("title"));
sheetA.addCell(labelA);
labelA = new Label(2, k, (String) map.get("atime"));
sheetA.addCell(labelA);
k++;
}
/*for (int i = 1; i < 10; i++) {
// resultMapList
*//*labelA = new Label(0, i, i + " ");
sheetA.addCell(labelA);
labelA = new Label(1, i, "20180101" + i);
sheetA.addCell(labelA);
labelA = new Label(2, i, "开发00" + i);
sheetA.addCell(labelA);*//*
}*/
workbookA.write(); //写入数据
workbookA.close(); //关闭连接
System.out.println("成功写入文件,请前往E盘查看文件!");
} catch (Exception e) {
System.out.println("文件写入失败,报异常...");
}
}