I am pulling data down from a webservice and it is formated as JSON. I am writing a google apps script for google spreadsheet that will populate the data form me. my problem is, I can't seem to get it to parse out. doing: var dataset = myJSONtext; Browser.msgbox(dataset.item[0].key); errors out, saying item[0] is not defined. Is th...
I am trying to save data from my existing webform written in php to a google spreadsheet. I tried the Zend GData and can't seem to find my way around it. Does anyone have a better solution for this. Is it possible to grab the data and insert it into mysql database and to google spreadsheet at the same time? ...
I'm trying to access my Google spreadsheets using the GData API. I have followed the example which looks like: var service = new SpreadsheetsService("myTest"); service.setUserCredentials(username, password); var query = new SpreadsheetQuery(); var feed = service.Query(query); This should return a feed with a list of spreadsheets. Howe...
I'm using ImportXML in a Google Spreadsheet to access the user_timeline method in the Twitter API. I'd like to extract the created_at and text fields from the response and create a two-column display of the results. Currently I'm doing this by calling the API twice, with =ImportXML("http://twitter.com/status/user_timeline/matthewsim.x...
I am using gd_client.UpdateCell to update values in a google spreadsheet and am looking for a way to update the formatting of the cell i.e. color, lines, textsize..... Can this be done? Are there examples or other documentation available? Anything to get me going would be great ...
I am trying to write a pre-qualification programming exam, hopefully using Google Forms... however they seem to be unable to do new-lines in both the questions and the section headers... My current format is new page for each question, with a "section header" as the main question (because it has a textarea for the "code snippet") and a ...
Is there a good method of storing a list of rows in a cell and then detecting whether a certain row is in that list? The method I have seems a bit over the top. I label each row with a prime number, then store the list of rows as the product of each prime, missing out the rows I don't want in my list. Detecting whether a given row is...
I have a google spreadsheet that uses this function: =SUM(E:E) - SUM(C:C) It adds up all the values of column E and column C and them subtracts the difference. I would like to be able to return a 0 if the difference is negative. ...
Trying to access google spreadsheets using their api. following their example, the code doesnt work, and its not obvious why. All I'm trying to do is to connect, and I keep getting back the same error. This is with their code set as of 4/15/10. Can anyone offer any suggestion on what I'm doing wrong? CodE: using System; using Googl...
I am using Zend_Gdata_SpreadsheetsListQuery. In PHP my query is: "confirmation=$confirmation" The problem is that $confirmation = 'AB-CD-EFG-012345'; Apparently the hyphens are causing problems with the query and the exception thrown is: Uncaught exception 'Zend_Gdata_App_HttpException' with message 'Expected response code 200, go...
Hi guys, Don't know if anyone has experience with the Google Spreadsheets API or the Zend_GData classes but it's worth a go: When I try to insert a value in a 750 row spreadsheet, it takes ages and then throws an error that my memory limit (which is 128 MB!) was exceeded. I also got this when querying all records of this spreadsheet bu...
Does anyone know if it's possible to use Google Apps Scripts to run without needed a manual event? Meaning - I would like to set up a spreadsheet to send a form every day at a specified time. I have figured out how to manually send the form by executing a script, but has Google implemented to ability to set a script to run in the future ...
Is there a way to embed Google Spreadsheets editor with Compact controls (ctrl+shift+f) by default? Maybe there is some url parameter for it? Or maybe there is ready js library to add simply row-by-row editor on page using Speadsheets API's list-based or table/records feeds? ...
How do I make a Google gadget embedded in a website force refresh to reflect updated data in a Google Spreadsheet? ...
We would like to provide a mechanism for the user to enter data in a excel sheet kind of an interface, so that users can create it online. What kind of solutions are available to acheive this? Would it be possible to use spreadsheets.google.com as an embedded widget so that users can manipulate the doc. Are there any other options availa...
Hi, I've created a pretty complex Google spreadsheet. I would like a user to be able to click a button or follow a link, and get a copy of this spreadsheet where they can fill in data. I would later check process this data manually. Is there anyway I can do this via a complicated link, or some Javascript, or possibly even using a ser...
Hi, I'm trying to implement some basic functionality for Google Spreadsheets, using the protocol specification with requests. The reason i'm doing this because it is for Android, and gdata-java library doesn't really work and the alpha android one doesn't really cut it. I managed to implement authentication, and get for lists, and delet...
Maybe someone somewhere is written a Ajax wrapper to handle google spreadsheet's api? I've managed to take their form's html and style it to fit my website's theme, but the success page always loads with the standard blocky feel of google. Any ideas? ...
I have utf-8 data which I would like to save as csv. My old version of Excel mangles utf-8, so I have to resort to using google's spreadsheet which handles utf-8 beautifully. Some of my data have commas in them, so I must wrap every field of data in the csv with double quotes. I have hundreds of lines, so it would take some time to do it...
Hi, if someone have experience with google spreadsheet api can answer me this problem, is there a way to get spreadsheet form key through api or some web-service call? Thanks Ram ...