From 1bfc0294cecee7e7d557fd1ffe89b671752c58d1 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期一, 26 九月 2022 09:07:30 +0800
Subject: [PATCH] 校准定位最后一行
---
src/main/java/com/whyc/service/SoftwareService.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java
index bc83a48..8da3d19 100644
--- a/src/main/java/com/whyc/service/SoftwareService.java
+++ b/src/main/java/com/whyc/service/SoftwareService.java
@@ -52,6 +52,13 @@
//鍙栫涓�涓猻heet琛�
Sheet sheet = workbook.getSheetAt(0);
int lastRowNum = sheet.getLastRowNum();
+ //鏍″噯lastRowNum
+ for (int i = 8; i <= lastRowNum; i++) {
+ if(sheet.getRow(i).getCell(1).getStringCellValue().equals("鍙戝竷璇存槑")){
+ lastRowNum = i;
+ break;
+ }
+ }
//鍥哄畾5鍒�
short cellNum = 5;
//鍙栧浐瀹氶儴鍒嗗��
--
Gitblit v1.9.1