SpreadsheetApp.open(file) Not Found

[Russell Savage]

Hi, I am trying to call SpreadsheetApp.open(File file) in my script but I keep getting:

Cannot find method open(File).

The function shows up in the autocomplete list but I don't think it is available for scripts. Is that on purpose?

Thanks,

Russ

[Anash Oommen]

Hi Russell,

Could you post a code snippet please? I could investigate this further.

Cheers,
Anash P. Oommen,
AdWords Scripts Team

[Russell Savage]

Sure, here is an example that causes the error.  I should be able to call open on SpreadsheetApp with the File as documented here but it throws an error:

https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet-app#open(File)

function main() {

  var fileName = 'SpreadsheetTestFile2014-02-26';

  SpreadsheetApp.create(fileName);

  var file = DriveApp.getFilesByName(fileName).next();

  SpreadsheetApp.open(file);

}

[Anash Oommen]

Hi Russell,

I've opened an issue to investigate this further. Thanks for reporting the issue, I'll keep you updated.

Cheers,
Anash P. Oommen,
AdWords Scripts Team

[Marcelo Iturbe]

Hi,

Any update on this? is there a bug in the tracker to follow?

[Anash Oommen]

Hi Russell, Marcelo,

I sort of tracked this down, the issue is that the File object being referred to is from the Document List API, and it is not compatible with Drive and Spreadsheet APIs. I've asked the team to remove the incompatible method, and you should use the "open with url" version instead.

Cheers,
Anash