Google Sheets JSON 数据

huangapple
go评论105阅读模式
英文:

Google sheets JSON data

问题

I understand your request. Here is the translated code portion:

  1. 我是C#的新手。我有以下JSON数据。此外，我是通过从Google表格转换而来的。我正在尝试为我的Unity游戏制作排行榜。但是我无法将这些“values”分配给变量。我想获取“Name”，“Score”，“Event”，并将它们分配给一个变量。
  3. public struct Data{
  4.     public string range;
  5.     public string majorDimension;
  6.     public List<List<string>> values;
  7. }
  9. IEnumerator getData()
  10. {
  11.     UnityWebRequest www = UnityWebRequest.Get(googleSheetURL);
  12.     yield return www.SendWebRequest();
  13.     if (www.isNetworkError || www.isHttpError)
  14.     {
  15.         Debug.Log(www.error);
  16.     }
  17.     else
  18.     {
  19.         Data data = JsonUtility.FromJson<Data>(www.downloadHandler.text);
  21.         Debug.Log(data.values);
  22.         Debug.Log(data.majorDimension);
  23.         Debug.Log(data.range);
  24.     }
  26.     www.Dispose();
  27. }

希望这对您有所帮助。祝您有美好的一天！

英文:

I am new in c#. I have JSON data like below. Furthermore, I got it by converting from Google sheets. I am trying to make a leaderboard for my unity game. But I can't assign these "values" to the variable. I want to get "Name", "Score", "Event" and I want to assign them to a variable.

  1. {
  2.   &quot;range&quot;: &quot;Sheet1!A1:M112&quot;,
  3.   &quot;majorDimension&quot;: &quot;ROWS&quot;,
  4.   &quot;values&quot;: [
  5.     [
  6.       &quot;Time&quot;,
  7.       &quot;Name&quot;,
  8.       &quot;Surname&quot;,
  9.       &quot;E-Mail&quot;,
  10.       &quot;Company / University&quot;,
  11.       &quot;Event(Optional)&quot;,
  12.       &quot;Score&quot;
  13.     ],
  14.     [
  15.       &quot;12.06.2023 11:17:09&quot;,
  16.       &quot;Henry&quot;,
  17.       &quot;Powell&quot;,
  18.       &quot;@hotmail.com&quot;,
  19.       &quot;x Company&quot;,
  20.       &quot;x Event&quot;,
  21.       &quot;0&quot;
  22.     ]
  23.   ]
  24. }

I have structure like this. Furthermore, I can print majorDimension and range. I don't understand list inside list concept in c# so i can't reach "values" section. You can see what i tried in getData section.

  1. public struct Data{
  2.     public string range;
  3.     public string majorDimension;
  4.     public List&lt;List&lt;string&gt;&gt; values;
  5. }
  1. IEnumerator getData()
  2.     {
  3.         UnityWebRequest www = UnityWebRequest.Get(googleSheetURL);
  4.         yield return www.SendWebRequest();
  5.         if (www.isNetworkError || www.isHttpError)
  6.         {
  7.             Debug.Log(www.error);
  8.         }
  9.         else
  10.         {
  11.             Data data = JsonUtility.FromJson&lt;Data&gt;(www.downloadHandler.text);
  13.             Debug.Log(data.values);
  14.             Debug.Log(data.majorDimension);
  15.             Debug.Log(data.range);
  16.         }
  18.         www.Dispose();
  19.     }

I will be glad if you help. Have a nice day!

答案1

得分: 1

你可以使用这段示例代码：

  1. List<List<string>> values = data.values;
  3. int NameIndex = values[0].IndexOf("Name");
  4. int EventIndex = values[0].Select((ev, index) => (ev, index))
  5.                         .First(ev => ev.ev.Contains("Event")).index;
  6. int ScoreIndex = values[0].IndexOf("Score");
  8. var scores = values.Select((ev, index) => (ev, index)).Where(v => v.index > 0)
  9.                     .Select(e => new
  10.                     {
  11.                         name = e.ev[NameIndex],
  12.                         ev = e.ev[EventIndex],
  13.                         score = e.ev[ScoreIndex]
  14.                     }).ToList();

但我强烈建议你下载并安装 Unity3d 中的 Newtonsoft.Json（请自行搜索）。这样，你可以使用以下代码来反序列化 JSON 字符串：

  1. using Newtonsoft.Json;
  3. Data data = JsonConvert.DeserializeObject<Data>(www.downloadHandler.text);

但别忘了在你的 Data 类的所有属性上添加 {get; set;} 以便使用 Newtonsoft。

英文:

you can use this code for example

  2. 	List&lt;List&lt;string&gt;&gt; values = data.values;
  4. 	int NameIndex = values[0].IndexOf(&quot;Name&quot;);
  5. 	int EventIndex = values[0].Select((ev, index) =&gt; (ev, index))
  6.                               .First(ev =&gt; ev.ev.Contains(&quot;Event&quot;)).index;
  7. 	int ScoreIndex = values[0].IndexOf(&quot;Score&quot;);
  9. var scores = values.Select((ev, index) =&gt; (ev, index)).Where(v =&gt; v.index &gt; 0)
  10. 							.Select(e =&gt;  new
  11.                          	{
  12. 	                        name = e.ev[NameIndex],
  13. 		                    ev = e.ev[EventIndex],
  14. 		                    score = e.ev[ScoreIndex]
  15. 	                       }).ToList();

but I highly recommend you do download and install Newtonsoft.Json for Unity3d (google it). In this case you can deserialize a json string using this code

  1. using Newtonsoft.Json;
  3. Data data = JsonConvert.DeserializeObject&lt;Data&gt;(www.downloadHandler.text);

But to use Newtonsoft don't forget to add {get; set;} to all properties of your Data class

huangapple
  • 本文由 发表于 2023年6月12日 21:51:56
  • 转载请务必保留本文链接：https://go.coder-hub.com/76457350.html
  • c#
  • json
  • unity-game-engine
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定