以格式化的方式将JSON字符串从Java写入Excel

import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import com.fasterxml.jackson.databind.ObjectMapper;

public class JsonToExcel {
    public static void main(String[] args) {
        String json = "{\"name\": \"John\", \"age\": 30, \"city\": \"New York\"}";

        try {
            // 解析JSON字符串为Java对象
            ObjectMapper objectMapper = new ObjectMapper();
            Person person = objectMapper.readValue(json, Person.class);

            // 创建Excel工作簿和工作表
            Workbook workbook = new XSSFWorkbook();
            Sheet sheet = workbook.createSheet("Data");

            // 创建行和单元格，并写入数据
            Row row = sheet.createRow(0);
            Cell cell1 = row.createCell(0);
            cell1.setCellValue("Name");
            Cell cell2 = row.createCell(1);
            cell2.setCellValue(person.getName());

            row = sheet.createRow(1);
            Cell cell3 = row.createCell(0);
            cell3.setCellValue("Age");
            Cell cell4 = row.createCell(1);
            cell4.setCellValue(person.getAge());

            row = sheet.createRow(2);
            Cell cell5 = row.createCell(0);
            cell5.setCellValue("City");
            Cell cell6 = row.createCell(1);
            cell6.setCellValue(person.getCity());

            // 保存Excel文件
            FileOutputStream fileOut = new FileOutputStream("output.xlsx");
            workbook.write(fileOut);
            fileOut.close();
            workbook.close();

            System.out.println("Excel文件已成功创建并保存。");
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

class Person {
    private String name;
    private int age;
    private String city;

    // Getters and setters

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    public String getCity() {
        return city;
    }

    public void setCity(String city) {
        this.city = city;
    }
}