Thanks, David. -Vic
On Tue, Jan 11, 2011 at 4:31 PM, David Bullock <[email protected]> wrote: > Hi Karthick, > > Each spreadsheet is composed of worksheets, and each worksheet has a > series of 'feeds' available. You can query each feed with a simple > HTTP GET request and a few query parameters in a URL, and get back > some XML representing the items being fed. One of the feeds is a > 'cell' feed. When you query the cell feed, you get a list of cells. > Attached to each cell is an 'updated' property. Slightly complicating > the scene is that any XML you get back from a feed is shoehorned into > the ATOM format. > > Although Google don't actually document the circumstances under which > the 'updated' property of a cell actually changes, one might > reasonably expect it to behave in such a fashion that newly-added > cells and recently-updated cells will have a later 'updated' > property. I will not, however, bet you $50 that this is actually the > case. > > Ideally, one would be able to query the feed in such a fashion as to > say: "send me only those cells which have been updated since I looked > last Friday at 2:12pm". Unfortunately, that option is not open to us > spreadsheet API users as of today, since the spreadsheet v3.0 protocol > doesn't support the the google data 2.0 protocol universal query > parameters of 'gd:updated-min' and 'gd:updated-max' (I have filed an > enhancement request - you can 'star' it to vote for it at > > http://code.google.com/a/google.com/p/apps-api-issues/issues/detail?id=2363&sort=-id&colspec=API%20ID%20Type%20Status%20Priority%20Stars%20Summary > ) > > In the meantime, you'll have to query the worksheets feed (possibly > querying by worksheet name), to see if the 'updated' property of the > worksheet of interest is later than when you last asked. If so, you > can re-query the cells feed and rebuild your web-app's local > representation of that data. If you're only interested in particular > cells, you can query the feed so that it only gives you those ones. > > I haven't given you any exact examples, but you'll have to go and read > these documents about the spreadsheet-related feeds: > > https://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html > https://code.google.com/apis/spreadsheets/data/3.0/reference.html > > And these 3 documents about the gdata protocol itself: > > https://code.google.com/apis/gdata/docs/2.0/basics.html > https://code.google.com/apis/gdata/docs/2.0/reference.html > https://code.google.com/apis/gdata/docs/2.0/elements.html > > Once you've done that, you can go ahead and start issuing HTTP > requests and parsing the XML responses. In practice, you might like a > little bit of help with the more tedious aspects of that and use a > client-side library. There is a list of them here: > > https://code.google.com/apis/gdata/docs/client-libraries.html > > Keep in mind that these APIs assist with using the GData protocol ... > they don't generally attempt to addresss spreadsheet-specific concepts > - the data-structures they give you very closely model the XML the > feed dishes out. Your understanding of the meaning of those structures > comes from the first 2 documents above. > > I hope that helps. The only other advice I can give is don't expect > to get something done *quickly*. Give yourself a week to read, digest > and play. Then, with your favourite API (or without it), write those > HTTP requests, parse those XML responses, and use the information in > your app. > > cheers, > David. > > > On Jan 11, 9:51 pm, karthick kumar <[email protected]> > wrote: > > Hi, > > i want to know weather is it possible to take data from google > spreadsheet > > to my website page,when i change data or edit cell values along with cell > > information, if possible can any one please help me do to this, > > > > Thanks in Advance > > > > Please help >
