How to fix "Exception: Unexpected error while getting the method or property open on object SpreadsheetApp"?

Question

I have only pasted a part of the code which I am trying to run separately.

function myFunction() {
   var files = DriveApp.searchFiles('title contains "Companies_OHLC_0"');
   while (files.hasNext()) {
        var spreadsheet = SpreadsheetApp.open(files.next());
    }
 }

it was working sometime back but I keep getting this exception now:

Exception: Unexpected error while getting the method or property open on object SpreadsheetApp. (line 4, file "Code").

I have tried OpenByID() and OpenByurl(), still no luck

P Suriya
– P Suriya

2020-07-18 03:39:39 +00:00
Commented Jul 18, 2020 at 3:39 — P Suriya
– P Suriya, Commented Jul 18, 2020 at 3:39

P Suriya · Accepted Answer · 2020-07-18 04:06:42Z

3

I figured it out. I had multiple files with the same name and hence, i was getting that exception.

I had run other scripts which had created new files with the same names.I had not noticied this. I deleted all the duplciate files and I am not getting this exception any more.

answered Jul 18, 2020 at 4:06

P Suriya

411 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to fix "Exception: Unexpected error while getting the method or property open on object SpreadsheetApp"?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related