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
