Unable to retrieve single value from array of values
I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:
function CoverageCalculator() {
var sheet = SpreadsheetApp.getActiveSheet();
var searchRange = sheet.getRange('D3:D20')
var rangeValues = searchRange.getValues();
var Test = searchRange[1][1];
}
In debug mode, "Test" is undefined, any ideas on why this might be the case?
google-apps-script google-sheets edited Nov 22 at 19:01
Rubén
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
add a comment |
I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:
function CoverageCalculator() {
var sheet = SpreadsheetApp.getActiveSheet();
var searchRange = sheet.getRange('D3:D20')
var rangeValues = searchRange.getValues();
var Test = searchRange[1][1];
}
In debug mode, "Test" is undefined, any ideas on why this might be the case?
google-apps-script google-sheets edited Nov 22 at 19:01
Rubén
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
2
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47
add a comment |
I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:
function CoverageCalculator() {
var sheet = SpreadsheetApp.getActiveSheet();
var searchRange = sheet.getRange('D3:D20')
var rangeValues = searchRange.getValues();
var Test = searchRange[1][1];
}
In debug mode, "Test" is undefined, any ideas on why this might be the case?
google-apps-script google-sheets edited Nov 22 at 19:01
Rubén
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
I'm trying to retrieve a value to do a String comparison test and I can't seem to retrieve the single value from an array of values. Here's my code:
function CoverageCalculator() {
var sheet = SpreadsheetApp.getActiveSheet();
var searchRange = sheet.getRange('D3:D20')
var rangeValues = searchRange.getValues();
var Test = searchRange[1][1];
}
In debug mode, "Test" is undefined, any ideas on why this might be the case?
google-apps-script google-sheets google-apps-script google-sheets edited Nov 22 at 19:01
Rubén
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
edited Nov 22 at 19:01
Rubén
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
edited Nov 22 at 19:01
Rubén
10.1k43265
edited Nov 22 at 19:01
Rubén
10.1k43265
edited Nov 22 at 19:01
Rubén
10.1k43265
10.1k43265
asked Nov 22 at 16:20
Nicholas Besse
31
asked Nov 22 at 16:20
Nicholas Besse
31
asked Nov 22 at 16:20
Nicholas Besse
31
31
2
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47
add a comment |
2
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47
2
2
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47
add a comment |
1 Answer
1
active
oldest
votes
Change
var Test = searchRange[1][1];
to
var Test = rangeValues[1][0];
The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.
answered Nov 22 at 19:03
Rubén
10.1k43265
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434918%2funable-to-retrieve-single-value-from-array-of-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Change
var Test = searchRange[1][1];
to
var Test = rangeValues[1][0];
The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.
answered Nov 22 at 19:03
Rubén
10.1k43265
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
add a comment |
Change
var Test = searchRange[1][1];
to
var Test = rangeValues[1][0];
The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.
answered Nov 22 at 19:03
Rubén
10.1k43265
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
add a comment |
Change
var Test = searchRange[1][1];
to
var Test = rangeValues[1][0];
The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.
answered Nov 22 at 19:03
Rubén
10.1k43265
Change
var Test = searchRange[1][1];
to
var Test = rangeValues[1][0];
The above because searchRange is a Range object, not an array, but rangeValues it's. Regarding the indexes, the first one determines the row, and the second the column and considering that the source range is D3:D20 the resulting array has 17 rows high and 1 column width, then the maximum valid index for the second index is 0.
answered Nov 22 at 19:03
Rubén
10.1k43265
edited Nov 22 at 21:34
answered Nov 22 at 19:03
Rubén
10.1k43265
answered Nov 22 at 19:03
Rubén
10.1k43265
answered Nov 22 at 19:03
Rubén
10.1k43265
10.1k43265
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
add a comment |
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Ah, yes. Typo on my part, though rangValues still returns an undefined
– Nicholas Besse
Nov 22 at 20:50
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
Since it's an array of width 1 (I think that's the right terminology?) ie, a column vector, I just need to declare an element, not a [row][column] So, var Test = rangeValues[1]; works Thank you!
– Nicholas Besse
Nov 22 at 20:52
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
@NicholasBesse I updated my answer.
– Rubén
Nov 22 at 21:34
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53434918%2funable-to-retrieve-single-value-from-array-of-values%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Shouldn't it be rangeValues[1][1]?
– TheWizEd
Nov 22 at 17:47