用于将Json转换为Excel new的Java程序

Question

我只是把Json文件转换成excel。我得到了这个错误。谁能帮忙吗。为什么会发生此错误

net.sf.json.JSONException: A JSONObject text must end with '}' at character 1 of {
    at net.sf.json.util.JSONTokener.syntaxError(JSONTokener.java:502)
    at net.sf.json.JSONObject.<init>(JSONObject.java:668)
    at net.sf.json.JSONObject.<init>(JSONObject.java:840)
    at net.sf.json.JSONObject.fromString(JSONObject.java:260)
    at net.sf.json.JSONSerializer.toJSON(JSONSerializer.java:91)
    at net.sf.json.JSONSerializer.toJSON(JSONSerializer.java:52)
    at javanewprog.ReadJson.main(ReadJson.java:40)

JSON:

{
  "glossary": {
    "title": "example glossary",
    "GlossDiv": {
      "title": "S",
      "GlossList": {
        "GlossEntry": {
          "ID": "SGML",
          "SortAs": "SGML",
          "GlossTerm": "Standard Generalized Markup Language",
          "Acronym": "SGML",
          "Abbrev": "ISO 8879:1986",
          "GlossDef": {
            "para": "A meta-markup language, used to create markup languages such as DocBook.",
            "GlossSeeAlso": [
              "GML",
              "XML"
            ]
          },
          "GlossSee":"markup"
        }
      }
    }
  }
}

Answer 1

您的JSon看起来不错（您可以here验证它）

另一方面，您可能会认为GlossSee和GlossSee也处于相同的级别，而实际上并非如此。GlossSee与GlossDef处于同一级别