如何从 xamarin.forms 中的 Google 电子表格读取数据 [英] How to read data from Google spreadsheet in xamarin.forms
问题描述
我正在寻找一种直接从 Google Sheets
读取/写入数据的方法.有没有人知道如何在 Xamarin.Forms 中做到这一点?
I am searching for a way to read/write data from Google Sheets
directly. Does anyone have an idea how to do that in Xamarin.Forms?
请记住,使用 Install-Package Google.Apis.Sheets.v4
包从 Windows 表单访问 Google 表格
对我来说工作正常.
Keep in your mind access Google sheets
from Windows Form working fine with me using Install-Package Google.Apis.Sheets.v4
Package.
我使用了以下链接:
https://developers.google.com/sheets/api/quickstart/dotnet
推荐答案
我创建了以下解决方案并且对我来说效果很好:
I created the following Solution and it is working fine for me:
您需要使用来自 Google 表格的 JSON 结果,请尝试使用以下步骤:
You Need to use JSON result from Google sheet, try to use the following steps:
1-发布一个 google 表格以获取返回 JSON 的 API 链接,如下面的表格:
1-Publish a google sheet to get an API link that returns JSON, like the following Sheet:
2-您需要从 JSON 生成 C# 类,也许您可以使用http://json2csharp.com 获取 C# 类和 RootObject代码>.
2-You need to generate C# Classes from JSON, maybe you are able to use
http://json2csharp.com To get the C# Classes and the RootObject
.
3- 添加以下代码:
HttpClient client = new HttpClient();
string URL = "https://spreadsheets.google.com/feeds/list/1opP1t_E9xfuLXBkhuyzo5j9k_xBNDx0XKb31JwLP1MM/1/public/values?alt=json";
var response = await client.GetAsync(string.Format(url));
string result = await response.Content.ReadAsStringAsync();
RootObject root = JsonConvert.DeserializeObject<RootObject>(result);
从 root
对象,您将能够访问 Google 工作表上的任何单元格值.
From the root
object, you will be able to access any cell value on the Google sheet.
这篇关于如何从 xamarin.forms 中的 Google 电子表格读取数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!