StorageService localStorageService = storageFactory.getLocalStorageService();
String path = "";
// 文件信息
String dateTime = DateUtils.formatTimestampToString(new Date());
String title = "xxx统计";
String fileName = StringUtils.dbc2sbcCase(title) + "_" + dateTime + EXCEL_SUFFIX;
File file = null;
ExcelWriter excelWriter = null;
WriteSheet writeSheet = null;
int num = 0;
try {
file = localStorageService.newTempFile(fileName);
excelWriter = EasyExcel.write(file.getPath()).build();
writeSheet = EasyExcel.writerSheet(title).sheetNo(0).registerWriteHandler(new CustomizeColumnWidth()).build();
// 写入数据
List<List<String>> headList = new ArrayList<>();
headList.add(Lists.newArrayList(title,"数据1"));
headList.add(Lists.newArrayList(title,"数据2"));
headList.add(Lists.newArrayList(title,"数据3"));
//数据
List<List<String>> objects = new ArrayList<>();
objects.add(Lists.newArrayList("123","321","222"));
WriteTable writeTable = EasyExcel.writerTable(num)
.head(headList)
.registerWriteHandler(ExcelUtils.getStyleStrategy()).build();
excelWriter.write(Lists.newArrayList(objects), writeSheet, writeTable);
num++;
} catch (Exception e) {
e.printStackTrace();
}
if (excelWriter != null) {
// 写入数据
List<List<String>> headList = new ArrayList<>();
String tableTitle = "第二个表题";
headList.add(Lists.newArrayList(tableTitle,"姓名"));
headList.add(Lists.newArrayList(tableTitle,"年龄"));
headList.add(Lists.newArrayList(tableTitle,"性别"));
//数据
List<List<String>> objects = new ArrayList<>();
objects.add(Lists.newArrayList("admin","18","男"));
objects.add(Lists.newArrayList("admin2","19","男"));
WriteTable writeTable = EasyExcel.writerTable(num)
.head(headList)
.registerWriteHandler(ExcelUtils.getStyleStrategy()).build();
excelWriter.write(Lists.newArrayList(objects), writeSheet, writeTable);
num++;
try {
excelWriter.finish();
path = FileUtils.uploadFile(file, fileName, orgId, userId);
} catch (IOException e) {
e.printStackTrace();
}
}
// 生成的文件的路径
return path;
重点:
List<List<String>> headList = new ArrayList<>();
headList.add(Lists.newArrayList(title,"数据1"));
headList.add(Lists.newArrayList(title,"数据2"));
headList.add(Lists.newArrayList(title,"数据3"));
原文地址:https://blog.csdn.net/weixin_43849543/article/details/134731541
本文来自互联网用户投稿,该文观点仅代表作者本人,不代表本站立场。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。
如若转载,请注明出处:http://www.7code.cn/show_19954.html
如若内容造成侵权/违法违规/事实不符,请联系代码007邮箱:suwngjj01@126.com进行投诉反馈,一经查实,立即删除!
声明:本站所有文章,如无特殊说明或标注,均为本站原创发布。任何个人或组织,在未征得本站同意时,禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益,可联系我们进行处理。