Accessing an Excel File on Drive

45 views
Skip to first unread message

Visar Shabi

unread,
Dec 16, 2013, 6:41:57 AM12/16/13
to adwords...@googlegroups.com
Hi, 

I've uploaded an .xlsx file onto Google Drive, however I'm unable to open it by calling SpreadsheetApp.openById(Id); or SpreadsheetApp.openByUrl(url);. If on Drive I select "Open With Google Docs" it creates a Google doc which can be opened. Is there a way to either automate the creation of the google doc, or a way to open an xsl file using the SpreadsheetApp?

Thanks

Anash Oommen

unread,
Dec 17, 2013, 9:46:00 AM12/17/13
to adwords...@googlegroups.com
Hi Visar,

You could use SpreadsheetApp.create to create a new Google Spreadsheet. See https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#create(String) for an example.

Cheers,
Anash P. Oommen,
AdWords Scripts Team.
Reply all
Reply to author
Forward
0 new messages