Adding a new sheet to a Google Spreadsheet via the Google Docs or Spreadsheet API
I'm working on a project where I'm pulling a bunch of information out of a Drupal MySQL database and put开发者_JS百科ting it in a Google Spreadsheet. My problem is that its a lot of data, and I'd prefer to put it all in one spreadsheet, sorting everything by sheet.
I'm not seeing anyway to add a sheet to a spreadsheet nor navigate between existing sheets. Anyone have any idea how to do this? I'd like to this in PHP, and if that doesn't work, Python.
Thanks for your help,
--Scott
This may help http://code.google.com/apis/spreadsheets/data/3.0/developers_guide.html#CreatingWorksheets
It's for Protocol/Java though.
Here you go: https://developers.google.com/apps-script/class_spreadsheet#insertSheet
I guess, you first stumbled along a very similar URL: https://developers.google.com/apps-script/class_spreadsheetapp#create
精彩评论