您可以按如下方式执行此操作：

假设条件：

• 本表仅包含汽车相关数据
• 工作表中没有空行
• 所有行的每一列都有数据值
  重要提示：

您必须为每个json value给予预期的json key作为Excel工作表中的列名（例如：-在Excel文件中将sellerName作为列名，而不是卖方名称）
所需的导入;

import com.google.gson.Gson;
import com.google.gson.JsonArray;
import com.google.gson.JsonElement;
import com.google.gson.JsonObject;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import java.util.*;

您应该获取Cell数据并将其放入一个HashMap中，然后将HashMap转换为JsonElement;

String excelFilePath = "E:\\Merged.xlsx";
FileInputStream fileInputStream = new FileInputStream(excelFilePath);
Workbook workbook = new XSSFWorkbook(fileInputStream);

Sheet sheet = workbook.getSheetAt(0);

JsonArray carArray = new JsonArray();
List<String> columnNames = new ArrayList<>();

Gson gson = new Gson();

// Get column names
Row row = sheet.getRow(0);
for (Iterator<Cell> it = row.cellIterator(); it.hasNext(); ) {
    Cell cell = it.next();
    columnNames.add(cell.getStringCellValue());
}

Iterator<Row> rowIterator = sheet.iterator();    
while (rowIterator.hasNext()) {
    row = rowIterator.next();
    if (row.getRowNum()==0) {
        continue;
    }
    Iterator<String> columnNameIterator = columnNames.iterator();
    Iterator<Cell> cellIterator = row.cellIterator();

    // Create a new map for the row
    Map<String, Object> newCarMap = new HashMap<>();
    while (cellIterator.hasNext()) {
        Cell cell = cellIterator.next();
        String columnName = columnNameIterator.next();

        switch (cell.getCellType()) {
            case Cell.CELL_TYPE_NUMERIC:
                newCarMap.put(columnName, cell.getNumericCellValue());
                break;
            case Cell.CELL_TYPE_STRING:
                newCarMap.put(columnName, cell.getStringCellValue());
                break;
        }
    }
    // Convert the map to `JsonElement`
    JsonElement carJson = gson.toJsonTree(newCarMap);
    // Add the `JsonElement` to `JsonArray`
    carArray.add(carJson);
}
// Add the `JsonArray` to `completeJson` object with the key as `Cars`
JsonObject completeJson = new JsonObject();

completeJson.add("Cars", carArray);

如果打印completeJson;

{
  "Cars": [
    {
      "price": 111111,
      "imageUrl": "https://example_url_1",
      "sellerAddress": "address_1",
      "sellerName": "name_1",
      "date": "12-07-2020"
    },
    {
      "price": 222222,
      "imageUrl": "https://example_url_2",
      "sellerAddress": "address_2",
      "sellerName": "name_2",
      "date": "19-06-2020"
    }
    // rest of the car json objects will come here
  ]
}

类似地，你可以创建Motorcycle json数组。当添加MotorCycle JsonArray以完成Json时，将键设置为Motorcycle（或你喜欢的键）