I want a spreadsheet function that will produce a sum of all values in column B for when column A is equal to 'X' and when it is equal to 'Y' A B X 10 Y 3 X 7 X 22 Y 4 Y 9 The output should look like the following (where 39 & 16 are the results of the formulas): X 39 -> 10 + 7 + 22 Y 16 ...
I am looking for a way to automatically change the color of the minimum cell in a row in google docs spreadsheet. So, for a table like 1 | 2 | 3 4 | 2 | 1 2 | 1 | 6 It would color all the cells with '1' in them. ...
Hi, Can anybody please tell me is there any possible way to connect to spreadsheet from python? I want to store some data from a form and submit it to google spreadsheet. Please help on this issue. What steps do I have to follow? Thanks in advance... ...
I've read through the Google Spreadsheets API PHP documentation. All examples are using Zend, which I cannot use. See this page: http://code.google.com/apis/spreadsheets/docs/1.0/developers%5Fguide%5Fphp.html Does anybody know a simple example of the following: How can I use PHP w/ curl (or whatever) and the Google Spreadsheets API to ...
I could not find the function that returns the name of the cell referenced. For example, =SOMETHING(A5) that will return A5 as string. So that, I can write ="For more information, see " & SOMETHING(F50) & "." in a cell and the cell will read For more information, see F50., and then, when I move the F50 cell, the text will also change. ...
How can I save data in unpublic google spreadsheet in PHP without using Zend Gdata lib? I can't use Zend libs, as it's shown on google tutorials, because the php server on which I'm running the script is php v. 5.0.4. I tried to find a solution using cUrl, but I can't omit the problem with authentication when doc is unpublic. How can I d...
I cant seem to get updateCell to work. API reference: HTP>code.google.com/apis/spreadsheets/data/1.0/developers_guide_php.html This is equivalent to sending an authenticated PUT request with the updated cell's XML representation to the URL: PUT HTP>spreadsheets.google.com/feeds/cells/key/worksheetId/private/full/cell/version I h...
Is there a way to automate the process of creating a chart within a google doc from a .NET application. The workflow I'm looking for is... Create Excel Document. Upload to Google Docs. Create charts on the spreadsheet. (Can't figure this out.) Publish using ACLs. (bonus) I'm not sure if I'm supposed to use the Google Chart API for t...
I have this code which is working, to load a Google Spreadsheet and load some data from it. If the spreadsheet in question is public, how do i modify the code to not require a username/password? $key="keytothespreadsheet"; $user="[email protected]"; $pass="*****"; $authService = Zend_Gdata_Spreadsheets::AUTH_SERVICE_NAME; $httpClient = ...
Hi, I've seen; http://stackoverflow.com/questions/725627/accessing-google-spreadsheets-with-c-using-google-data-api and http://code.google.com/apis/spreadsheets/data/2.0/developers_guide_dotnet.html#CreatingRows However i'm still having trouble inserting a new row in to an existing google spread sheet. Does anyone have a canned exam...
Hi All, I am working with a small theatre company. Currently they have a list of people on paper with notes about their skills next to each one. I want to create a database / directory for them so that they can add, delete, update and search for people. It is a very simple and common scenario I know but the issue here is that I only hav...
Is it possible to nest simple programs within a Google doc spreadsheet, similar to how you would w/Basic in Excel? Or alternatively a simple = syntax using regex, if there is a way to do that in google docs? I want to take a list of multiple names(name1, name2, name3) in a single cell from across multiple identical sheets and transpose ...
I have recorded a macro in Excel, but I want to run this code in Google spreadsheets. I do not know how to program in either code. How do I convert them? I tried an online VB to Javascript converter, but this does not work with VBA. ...
I've been trying to keep this little project entirely within Google docs, but I may have hit a wall. The spreadsheet is being used as a way for multiple users to record individual events with a Template they duplicate. I want to be able to compile a list of names of those attended onto a "report" sheet from all of the unique sheets, whic...
If I create a Google apps script, can I hook it up to Google spreadsheet to run based on an event, or must I manually invoke it? I don't know if Google spreadsheet supports any events. For example: a Google app script that strikes out rows in the spreadsheet that have been marked completed by way of a column having the digit 1 beside c...
I have a Google Spreadsheet with 3 columns which are either blank or have a value. I want to get the count of the number of rows that has A and either B or C populated. If I were writing a SQL query it would be select count(*) from Table where A is not null and (B is not null or C is not null) But I can't for the life of me figure...
I am looking for a solution on how to display Google spreadsheets in web page using Servlets. Something like this: user logs into the application and then opts to create a new google spreadsheet. I just want to know how to display google spread sheet in web application using servlets. I don't want to create a spreadsheet in my account a...
Inserting rows one by one from a 600 record data-set is taking almost an hour, using the following method: foreach($people as $person){ $insert['name'] = $associate -> name; $insertedListEntry = $spreadsheetService->insertRow($insert, $spreadsheetKey, $worksheetId); } Is it possible to insert multiple rows at once? ...
I see the answer here is no, but wondered if there is any update to that. Thanks. ...
I am impressed by what I have seen of yeroon.net/ggplot2 which is a web interface for Hadley Wickham's R package ggplot2. I want to try it out on my own data. The part that has me very excited is that one can use data stored in one's own Google spreadsheet as the data. One just signs into their Google Account so that yeroon.net/ggplot2 c...