google-sheets-api

Accessing Google Spreadsheets with C# using Google Data API

According to the .NET user guide: Download the .NET client library: Add these using statements: using Google.GData.Client; using Google.GData.Extensions; using Google.GData.Spreadsheets; Authenticate: SpreadsheetsService myService = new SpreadsheetsService(“exampleCo-exampleApp-1”); myService.setUserCredentials(“[email protected]”, “mypassword”); Get a list of spreadsheets: SpreadsheetQuery query = new SpreadsheetQuery(); SpreadsheetFeed feed = myService.Query(query); Console.WriteLine(“Your spreadsheets: “); foreach (SpreadsheetEntry entry in feed.Entries) { Console.WriteLine(entry.Title.Text); } Given … Read more

Copying a spreadsheet copies all linked files as well

How about this workaround? In this workaround, Sheets API is used for copying a Spreadsheet. In the case of copy() of Class Spreadsheet, makeCopy() of Class File and Files: copy of Drive API, the copied spreadsheet includes the bound scripts and linked forms. So I thought to use Sheets API. The flow of this workaround … Read more

How do I access (read, write) Google Sheets spreadsheets with Python?

(Jun-Dec 2016) Most answers here are now out-of-date as: 1) GData APIs are the previous generation of Google APIs, and that’s why it was hard for @Josh Brown to find that old GData Docs API documentation. While not all GData APIs have been deprecated, all newer Google APIs do not use the Google Data protocol; … Read more

Google Sheet API V4(Java) append Date in cells

To provide an example of what Sam’s answer means, if you just want to create a date value using AppendCellsRequest, you can create the cell like this: CellData cell = new CellData(); cell.setUserEnteredValue(new ExtendedValue().setNumberValue(42198.0)); cell.setUserEnteredFormat( new CellFormat().setNumberFormat(new NumberFormat().setType(“DATE”))); Here 42198 is the number of days between December 30th 1899 and July 13th 2015.

Google Sheets API returns “The caller does not have permission” when using server key

To solve this issue, try to: Create a service account: https://console.developers.google.com/iam-admin/serviceaccounts/ In options, create a key: this key is your usual client_secret.json – use it the same way Make the role owner for the service account (Member name = service account ID = service account email ex: [email protected] Copy the email address of your service … Read more