如何将Android应用程序与Google表格电子表格连接起来？ [英] How do I connect Android apps with Google Sheets spreadsheets?

问题描述

我正在尝试执行需要与Google电子表格API协同工作的Android应用。我是新手，所以我从api的第3版开始： https： //developers.google.com/google-apps/spreadsheets/

我遵循了所有步骤，将所有jar文件下载到 lib 子文件夹放在我的项目文件夹中，然后像往常一样添加到Eclipse中的构建路径。因此，尽管没有Java示例来执行Oauth 2.0，但我只是试图声明：

  SpreadsheetService service = new SpreadsheetService（v1 ）; 
  

但是当我模拟这条简单的线时，它给了我一个错误：

  java.lang.NoClassDefFoundError：com.google.gdata.client.spreadsheet.SpreadsheetService 
  

我使用了文档中包含的所有jar文件，并且导入了：

  import com.google.gdata.client.spreadsheet.SpreadsheetService; 
  

但我完全失去了。我不知道还有什么可以开始的，连接到Google API并使用电子表格。

解决方案

非常感谢Scorpion！有用！！我一直在试这个太久了。
好​​的，这里是我的解决方案：
我开始一个新项目，并包含这些罐子：

  gdata- client-1.0 
 gdata-client-meta-1.0 
 gdata-core-1.0 
 gdata-spreadsheet-3.0 
 gdata-spreadsheet-meta-3.0 
 guava-13.0 .1 
  

和我的代码：

  SpreadsheetService spreadsheet = new SpreadsheetService（v1）; 
 spreadsheet.setProtocolVersion（SpreadsheetService.Versions.V3）; 
 
尝试{
 spreadsheet.setUserCredentials（username，password）; 
网址metafeedUrl =新网址（https://spreadsheets.google.com/feeds/spreadsheets/private/full）; 
 SpreadsheetFeed feed = spreadsheet.getFeed（metafeedUrl，SpreadsheetFeed.class）; 
 
列表< SpreadsheetEntry> spreadsheets = feed.getEntries（）; （SpreadsheetEntry服务：电子表格）
 {
 System.out.println（service.getTitle（）。getPlainText（））; 
} 
} catch（AuthenticationException e）{
 e.printStackTrace（）; 
} 
  

当然，这是在不同于主线程的线程中执行的。没有OAuth 2.0的Java文档，但我会尝试，如果我不能这样做，我会问这里。
再一次，非常感谢你，我希望在这段时间足够的时间里帮助你。 ：）

I'm trying to do an Android app that needs to work with Google spreadsheet API. I'm new in this, so I'm starting with the version 3 of the api: https://developers.google.com/google-apps/spreadsheets/

I followed all the steps, downloaded all the jar files to lib subfolder in my project folder and then I added to the build path in Eclipse as usual. So although there is no Java example to perform Oauth 2.0, I just tried to declare:

SpreadsheetService service = new SpreadsheetService("v1");

but when I emulate this simple line it gives me an error:

java.lang.NoClassDefFoundError: com.google.gdata.client.spreadsheet.SpreadsheetService

I'm using all the jars included in the documentation and I have the import:

import com.google.gdata.client.spreadsheet.SpreadsheetService;

but I am totally lost. I dont know what else to do just to start, connect to Google APIs and work with the spreadsheets.

解决方案

Thank you so so much Scorpion! It works!! I've been trying this for too long. Ok here is my solution: I started a new project and included these jars:

gdata-client-1.0
gdata-client-meta-1.0
gdata-core-1.0
gdata-spreadsheet-3.0
gdata-spreadsheet-meta-3.0
guava-13.0.1  

and my code:

    SpreadsheetService spreadsheet= new SpreadsheetService("v1");
    spreadsheet.setProtocolVersion(SpreadsheetService.Versions.V3);

    try {
        spreadsheet.setUserCredentials("username", "password");
        URL metafeedUrl = new URL("https://spreadsheets.google.com/feeds/spreadsheets/private/full");
        SpreadsheetFeed feed = spreadsheet.getFeed(metafeedUrl, SpreadsheetFeed.class);

        List<SpreadsheetEntry> spreadsheets = feed.getEntries();
        for (SpreadsheetEntry service : spreadsheets) {             
            System.out.println(service.getTitle().getPlainText());
       }
    } catch (AuthenticationException e) {           
        e.printStackTrace();
    }

of course this is executed in a different thread not in the main thread. There is no java documentation for OAuth 2.0 but I will try and if I can't do it I'll ask here. Again, thank you very much and I hope to help you when I work on this time enough. :)

这篇关于如何将Android应用程序与Google表格电子表格连接起来？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！