From 30d8e227e8d823b6c38c3b9c90ac2df03b63befe Mon Sep 17 00:00:00 2001
From: admin <weikou2014>
Date: 星期二, 25 二月 2025 16:41:22 +0800
Subject: [PATCH] 淘宝转链接口更新
---
fanli/src/main/java/com/yeshi/fanli/util/ExcelUtil.java | 72 ++++++++++++++++++------------------
1 files changed, 36 insertions(+), 36 deletions(-)
diff --git a/fanli/src/main/java/com/yeshi/fanli/util/ExcelUtil.java b/fanli/src/main/java/com/yeshi/fanli/util/ExcelUtil.java
index ca781db..74d884f 100644
--- a/fanli/src/main/java/com/yeshi/fanli/util/ExcelUtil.java
+++ b/fanli/src/main/java/com/yeshi/fanli/util/ExcelUtil.java
@@ -1,39 +1,39 @@
-package com.yeshi.fanli.util;
-
-import java.io.File;
-import java.io.IOException;
-import java.util.ArrayList;
-import java.util.List;
-
-import jxl.Cell;
-import jxl.Sheet;
-import jxl.Workbook;
-import jxl.read.biff.BiffException;
-
-public class ExcelUtil {
-
- public static List<String> articelList(String path) {
- List<String> list = new ArrayList<String>();
- try {
- File file = new File(path); // 鍒涘缓鏂囦欢瀵硅薄
+package com.yeshi.fanli.util;
+
+import java.io.File;
+import java.io.IOException;
+import java.util.ArrayList;
+import java.util.List;
+
+import jxl.Cell;
+import jxl.Sheet;
+import jxl.Workbook;
+import jxl.read.biff.BiffException;
+
+public class ExcelUtil {
+
+ public static List<String> articelList(String path) {
+ List<String> list = new ArrayList<String>();
+ try {
+ File file = new File(path); // 鍒涘缓鏂囦欢瀵硅薄
Workbook wb = Workbook.getWorkbook(file); // 浠庢枃浠舵祦涓幏鍙朎xcel宸ヤ綔鍖哄璞★紙WorkBook
Sheet sheet = wb.getSheet(0); // 浠庡伐浣滃尯涓彇寰楅〉锛圫heet
-
+
for (int i = 0; i < sheet.getRows(); i++) { // 寰幆鎵撳嵃Excel琛ㄤ腑鐨勫唴
- Cell cell = sheet.getCell(1, i);
- if (!StringUtil.isNullOrEmpty(cell.getContents()))
- list.add((cell.getContents() + "").trim());
- }
- } catch (BiffException e) {
- e.printStackTrace();
- } catch (IOException e) {
- e.printStackTrace();
- }
- return list;
- }
-
- public static void updateExcel() {
-
- }
-
-}
+ Cell cell = sheet.getCell(1, i);
+ if (!StringUtil.isNullOrEmpty(cell.getContents()))
+ list.add((cell.getContents() + "").trim());
+ }
+ } catch (BiffException e) {
+ e.printStackTrace();
+ } catch (IOException e) {
+ e.printStackTrace();
+ }
+ return list;
+ }
+
+ public static void updateExcel() {
+
+ }
+
+}
--
Gitblit v1.8.0