Reading the _table_query_url straight from prefs is great, and lets me export the worksheet as html or csv.
But the toolbar option to publish as an iframe doesn't work as well. Maybe it's just the environment where I'm trying to paste it, but I get a tiny iframe where my gadget has to scroll and it screws up the subsequent HTML. The script that I get from the Publish Gadget... dialog on the spreadsheet gadget works great, and includes the prefs I set as well (which the iframe code doesn't). So I'd much rather give my users that script than the iframe. But I'm still investigating. Thanks On Apr 28, 5:50 am, VizGuy <[email protected]> wrote: > So the gadget helper is not a specific Google Spreadsheet code, and so, the > most it will do is to return the data source url, and you will have to parse > it, which is not THAT complicated.But then - you can do it quite easily > anyway, by reading the data source pref and getting the key. > > Regards, > VizGuy > > On Sun, Apr 26, 2009 at 10:34 PM, Scott G <[email protected]> wrote: > > > I'm creating a custom gadget that I will use in a blog to display > > charts. I'd like to add the toolbar at the bottom so that my readers > > can get the csv or html or script to embed in their own blogs. > > > The problem is that I don't want to put the key to the spreadsheet in > > the XML because I want to use the same gadget to create visualizations > > for several spreadsheets. GadgetHelper's createQueryFromPrefs does a > > great job of letting me do the spreadsheet query without hard-coding > > the key, but obviously it must be able to get the key somehow so it > > can get the data table. > > > Wouldn't it be easy to add a method to GadgetHelper to return the > > spreadsheet query key, which could then be used in the toolbar to > > enable the toolbar functions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Visualization API" 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-visualization-api?hl=en -~----------~----~----~----~------~----~------~--~---
