根据客户需求修改复位倒计时，修改手动页面英文显示

ZengTao

2024-05-06 dae61fa269844f76ccc9edf9eb316ef5c3dd0798

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

@@ -12,22 +12,24 @@
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 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<JSONObject> jsonList = new ArrayList<>();

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



            Iterator<Row> rowIterator = sheet.iterator();

            // Skip the header row

@@ -35,30 +37,50 @@
                rowIterator.next();

            }



            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);



                JSONObject jsonObject = new JSONObject();

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

                jsonObject.put("codeId", name);

                jsonObject.put("addressIndex", addressIndex);



                jsonObject.put("unit", unit);

                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);

                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", "bit");

            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);

@@ -67,6 +89,8 @@
            e.printStackTrace();

        }

    }







    private static String extractAddressIndex(String address) {

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

@@ -81,6 +105,4 @@
        }

        return "";

    }





}
}