使用.Net检索Google表格数据(Google API客户端) [英] Retrieve Google Sheet Data using .Net (Google API Client)
问题描述
嗨
有没有人提供可以从Googlesheet下载数据的.Net解决方案示例?我不想重新发明轮子.
Does anyone have an example of a .Net solution that can download data from a Googlesheet ?. I don't fancy reinventing the wheel.
我尝试使用VBA在Excel文件中执行此操作，但无济于事，它只会导致一系列错误.看来这可能适用于Windows 10，但不适用于Windows 7等.请参见
I have tried using VBA to do this in an Excel file but to no avail, it just leads to a trail of errors. It seems this may work in Windows 10 but not for Windows 7 etc. See
https://productforums.google.com/forum/#!topic/docs/ZX8DaVdNq7I;context-place=topicsearchin/docs/Oauth2$20to$20import$20Google$20Sheet$20to$20Excel
https://productforums.google.com/forum/#!topic/docs/ZX8DaVdNq7I;context-place=topicsearchin/docs/Oauth2$20to$20import$20Google$20Sheet$20to$20Excel
我知道Google控制台以及Oauth2&凭据等...
I am aware of the Google console and the creation of the Oauth2 & credentials etc ...
我的最终目标是从Google表格下载数据并运行自己的宏，或者将其切换到excel文件并执行仪表板.
My ultimate goal is to download data from Google Sheet and run my own macros or swtch to the excel file and do my dashboard.
我必须使用Googlesheet的唯一原因是它具有协作能力和整理来自多个用户的输入.然后，我可以创建摘要.
The ONLY reason I have to go to Googlesheet is its ability to collaborate & collate inputs from multiple users. Then I can create my summaries.
谢谢.
Kuldip Mond
Kuldip Mond
推荐答案
我怀疑您需要使用Google API:
I suspect you will need to use the Google API:
https://developers.google.com/api-client-library/dotnet /apis/sheets/v4
下面的链接也可能有帮助，尽管其中一些示例在C#中:
The below link may help as well, although some of the examples are in C#:
这篇关于使用.Net检索Google表格数据(Google API客户端)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
