From a45d0bde7b526da6c09f055a20b289f02fd58a77 Mon Sep 17 00:00:00 2001
From: whyczh <hzjl@qq.com>
Date: 星期六, 02 四月 2022 10:45:28 +0800
Subject: [PATCH] 更新
---
src/main/java/testElectronJ/TestController.java | 35 ++++++++++++++++++-----------------
1 files changed, 18 insertions(+), 17 deletions(-)
diff --git a/src/main/java/testElectronJ/TestController.java b/src/main/java/testElectronJ/TestController.java
index 35be7f0..d62e8b9 100644
--- a/src/main/java/testElectronJ/TestController.java
+++ b/src/main/java/testElectronJ/TestController.java
@@ -2,6 +2,10 @@
import lombok.extern.slf4j.Slf4j;
import org.apache.poi.hssf.usermodel.*;
+import org.apache.poi.xssf.usermodel.XSSFDrawing;
+import org.apache.poi.xssf.usermodel.XSSFRow;
+import org.apache.poi.xssf.usermodel.XSSFSheet;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.springframework.web.bind.annotation.*;
import sun.misc.BASE64Decoder;
import testElectronJ.util.ServletUtils;
@@ -103,18 +107,18 @@
//褰撳墠鏃ユ湡
String nowFormat = new SimpleDateFormat("yyyyMMddHHmmss").format(new Date());
String excelName = "FBX-"+nowFormat;
- HSSFWorkbook wb = new HSSFWorkbook();
-
- HSSFSheet sheet = wb.createSheet("鏁版嵁鎬昏〃");
-
+ //HSSFWorkbook wb = new HSSFWorkbook();
+ //HSSFSheet sheet = wb.createSheet("鏁版嵁鎬昏〃");
+ XSSFWorkbook wb = new XSSFWorkbook();
+ XSSFSheet sheet = wb.createSheet("鏁版嵁鎬昏〃");
//鍥剧墖鍏冪礌
- HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
-
- //瀛椾綋鏍煎紡-鍔犵矖
- HSSFCellStyle cellStyle = wb.createCellStyle();
- HSSFFont font = wb.createFont();
- font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
- cellStyle.setFont(font);
+ //HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
+ XSSFDrawing patriarch = sheet.createDrawingPatriarch();
+ ////瀛椾綋鏍煎紡-鍔犵矖
+ //HSSFCellStyle cellStyle = wb.createCellStyle();
+ //HSSFFont font = wb.createFont();
+ //font.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
+ //cellStyle.setFont(font);
int rowNumSheet = 0;
FboDataHeadStart start = fboDataInf.fboDataStart;
@@ -160,15 +164,12 @@
}
}
- HSSFSheet sheet1 = wb.createSheet("鏁版嵁");
+ XSSFSheet sheet1 = wb.createSheet("鏁版嵁");
//鏂板缓琛�
//鎶ご
int rowNum = 0;
- HSSFRow rowTitle = sheet1.createRow(rowNum);
- HSSFCell cellTitle = rowTitle.createCell(0);
- cellTitle.setCellValue("娴嬭瘯鏁版嵁");
- cellTitle.setCellStyle(cellStyle);
+ sheet1.createRow(rowNum).createCell(0).setCellValue("娴嬭瘯鏁版嵁");
rowNum++;
@@ -176,7 +177,7 @@
//灞炴�ф爮
String[] rowName = getRowName(start.DataType);
- HSSFRow row = sheet1.createRow(rowNum);
+ XSSFRow row = sheet1.createRow(rowNum);
for (int i=0;i<rowName.length;i++){
row.createCell(i).setCellValue(rowName[i]);
}
--
Gitblit v1.9.1