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
