Hi, David is correct, the API doesn't support inserting gadgets. We currently don't have plans for exposing such a feature, but feel free to file a feature request.
Thanks, -Vic On Mon, Jan 3, 2011 at 4:56 PM, David Bullock <[email protected]> wrote: > On Jan 4, 7:53 am, Denis Haskin <[email protected]> wrote: > > I'd like to automate adding and configuring a gadget within a > spreadsheet, > > and it's unclear to me whether this is possible or not. > > I don't think you're in luck. The Spreadsheets API is a bunch of ATOM/ > REST 'feeds' which deal with concepts such as spreadsheets, worsheets, > rows, cells, etc. There's no elements on worksheet-feed entries which > relate to gadgets attached to the sheet. > > There's nothing for you in the Scripts API either > http://code.google.com/googleapps/appsscript/class_sheet.html > > Your best bet will be to file a request for enhancement, but it might > be best handled by the Gadgets team rather than the Spreadsheets Data > API team. I'm sure that there is a need for scriptable installation > of Gadgets generally, and it would seem useful if there was an API > dedicated to this which crossed all Google Apps document types. > > cheers, > David. > > > > > > Specifically, I've got automation which sets up a spreadsheet with > correct > > data to be used with viewpath's Gantt chart gadget. What I'd like to be > > able to do is programmatically also insert the gantt chart gadget, and > > possibly also configure it (although it may be that I can set up my data > > such that the gadget will work without further configuration). > > > > Thoughts? Suggestions? > > > > Thanks, > > > > dwh >
