From 20f9e20e45a66a5dad1217c93455685d8174c6cf Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期四, 25 一月 2024 08:09:27 +0800
Subject: [PATCH] Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes
---
springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java | 30 ++++++++++++++++++++++++------
1 files changed, 24 insertions(+), 6 deletions(-)
diff --git a/springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java b/springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java
index d1098ba..20ed8a4 100644
--- a/springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java
+++ b/springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java
@@ -12,9 +12,11 @@
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
+import java.util.LinkedHashMap;
import java.util.List;
public class ExcelToJsonConverter {
+
public static void main(String[] args) {
String excelFilePath = "JsonFile/state.xlsx";
String sheetName = "Sheet1";
@@ -27,13 +29,15 @@
try (Workbook workbook = new HSSFWorkbook(new FileInputStream(excelFilePath))) {
Sheet sheet = workbook.getSheet(sheetName);
- List<JSONObject> jsonList = new ArrayList<>();
+ List<LinkedHashMap<String, Object>> jsonList = new ArrayList<>();
Iterator<Row> rowIterator = sheet.iterator();
// Skip the header row
if (rowIterator.hasNext()) {
rowIterator.next();
}
+
+ int plcAddressLength = 0; // 璁板綍鎵�鏈� addressLenght 鐨勫拰
while (rowIterator.hasNext()) {
Row row = rowIterator.next();
@@ -48,17 +52,33 @@
String addressIndex = extractAddressIndex(address);
- JSONObject jsonObject = new JSONObject();
+ LinkedHashMap<String, Object> jsonObject = new LinkedHashMap<>();
jsonObject.put("codeId", name);
jsonObject.put("addressIndex", addressIndex);
+ int addressLength = 0;
+ if (address.contains("~")) {
+ addressLength = 14;
+ } else {
+ addressLength = 2;
+ }
+ jsonObject.put("addressLenght", String.valueOf(addressLength));
+
jsonObject.put("unit", unit);
+
+ plcAddressLength += addressLength;
jsonList.add(jsonObject);
}
+ LinkedHashMap<String, Object> resultObject = new LinkedHashMap<>();
+ resultObject.put("plcAddressBegin", "DB100.0");
+ resultObject.put("plcAddressLenght", String.valueOf(plcAddressLength));
+ resultObject.put("dataType", "word");
+ resultObject.put("parameteInfor", jsonList);
+
Gson gson = new Gson();
- String jsonOutput = gson.toJson(jsonList);
+ String jsonOutput = gson.toJson(resultObject);
try (FileWriter fileWriter = new FileWriter(outputFilePath)) {
fileWriter.write(jsonOutput);
@@ -81,6 +101,4 @@
}
return "";
}
-
-
-}
\ No newline at end of file
+}
--
Gitblit v1.8.0