StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<pre><code>Google.GData.Documents.DocumentsService service = new Google.GData.Documents.DocumentsService("YOUR_APPLICATIONS_NAME"); service.setUserCredentials("YOUR_USERNAME", "YOUR_PASSWORD"); Google.GData.Documents.SpreadsheetQuery query = new Google.GData.Documents.SpreadsheetQuery(); query.Title = "YOUR_SPREADSHEETS_TITLE"; query.TitleExact = true; Google.GData.Documents.DocumentsFeed feed = service.Query(query); Google.GData.Client.AtomEntry entry = feed.Entries[0]; var feedUri = new Uri(Google.GData.Documents.DocumentsListQuery.documentsBaseUri); service.Insert(feedUri, entry); </code></pre> <p>This solution is basically about retrieving an existing spreadsheet (<a href="http://google-gdata.googlecode.com/svn/docs/folder23/M_Google_GData_Documents_DocumentsService_Query.htm" rel="nofollow"><code>service.Query</code></a>) using the <a href="http://code.google.com/apis/documents/" rel="nofollow">Document List API</a> and re-inserting it (<a href="http://google-gdata.googlecode.com/svn/docs/folder23/Overload_Google_GData_Documents_DocumentsService_Insert.htm" rel="nofollow"><code>service.Insert</code></a>).</p> <p>Make sure you replace the ALL CAPS application name, username, password and spreadsheet title.</p> <p>Add a reference to Google.GData.Documents.</p> <p>This is using .NET 4 (should work with lower versions as well) and <a href="http://code.google.com/intl/en/apis/documents/docs/2.0/developers_guide_dotnet.html" rel="nofollow">Google Documents List Data API v2.0</a> (DLL says version is 1.6.0.0: <a href="http://code.google.com/p/google-gdata/" rel="nofollow">google-gdata</a>), which seems to use version 3.0 of the protocol.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload