这是我创建电子表格的方式:
DocsService client= new DocsService ("idea");
client.useSsl ();
client.setOAuthCredentials (oauthParameters, new OAuthHmacSha1Signer ());
DocumentListEntry newEntry= new com.google.gdata.data.docs.SpreadsheetEntry ();
newEntry.setTitle (new PlainTextConstruct ("GIdeaDB"));
DocumentListEntry insertedEntry= client.insert (new URL (
"https://docs.google.com/feeds/default/private/full/?xoauth_requestor_id="+ userEmail), newEntry);
现在,我想在其中写第一行。
但不幸的是,所有API都基于存在以下事实的事实进行了接缝,即您已经插入了第一行名称-值对(其中名称是我要创建的标题)。http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingTableRecords
有什么想法可以创建第一行吗?定义字段名称的那个。
菲纳利找到了。您必须逐个单元地执行此操作:
oauthParameters= new GoogleOAuthParameters ();
oauthParameters.setOAuthConsumerKey (CONSUMER_KEY);
oauthParameters.setOAuthConsumerSecret (CONSUMER_SECRET);
oauthParameters.setOAuthType (OAuthType.TWO_LEGGED_OAUTH);
oauthParameters.setScope ("https://spreadsheets.google.com/feeds/");
SpreadsheetService spreadsheetService= new SpreadsheetService ("appname");
spreadsheetService.useSsl ();
spreadsheetService.setOAuthCredentials (oauthParameters,
new OAuthHmacSha1Signer ());
URL feedUrl= new URL (
"https://spreadsheets.google.com"
+ "/feeds/spreadsheets/private/full?title=Spreadsheetname&xoauth_requestor_id="
+ userEmail);
SpreadsheetFeed resultFeed= spreadsheetService.getFeed (feedUrl,
SpreadsheetFeed.class);
List <SpreadsheetEntry> spreadsheets= resultFeed.getEntries ();
SpreadsheetEntry spreadsheetEntry= spreadsheets.get (0);
URL worksheetFeedUrl= spreadsheetEntry.getWorksheetFeedUrl ();
log.severe (worksheetFeedUrl.toString ());
WorksheetFeed worksheetFeed= spreadsheetService.getFeed (
worksheetFeedUrl, WorksheetFeed.class);
List <WorksheetEntry> worksheetEntrys= worksheetFeed.getEntries ();
WorksheetEntry worksheetEntry= worksheetEntrys.get (0);
// Write header line into Spreadsheet
URL cellFeedUrl= worksheetEntry.getCellFeedUrl ();
CellFeed cellFeed= spreadsheetService.getFeed (cellFeedUrl,
CellFeed.class);
CellEntry cellEntry= new CellEntry (1, 1, "headline1");
cellFeed.insert (cellEntry);
cellEntry= new CellEntry (1, 2, "headline2");
cellFeed.insert (cellEntry);
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句