Marc,
I got it to work by first creating the column headings one cell at a
time using the UpdateCell() method:
entry = self.gd_client.UpdateCell( row=row, col=col,
inputValue=inputValue,
key=self.curr_key, wksht_id=self.curr_wksht_id)
Note that the first cell in the ss is row='1', col='1'
>From the error message it appear that you are passing
in an argument, like 27, that needs to be in quotes, "27".
What line in your program caused the error?
/bill
On Jul 20, 5:44 am, Sk wrote:
> Hi,
> I am trying to connect google spreadsheet with python script.But
> its giving error.
>
>
A python script using query.AddNamedFolder() that I have not modified
since it
was working in late June is now returning Internal Server Error 500.
The script is the gdata-1.3.3 sample script 'docs_example.py' modiffed
as shown below
to get a feed of documents from a named folder. (The added lines
SKSK,
This is a good intro to spreadsheet functions:
http://code.google.com/apis/spreadsheets/docs/1.0/developers_guide_python.html
Particularly look at the spreadsheetsExample.py
http://gdata-python-client.googlecode.com/svn/trunk/samples/spreadsheets/spreadsheetExample.py
Note that if / when y
Do you still get the error if you wait 60 seconds after creating
the spreadsheet before trying to get the spreadsheet entry?
On Aug 28, 5:42 am, Malli wrote:
> For creating worksheet only way is to use spreadsheet data api.
> before creating worksheet entry i need to get spreadsheet entry based
To those interested in using Scripts,
it appears you can only access this feature in
Google Apps Premier Edition account ($50 per year).
It's not available in my plain Google acct or even
in my Apps Std Edition acct.
However I don't see this specifically stated in any of
Google's online or YouTube
art wrote:
>
> > I am with Premier Edition. Yes, I am a programmer.
> > Still if you read my initial question I doubt it is possible
> > that is why I asked. James if you want to help just post a working
> > script, I can read the documentation myself.
>
> > O
very
complicated example of that.
Regards,
Bill Hayes
On Sep 15, 7:58 am, thstart wrote:
> On Sep 14, 10:43 am, "Bill H." wrote:
>
> > I believe the following is true.
> > You cannot (automatically) do what you ask about.
>
> I suspected something lik
Hi
I have a python spreadsheet processing program that I'm converting
from a desktop app to a an App Engine app and therefore need to use
AuthSub.
I have it working for spreadsheets and documents via a multiple
scope token, but when I try to get a worksheet feed I get a
'Token invalid - AuthSub to
Dave,
Each entry (worksheet) in the worksheets feed has a row and col
parameter,
but these are the current limits (an empty sheet begins with
row=100,col=20)
so this isn't what you want.
The only solution I know of to get row and col count for a sheet
is to get the actual row and col values of the
download all the cells in the
> spreadsheet (or at least one column), which will add up fast in terms
> of time spent downloading, and overall data transfers. Probably not
> worth it.
>
> Thanks anyhow!
> Dave
>
> On Sep 20, 1:34 pm, "Bill H." wrote:
>
> >
A ClientLogin or ProgramamticLogin is required before you
can access even public docs.
The Google spreadsheet example is pretty good.
Regards,
Bill Hayes
On Sep 21, 5:17 pm, yanng wrote:
> I created a public spreadsheet. Here is the url:
>
> http://spreadsheets.google.com/ccc?key=0AvfttPfmmd_yd
then pass it to GenerateAuthSubURL() to get an AuthSub multi-
token
that can be used to access all of the feeds.
Regards,
Bill Hayes
On Sep 18, 8:12 pm, "Bill H." wrote:
> Hi
> I have a python spreadsheet processing program that I'm converting
> from a desktop app to a an
Hi Mark,
You also could read chunks (say 100 rows at a time) instead
of the entire sheet using a query to a cell based feed.
Something like this:
$query = new Zend_Gdata_Spreadsheets_CellQuery();
$query->setSpreadsheetKey($this->currKey);
$query->setWorksheetId($this->currW
Hi Max,
The first part, getting the user data, is straightforward.
The spreadsheet api is designed to allow you to retrieve data
several different ways, but your program could just periodically
read the 2nd row (the 1st row is column names), if it's not empty
extract the data and delete the row, t
Chitinuta,
Yes, you could have 2 or more clients. As long as they
each have a valid login.
If you're doing ClientLogin from a desktop there's no issue.
However, if you have a web app that uses AuthSub tokens there can
only be 10 outstanding tokens between a given server and a
given google acct, so
Mike,
To my knowledge no formatting is available via the API.
I hope they add it.
I haven't found a way to copy sheets, so you can't even
use a pre-formatted sheet as a template.
Regards,
Bill Hayes
On Sep 30, 11:48 pm, Mike Levin wrote:
> Is there a way in the API to turn off linewrap?
--~--~-
17 matches
Mail list logo
