我已经通过Google在开发者指南表格API的官方文档中提到的简单Java代码在My Google Drive帐户的现有电子表格中成功创建了一个新的工作表,但是我想通过Java代码在Google Drive帐户中创建一个新的电子表格。在链接中,他们没有提及任何示例代码。我已经看到Spreadservice类中可用的不同方法。
如何使用Google Spreadsheets API做到这一点?
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ import com.google.gdata.client.spreadsheet.*; import com.google.gdata.data.Link; import com.google.gdata.data.PlainTextConstruct; import com.google.gdata.data.TextConstruct; import com.google.gdata.data.docs.ExportFormat; import com.google.gdata.data.spreadsheet.*; import com.google.gdata.util.*; import java.io.IOException; import java.net.*; import java.util.*; import javax.xml.soap.Text; /** * * @author satyam */ public class SpreadSheet { public static void main(String[] args) throws AuthenticationException, MalformedURLException, IOException, ServiceException { SpreadsheetService service = new SpreadsheetService("gBuddy"); // TODO: Authorize the service object for a specific user (see other sections) String USERNAME = "USERNAME"; String PASSWORD = "PASSWORD"; service.setUserCredentials(USERNAME, PASSWORD); // Define the URL to request. This should never change. URL SPREADSHEET_FEED_URL = new URL( "https://spreadsheets.google.com/feeds/spreadsheets/private/full"); // Make a request to the API and get all spreadsheets. SpreadsheetFeed feed = service.getFeed(SPREADSHEET_FEED_URL, SpreadsheetFeed.class); List<SpreadsheetEntry> spreadsheets = feed.getEntries(); // Iterate through all of the spreadsheets returned for (SpreadsheetEntry spreadsheet : spreadsheets) { // Print the title of this spreadsheet to the screen; System.out.println(spreadsheet.getTitle().getPlainText()); } SpreadsheetEntry spreadsheet = spreadsheets.get(1); // System.out.println(spreadsheet.getTitle().getPlainText()); // // Create a local representation of the new worksheet. WorksheetEntry worksheet = new WorksheetEntry(); worksheet.setTitle(new PlainTextConstruct("New Worksheet")); worksheet.setColCount(10); worksheet.setRowCount(20); // Send the local representation of the worksheet to the API for // creation. The URL to use here is the worksheet feed URL of our // spreadsheet. URL worksheetFeedUrl = spreadsheet.getWorksheetFeedUrl(); WorksheetEntry insert = service.insert(worksheetFeedUrl, worksheet); } }
经过一些研究,我发现了这个答案很简单。我们无法使用 Google Spreadsheet API 在google驱动器中创建新的电子 表格 。
注意: 我们可以通过Google Spreadsheet API在Google驱动器的现有电子表格中创建新工作表,但无法使用电子表格api创建新的电子表格。
要创建和上传新的电子表格或 Google Drive 支持的任何其他类型的文档,我们必须使用 Google Drive API 。
这就是我想要的。通过这种方式,我们可以使用Google Drive API在Google Drive中创建一个新的电子表格。
DocsService docsService = new DocsService("MySampleApplication-v3"); docsService.setUserCredentials(USERNAME, PASSWORD); URL GOOGLE_DRIVE_FEED_URL = new URL("https://docs.google.com/feeds/default/private/full/"); DocumentListEntry documentListEntry = new com.google.gdata.data.docs.SpreadsheetEntry(); documentListEntry.setTitle(new PlainTextConstruct("Spreadsheet_name")); documentListEntry = docsService.insert(GOOGLE_DRIVE_FEED_URL, documentListEntry);
为了创建一个新的电子表格,我们必须创建new SpreadsheetEntry()对象,对于任何其他文档,我们必须创建new DocumentEntry()对象。
new SpreadsheetEntry()
new DocumentEntry()
现在,如果我们必须在Google驱动器中上传任何类型的文档(xls,doc,图像等),我们都可以这样做
//File upload in google drive DocumentListEntry uploadFile = new DocumentListEntry(); uploadFile.setTitle(new PlainTextConstruct("FILE_NAME_DISPLAY_IN_DRIVE")); uploadFile.setFile(new File("FILE_PATH"), "MIME_TYPE_OF_FILE"); uploadFile = docsService.insert(GOOGLE_DRIVE_FEED_URL, uploadFile);