This is an automated email from the ASF dual-hosted git repository.

wodiwudi pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/ozhera.git


The following commit(s) were added to refs/heads/master by this push:
     new 0628ca42 fix: fix excel dependency problem (#669)
0628ca42 is described below

commit 0628ca4278eaed3405295de8a6a98499ba4b42a5
Author: Xue <[email protected]>
AuthorDate: Fri Jun 5 14:13:27 2026 +0800

    fix: fix excel dependency problem (#669)
---
 ozhera-log/log-manager/pom.xml                               |  6 ++++++
 .../java/org/apache/ozhera/log/manager/domain/SearchLog.java |  1 -
 .../ozhera/log/manager/service/impl/EsDataServiceImpl.java   | 12 ++++++------
 3 files changed, 12 insertions(+), 7 deletions(-)

diff --git a/ozhera-log/log-manager/pom.xml b/ozhera-log/log-manager/pom.xml
index 1abac513..d195c2be 100644
--- a/ozhera-log/log-manager/pom.xml
+++ b/ozhera-log/log-manager/pom.xml
@@ -53,6 +53,12 @@ http://www.apache.org/licenses/LICENSE-2.0
             <version>1.6.2-jdk21</version>
         </dependency>
 
+        <dependency>
+            <groupId>org.apache.poi</groupId>
+            <artifactId>poi-ooxml</artifactId>
+            <version>5.4.0</version>
+        </dependency>
+
         <dependency>
             <groupId>mysql</groupId>
             <artifactId>mysql-connector-java</artifactId>
diff --git 
a/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/domain/SearchLog.java
 
b/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/domain/SearchLog.java
index d8eec71c..b3e43d0d 100644
--- 
a/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/domain/SearchLog.java
+++ 
b/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/domain/SearchLog.java
@@ -33,7 +33,6 @@ import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.collections.CollectionUtils;
 import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 import org.apache.poi.ss.usermodel.Workbook;
-import org.apache.poi.xssf.streaming.SXSSFWorkbook;
 import org.elasticsearch.index.query.BoolQueryBuilder;
 import org.elasticsearch.index.query.QueryBuilder;
 import org.elasticsearch.index.query.QueryBuilders;
diff --git 
a/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/service/impl/EsDataServiceImpl.java
 
b/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/service/impl/EsDataServiceImpl.java
index 6f1509fd..46095cfd 100644
--- 
a/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/service/impl/EsDataServiceImpl.java
+++ 
b/ozhera-log/log-manager/src/main/java/org/apache/ozhera/log/manager/service/impl/EsDataServiceImpl.java
@@ -789,10 +789,10 @@ public class EsDataServiceImpl implements EsDataService, 
LogDataService, EsDataB
                     Cell cell = titleRow.createCell(0);
                     cell.setCellValue(title);
                     CellStyle titleStyle = workbook.createCellStyle();
-                    titleStyle.setAlignment((short) 2);
-                    titleStyle.setVerticalAlignment((short) 1);
+                    titleStyle.setAlignment(HorizontalAlignment.CENTER);
+                    titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);
                     Font titleFont = workbook.createFont();
-                    titleFont.setBoldweight((short) 700);
+                    titleFont.setBold(true);
                     titleStyle.setFont(titleFont);
                     cell.setCellStyle(titleStyle);
                     titleRow.setHeight((short) 450);
@@ -802,9 +802,9 @@ public class EsDataServiceImpl implements EsDataService, 
LogDataService, EsDataB
 
                 if (list != null && !list.isEmpty()) {
                     CellStyle headerStyle = workbook.createCellStyle();
-                    headerStyle.setAlignment((short) 2);
-                    headerStyle.setBorderBottom((short) 2);
-                    headerStyle.setBorderTop((short) 2);
+                    headerStyle.setAlignment(HorizontalAlignment.CENTER);
+                    headerStyle.setBorderBottom(BorderStyle.MEDIUM);
+                    headerStyle.setBorderTop(BorderStyle.MEDIUM);
                     int headRowIndex = title != null && !title.isEmpty() && 
page == 1 ? 1 : 0;
                     Row headRow = sheet.createRow(headRowIndex);
                     int i = 0;


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to