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 have a sample Spreadsheet setup to test with. its publicly open, and published and shared all that good stuff that lets it be very accessible for testing.
key = 0AkXM-eHWCTzedHdMU3JXdFA0SWpFSVFXUGhRTWEyVmc
the spreadsheet HTP>spreadsheets.google.com/ccc?key=0AkXM-eHWCTzedHdMU3JXdFA0SWpFSVFXUGhRTWEyVmc&hl=en
the feed. HTP>spreadsheets.google.com/feeds/cells/0AkXM-eHWCTzedHdMU3JXdFA0SWpFSVFXUGhRTWEyVmc/1/public/basic
based on the feed url and the api these would be my best guesses as how it might be possible through the address bar.
HTP>spreadsheets.google.com/feeds/cells/0AkXM- eHWCTzedHdMU3JXdFA0SWpFSVFXUGhRTWEyVmc/1/public/basic/R1C1/latest?content=HelloWorld
//doesn't make a change
replace basic with full
//Bad or unsupported projection for this type of operation.
remove /1 (page identifyer)
//Unknown visibility value.
I assume the variable to change would be called Content, based on the feed data, i also assume the id of the cell A1 is referred to as R1C1 in this context.
PHP or JavaScript would be acceptable answers too as long as it will work well with Flash
I don't want to use ZendFramework due to the installation. But it might make a good reference if you understand php well.