Merge branch 'master' of http://10.153.19.25:10101/r/CanadaMes

ZengTao

2024-03-19 c8c96e57476968a164ad1889c9d7167fe320982e

 springboot-vue3/src/main/java/com/example/springboot/component/ExcelToJsonConverter.java

@@ -18,15 +18,15 @@
public class ExcelToJsonConverter {



    public static void main(String[] args) {

        String excelFilePath = "JsonFile/state.xlsx";

        String excelFilePath = "src/main/resources/JsonFile/alarm.xlsx";

        String sheetName = "Sheet1";

        int addressColumnIndex = 0;

        int nameColumnIndex = 1;



        int unitColumnIndex = 2;

        String outputFilePath = "JsonFile/state.json";

        //int unitColumnIndex = 2;

        String outputFilePath = "src/main/resources/JsonFile/PlcAlarm.json";



        try (Workbook workbook = new HSSFWorkbook(new FileInputStream(excelFilePath))) {

        try (Workbook workbook = new XSSFWorkbook(new FileInputStream(excelFilePath))) {

            Sheet sheet = workbook.getSheet(sheetName);



            List<LinkedHashMap<String, Object>> jsonList = new ArrayList<>();

@@ -38,19 +38,19 @@
            }



            int plcAddressLength = 0; // 记录所有 addressLenght 的和



            int addressIndex = 0; // 自增的地址索引

            while (rowIterator.hasNext()) {

                Row row = rowIterator.next();



                Cell nameCell = row.getCell(nameColumnIndex);

                Cell addressCell = row.getCell(addressColumnIndex);

                Cell unitCell = row.getCell(unitColumnIndex);

              //  Cell unitCell = row.getCell(unitColumnIndex);



                String name = nameCell.getStringCellValue();

                String address = addressCell.getStringCellValue();

                String unit = unitCell.getStringCellValue();

               // String unit = unitCell.getStringCellValue();



                String addressIndex = extractAddressIndex(address);

              //  String addressIndex = extractAddressIndex(address);



                LinkedHashMap<String, Object> jsonObject = new LinkedHashMap<>();

                jsonObject.put("codeId", name);

@@ -62,19 +62,21 @@
                } else {

                    addressLength = 2;

                }

                jsonObject.put("addressLenght", String.valueOf(addressLength));

               // jsonObject.put("addressLenght", String.valueOf(addressLength));



                jsonObject.put("unit", unit);

                //jsonObject.put("unit", unit);



                plcAddressLength += addressLength;



                jsonList.add(jsonObject);

                addressIndex++;

            }



            LinkedHashMap<String, Object> resultObject = new LinkedHashMap<>();

            resultObject.put("plcAddressBegin", "DB100.0");

            resultObject.put("plcAddressLenght", String.valueOf(plcAddressLength));

            resultObject.put("dataType", "word");

           // resultObject.put("dataType", "word");

            resultObject.put("dataType", "bit");

            resultObject.put("parameteInfor", jsonList);



            Gson gson = new Gson();

@@ -88,6 +90,8 @@
        }

    }







    private static String extractAddressIndex(String address) {

        // Assuming the address format is "DB103.DBW0" or "DB103.DBB100~DBB113"

        if (address.startsWith("DB") && address.contains(".DBW")) {