Is it possible to pull rows from a Google Docs spreadsheet using PHP? In SQL I would use something like: SELECT * FROM table WHERE field = 'value' LIMIT 1 Is there a way to do this? I've heard you are supposed to use a 'Zend' framework, but I haven't been able to figure that out either. Any help would be appreciated ...
I'm thinking that someone might of already solved this problem. I tried to look at the Spreadsheets API and there's no mention of being able to download the file. cURL might be an option but I'd rather not get into the hassle of authenticating / POSTing manually. ...
Getting super frustrated trying to get this working. Basically this is for a site (x10hosting.com) where I can't include the zend gdata framework, so I'm trying to use the Google Data API with php cURL to access it. The most I've been able to do is return a list of the supplied usernames worksheets, using this script: <?php // Construc...
Hi, I am trying to learn how to use the Google Spreadsheets API through the Developer's Guide: Java. My application can authenticate to the spreadsheets service,retrieve a worksheet-based feed and create a table. The next step would be to create a table record what I am trying to do. My problem is when I run the application I obtain thi...
I have the date of birth of a person and want to calculate the days until his/her next birthday. How to do this in a way to deal with leapyears and other "odd" things? ...
I would like to have some Javascript code running in a web browser write to a Google Spreadsheet in the user's Google account. The Javascript API is a bit long-winded, involving lots of round trips, but does seem to work. I can successfully log in, create a new spreadsheet, read values from it, update cells, etc. However, I haven't yet ...
I like writing my own formulas inside of Google Docs Spreadsheets. But often what I want to do is very similar to a function that already exists. As an example, I couldn't find a function to turn a date (31-Aug-2010) into the lexical day of the week (Tuesday). I'd like to write: =LexWeekDay('31-Aug-2010') 'Tuesday' Clearly I can write...
I have a Google Spreadsheet with a value (in seconds) for a lot of teams. I want to calculate points for each team from 0-10: 10 points for the team with the lowest value, 0 points for the team with the highest value and 9-1 points for the values in between (evenly distributed). I honestly can't think of any formular to do this...and I ...
Hi, I am trying to insert a row into the middle of a google worksheet, however cannot find a way in the api documentation, I cannot add a new row to the bottom as the program that consumes the spreadsheet data(not written by myself) simply ignores new rows added to the bottom. anyone got any Ideas? Thanks, Mark ...
Hi, I'm wanting to copy an already existing Google Docs Spreadsheet to a new Google Docs spreadsheet. I dont think the v2.0 .NET API can handle it natively (or if so I can't find the class/method), however It looks like the v3.0 protocol can but I'm not sure how to implement this in the current framework or even if it is possible with t...
Hi, is there a way to know, who created an entry in a google spreadsheet via a form without giving them an account to our google apps domain? I am working a system to distribute users to different groups. first the users have to input there preferences the users are distributed between the groups with regard to some contraints like ...
I wrote a script here to access a Google Spreadsheet by name using Ruby: http://gist.github.com/606488 I'm trying to use gdata as per the instuctions here: http://code.google.com/apis/gdata/articles/gdata_on_rails.html How come I'm getting a 401 error "Token invalid" when using the gdata gem? It works fine when I use the methods descr...
Hello, I´d like to know how to upload to a Google Spreadsheet, values stored in the database of my application. Objective: Connecting to Google Spreadsheet and automatically fill in a chart in the admin area with values that were passed by the upload. I've been giving a look in the docs and it seems to me that I have to use Bulk Loa...
Does anyone know if I can use google spreadshit for storing results of my custom HTML form ? I know that google spreadsheet allows creating form on google domain itself but is it possible to use google spreadsheet as db for other webapps ? ...
I've a Google spreadsheet in Google Apps. When I enter a date/time in spreadsheet, I want to create a corresponding entry in a particular Google Calendar? How can I do this? This thread suggests some sort of scripting but complete solution is not given. And I'm using Google Apps instead of Google Docs as suggested by this thread. Updat...
<html> <body> <iframe width='500' height='500' frameborder='0' src='https://spreadsheets.google.com/ccc?key=0ApILEVmEy4YHdGRTdGZNTWd1cmc2c0RPN0dtSnZGWHc&hl=en'> </iframe> </body> </html> This Code dispays spreadsheet in some bowsers.In all bowsers it shows spreadsheets but ie it shows login page ...
I'm completely new to spreadsheets. I hope spreadsheets come under the remit of this site. If not my apologies. Basically I'd like to enter the # of years in one cell, call it variable x. Then I'd like another cell(s) to add up the sum of only x number of cells. It seems pretty basic, but I have no idea how to go about it. Thank you fo...
I'm trying to write code that talks to Google Spreadsheets. We do a bunch of processing on our end and then pass data out to our client into this spreadsheet and I want to automate it. This seems like it should be easy. On this page, Google says "Given a SpreadsheetEntry you've already retrieved, you can print a list of all worksheets...