What is the status on the spreadsheet writable API? I would like to go beyond visualization with my gadget and need to be able to output the new/updated data.
- Joel On Aug 16, 7:45 am, "Jerome (Guru)" <[EMAIL PROTECTED]> wrote: > Thanks Justin, you are right, the path you described here is the best > way to go. What I said earlier is not totally accurate, as the URL > must not only be encoded by also include the range. The 2 URLs I > listed below before and after encoding are in fact not the same. > > Bottom line, you are right, the easiest path right now is to add the > gadget first on the spreadsheet to get the path. > > Jerome > > On Aug 4, 5:20 pm, JustinK <[EMAIL PROTECTED]> wrote: > > > And to get the encoding: > > -go into the spreadsheet > > -insert the gadget (or any other gadget) by going to "Insert > > > Gadget..." > > -select the appropriate range by clicking "Range*" and then click- > > dragging the relevant range of data (or just typing into the the > > "Range*" field) > > -get the data source URL by clicking the arrow in the gadget's top- > > right, selecting "Get data source url...", and copying the generated > > URL. > > -and paste that encoded URL into the "data source URL" field in your > > elsewhere-deployed gadget. > > > Note that if you're just putting the gadget on iGoogle, you can use > > the "Add gadget to iGoogle" option in the arrow menu of the > > spreadsheet gadget. Much simpler. > > > Justin > > > On Aug 3, 9:14 am, "Jerome (Guru)" <[EMAIL PROTECTED]> wrote: > > > > Answer to my own question: the spreadsheet URL entered in the user > > > prefs must be encoded... > > > > In my example above, using this spreadsheet URL works like a charm: > > > http%3A%2F%2Fspreadsheets.google.com%2Ftq%3Frange%3DA1%253AB20%26key > > > %3DpIiX1y6MY6TOTBCr7K0HQWg%26gid%3D0 > > > > I hope this saves some time to others. > > > > Jerome > > > > On Jul 31, 10:09 pm, "Jerome (Guru)" <[EMAIL PROTECTED]> wrote: > > > > > Guys, > > > > > Have you been successful adding a spreadsheet API gadget on iGoogle? I > > > > have been trying for a bit of time with no success. I basically copied > > > > the sample gadget from the API doc and put it > > > > here:http://www.ljmsite.com/google/gadgets/tests/spreadsheet.xml > > > > > I created a test spreadsheet, made it readable by everybody and > > > > published > > > > it:http://spreadsheets.google.com/pub?key=pIiX1y6MY6TOTBCr7K0HQWg > > > > > When I put this spreadsheet URL in the prefs on iGoogle, the gadget > > > > starts, I can see it accesses spreadsheet.google.com and I get an > > > > error in the Javascript console because the XML parser is chocking on > > > > the CSS of the spreadsheet. The gadget ends up with a 'Request timed > > > > out' > > > > > If I add this test gadget on the spreadsheet itself, this works like a > > > > charm. > > > > > A spreadsheet would be an exellent data source for many gadgets, but > > > > is this working/supported/used as of today? > > > > > Jerome > > > > > On Jun 21, 12:57 am, "Vision Jinx (Guru)" <[EMAIL PROTECTED]> wrote: > > > > > > This is some really cool stuff Dan! > > > > > > Great job guys, I am looking forward to checking this out further. > > > > > Kudos! > > > > > > Cheers! > > > > > Vision Jinx > > > > > > On Jun 20, 4:35 pm, "Dan (Google Employee)" <[EMAIL PROTECTED]> > > > > > wrote: > > > > > > > For anyone that hasn't had a chance to try them yet, Spreadsheet > > > > > > Gadgets are XML-wrapped HTML, JavaScript, and Flash that use > > > > > > spreadsheets as dynamic, collaborative data stores. They can be > > > > > > embedded directly in spreadsheets, or can be deployed on iGoogle and > > > > > > third-party sites. > > > > > > > For some examples of what you can do with Spreadsheet Gadgets, check > > > > > > out these > > > > > > examples:http://documents.google.com/support/spreadsheets/bin/topic.py?topic=1... > > > > > > > In all of those examples, when you change the underlying data, the > > > > > > chart is automatically updated, reflecting the changes everywhere > > > > > > the > > > > > > gadget is published. > > > > > > > If your curiosity is piqued, check out our new documentation on > > > > > > Getting Started with Spreadsheet > > > > > > Gadgets:http://documents.google.com/support/spreadsheets/bin/answer.py?answer... > > > > > > and consider giving us > > > > > > feedback:https://spreadsheets.google.com/viewform?key=prK2zS2tW4hrLxARk2pz-aw > > > > > > > You can also submit your spreadsheet gadgets to the gallery and > > > > > > possibly get them featured in the Google Docs Spreadsheet Gadget > > > > > > Picker:http://code.google.com/apis/visualization/documentation/submitgadget.... > > > > > > > Thanks, > > > > > > Dan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "iGoogle Developer Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Google-Gadgets-API?hl=en -~----------~----~----~----~------~----~------~--~---
