google-sheets-api Questions
12
Solved
I have a googlesheet where a column may contain no information in it. While iterating through the rows and looking at that column, if the column is blank, it's not returning anything. Even worse, i...
Brummell asked 18/7, 2016 at 17:25
3
I have an application that I developed that utilizes a few Google Sheets.
I was able to figure out how to get it to have access to the Google Sheets API using the following code:
UserCredential ...
Windward asked 21/12, 2016 at 16:44
4
Solved
I am trying to connect to Google Sheets' API from a Django view. The bulk of the code I have taken from this link:
https://developers.google.com/sheets/api/quickstart/python
Anyway, here are the c...
Verdie asked 30/5, 2020 at 2:50
5
Solved
I basically have small images in a table that I'd like to enlarge on mouse click. I'd like the enlarged image to appear on the center of the page. On mouse click again to remove the enlarged image....
Hypabyssal asked 22/9, 2015 at 8:1
4
Solved
I'm trying to use an updated version of this example to connect to a private googlesheet via shiny, and deploy this app on the shinyapps.io server. The user is not required to authenticate to a goo...
Heid asked 22/8, 2020 at 10:38
12
Solved
I'm making an script to read data from google spreadsheet using the following script on nodejs:
var url = oauth2Client.generateAuthUrl({
access_type: 'offline',
approval_prompt: 'force',
scope:...
Hifalutin asked 22/7, 2016 at 20:29
6
I have a public (published) Google spreadsheet that I’m trying to download programmatically in TSV form.
In my browser, with a Google login active, for some actual key $key, https://spreadsheets....
Antipasto asked 17/6, 2014 at 3:56
10
Solved
I'm trying to auto-populate some raw data on a sheet in my google sheets file with a query.
It doesn't look like sheets has any built in functionality to do so like Microsoft Excel does.
Am I mis...
Discriminating asked 13/2, 2017 at 16:19
5
Solved
I want to delete a row using rowno in googlesheet using googlesheetv4 api.
Can anybody provide me a sample code for this?
I have created a method for delete row:
public void deleteRow() {
BatchU...
Interrogatory asked 26/8, 2016 at 6:18
4
Is there a way to use "Google Sheet Java API" with API key not with OAuth which is given in their examples
https://developers.google.com/sheets/api/quickstart/java
I know you can use HTTP reques...
Gratuity asked 23/12, 2018 at 4:27
4
Solved
If i scroll the spreadsheet ,header field of the rows are hidden and I need bold text format in the same spreadsheet.
Question
Can I set the freeze rows and styles through the spreadsheet api - Is...
Fite asked 9/5, 2014 at 12:58
5
Solved
Google Sheets document can contain some sheets. First is default and '0'. Generally for any sheet there is address like this:
https://docs.google.com/spreadsheets/d/(spreadsheetId)/edit#gid=(she...
Patrolman asked 22/10, 2018 at 17:15
2
Solved
I am trying to use the Google Sheets API. The problem is, once I call my script function on the google spreadsheet, I get the following error:
API call to sheets.spreadsheets.values.get failed wit...
Scuta asked 11/3, 2019 at 11:32
3
In Google Sheets, after selecting a series of rows and right clicking on one of them, there is an option under Row Height that is Fit to Data. I would like to do this in a script.
All of my search...
Neaten asked 9/8, 2017 at 21:9
3
I am making my first chrome extension. My idea is to call Google Sheets API to append a row in a google spreadsheet from my extension. I am referring this link for the same and successfully tried t...
Arvy asked 19/1, 2018 at 6:49
2
I'm using .net package Google.Apis.Sheets.v4 Client Library. Everything was fine, but last time (about a week ago) there is an error: The request is missing a valid API key. [403] when I'm trying t...
Septennial asked 29/5, 2018 at 18:10
5
The URL
https://sheets.googleapis.com/v4/spreadsheets/[ID_OF_SPREADSHEET]?key=[MY_API_KEY]
What I get
{
"error": {
"code": 403,
"message": "The caller does not have permission",
"status": ...
Allodial asked 15/3, 2017 at 10:22
2
Solved
I am trying to merge cells in Gsheets using Gspread for Python, however I can't find any documentation.
I have used the gspread_formatting module to format the text and colour of the cell, but I ...
Sori asked 23/7, 2019 at 14:45
7
Solved
I want to convert the time HH:MM into H.xx
Like I am getting it in this format: Sat Dec 30 00:00:00 GMT+05:21 1899
But this value is 04:29 in cell. I want it to be 4.5 hours to multiply it to hou...
Candicandia asked 5/4, 2018 at 14:1
2
I have a Google Sheet and I want to have its data updated from our server. Currently I'm using google sheet script editor. google sheet->tools->script editor https://developers.google.com/app...
Decrypt asked 20/6, 2018 at 7:21
5
I have created a Google Spreadsheet with five columns;
Once the user filled the values in the first three columns, It has to call a 3rd party API and fill the value(response) in the forth and fift...
Hodgkins asked 9/10, 2014 at 11:36
4
Solved
I have three columns in my spreadsheet. The first one is date, the second and the third are simple strings.
When I do batch upload of my data valueInputOption = "RAW" I get a wrong result for my ...
Septa asked 13/6, 2016 at 8:40
3
Solved
I am trying to write to a Google Spreadsheet using Google Sheet API v4.
The usage about the API is listed here
I made a curl request that looks like the following
curl -v\
-H 'Authorization: Be...
Roughen asked 27/7, 2019 at 18:53
2
Solved
I'm reading currency values from a website and I'd like to do some calculations with these numbers. They come in this format:
$7,821.24
Here's an example file:
https://docs.google.com/spreadsheets...
Kinzer asked 20/5, 2020 at 15:2
2
Solved
I'm using the Google Sheets API v4 for Java to fill a spreadsheet with some values:
String spreadsheetID = ...;
Spreadsheets service = new Sheets.Builder(GoogleNetHttpTransport.newTrustedTransport...
Autostability asked 23/5, 2020 at 16:49
© 2022 - 2025 — McMap. All rights reserved.