From 47a751cb301d05276ae5d75145d57b2d090fe4e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: Mon, 01 Jul 2024 10:58:35 +0800
Subject: [PATCH] change
---
src/main/java/com/nanometer/smartlab/util/ExcelUtils.java | 19 ++++++++++++-------
1 files changed, 12 insertions(+), 7 deletions(-)
diff --git a/src/main/java/com/nanometer/smartlab/util/ExcelUtils.java b/src/main/java/com/nanometer/smartlab/util/ExcelUtils.java
index c2cff47..f739039 100644
--- a/src/main/java/com/nanometer/smartlab/util/ExcelUtils.java
+++ b/src/main/java/com/nanometer/smartlab/util/ExcelUtils.java
@@ -3,6 +3,7 @@
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.streaming.SXSSFRow;
import org.apache.poi.xssf.streaming.SXSSFSheet;
import org.apache.poi.xssf.streaming.SXSSFWorkbook;
@@ -23,12 +24,15 @@
System.setProperty("java.awt.headless", "false");
}
- public static SXSSFWorkbook exportExcelNew(Map<String, String> map, List<Map> dataList, String name){
- SXSSFWorkbook sb = new SXSSFWorkbook(1000);
+ public static HSSFWorkbook exportExcelNew(Map<String, String> map, List<Map> dataList, String name){
+ // SXSSFWorkbook sb = new SXSSFWorkbook(1000);
Integer total = null;
//sheet名字
- SXSSFSheet sheet = sb.createSheet(name);
- SXSSFRow titlerRow = sheet.createRow(0);
+// SXSSFSheet sheet = sb.createSheet(name);
+// SXSSFRow titlerRow = sheet.createRow(0);
+ HSSFWorkbook sb = new HSSFWorkbook();
+ HSSFSheet sheet = sb.createSheet(name);
+ HSSFRow titlerRow = sheet.createRow(0);
int k = 0;
for(Map.Entry<String, String> entry:map.entrySet()){
@@ -38,7 +42,8 @@
}
//数据
for (int i = 0; i < dataList.size(); i++) {
- SXSSFRow dataRow = sheet.createRow(i + 1);
+ // SXSSFRow dataRow = sheet.createRow(i + 1);
+ HSSFRow dataRow = sheet.createRow(i + 1);
int j = 0;
for(Map.Entry<String, String> entry:map.entrySet()){
//表头
@@ -77,10 +82,10 @@
new String(contentDisposition.toString().getBytes(
System.getProperty("file.encoding")), "ISO8859-1"));
out = response.getOutputStream();
- SXSSFWorkbook sb = ExcelUtils.exportExcelNew(map, list, name);
+ Workbook sb = ExcelUtils.exportExcelNew(map, list, name);
sb.write(out);
out.flush();
- sb.dispose();// 释放workbook所占用的所有windows资源
+ // sb.dispose();// 释放workbook所占用的所有windows资源
ctx.responseComplete();
} catch (Exception e) {
if (is != null) {
--
Gitblit v1.9.2