导出的sheet名称重复问题解决

1 files changed, 7 insertions, 1 deletions

diff --git a/src/main/java/com/nis/util/excel/ExportExcel.java b/src/main/java/com/nis/util/excel/ExportExcel.java
index 4c461be..c74b8e1 100644
--- a/src/main/java/com/nis/util/excel/ExportExcel.java
+++ b/src/main/java/com/nis/util/excel/ExportExcel.java
@@ -2209,10 +2209,16 @@ public class ExportExcel {
 		int j=0;
 		sheets=new HashMap<>();
 		rownums=new HashMap<>();
+		int num=0;
 		for (String title : titleList) {
 			List<String> headerList=headerMap.get(title);
 			List<String> commentList=commentMap.get(title);
-			Sheet sheet = wb.createSheet(StringUtil.isEmpty(msgProp.get(title)) ? title:msgProp.get(title).toString());
+			String titleName=StringUtil.isEmpty(msgProp.get(title)) ? title:msgProp.get(title).toString();
+			if(num > 0){
+				 titleName+=String.valueOf(num);
+			}
+			Sheet sheet = wb.createSheet(titleName);
+			num++;
 			rownums.put(title, 0);
 			sheets.put(title, sheet);
 			this.styles = createStyles(wb);