Accessing an Excel File on Drive

[Visar Shabi]

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]

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.