CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheets
086
086

Reputation: 317

Google Script Spreadsheet range returns unidentified

Basically, Im getting a spreadsheet from my drive and trying to read a range. Logging its name works perfectly, Logging any information like sheet-names etc works fine, But when i try to do getRange("A1") or getDataRange() on a sheet, it returns unidentified. Im 100% sure the given range(es) have data in them, its like the script cant find it, or has no acces to it.

Please help. Thanks. (If someone wants code to look at, just ask.)

Upvotes: 0

Views: 143

Answers (1)

Alan Wells
Alan Wells

Reputation: 31300

The UiApp Class is now deprecated as of December 11, 2014. Existing scripts should still function through June 30, 2015.

Google Sunset Schedule

This may not be the problem with your code, but I'm guessing that sooner or later you'll need to change that code.

When I try to run the myClickHandler() function, I get an error on this line:

if(e.parameter["foldertextbox"] != ""){

The error states:

Cannot Read Property

The code dies at that point. When I VIEW the EXECUTION TRANSCRIPT, the last line is this error:

Execution failed: TypeError: Cannot read property "parameter" from undefined. (line XXX, file "Code") [0.465 seconds total runtime]

So, I'm guessing there is something wrong with that line of code. It looks like you are trying to get the value out of the text box named foldertextbox with an e event object property, but there seems to be something wrong with the syntax. I can't find any documentation that supports e.parameter["text box name"]

Upvotes: 0

Related Questions