Java将Excel中的两列数据转换为JSON

package com.sense.bpm;

import com.fasterxml.jackson.databind.ObjectMapper;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

class ExcelData {
    private String key;
    private String value;

    public ExcelData(String key, String value) {
        this.key = key;
        this.value = value;
    }

    public String getKey() {
        return key;
    }

    public String getValue() {
        return value;
    }
}

public class ExcelToJsonConverter {
    public static void main(String[] args) {
        try {
            // 读取 Excel 文件
            FileInputStream fis = new FileInputStream("/Users/Desktop/quma2.xlsx");
            Workbook workbook = new XSSFWorkbook(fis);
            Sheet sheet = workbook.getSheetAt(0);

            // 存储从 Excel 读取的数据
            List<ExcelData> dataList = new ArrayList<>();

            // 遍历 Excel 中的行
            for (Row row : sheet) {
                Cell keyCell = row.getCell(0);
                Cell valueCell = row.getCell(1);

                if (keyCell != null && valueCell != null) {
                    String key = String.valueOf((int) keyCell.getNumericCellValue());
                    String value = String.valueOf((int) valueCell.getNumericCellValue());
                    dataList.add(new ExcelData(key, value));
                }
            }

            // 关闭 Excel 文件输入流
            fis.close();
            workbook.close();

            // 将数据列表转换为 JSON
            ObjectMapper objectMapper = new ObjectMapper();
            String json = objectMapper.writeValueAsString(dataList);

            System.out.println(json);

        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}