Apps Script - count rows in variable range
With Apps Script, I need to copy a section of a sheet to another area, with the start and end cells of the range based on variable inputs. Is there any built in function to count the number of rows in this variable-sized range?
I've searched all over and can't find any way to get this seemingly simple info for a defined range.
google-apps-script google-sheets
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
add a comment |
With Apps Script, I need to copy a section of a sheet to another area, with the start and end cells of the range based on variable inputs. Is there any built in function to count the number of rows in this variable-sized range?
I've searched all over and can't find any way to get this seemingly simple info for a defined range.
google-apps-script google-sheets
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
add a comment |
With Apps Script, I need to copy a section of a sheet to another area, with the start and end cells of the range based on variable inputs. Is there any built in function to count the number of rows in this variable-sized range?
I've searched all over and can't find any way to get this seemingly simple info for a defined range.
google-apps-script google-sheets
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
With Apps Script, I need to copy a section of a sheet to another area, with the start and end cells of the range based on variable inputs. Is there any built in function to count the number of rows in this variable-sized range?
I've searched all over and can't find any way to get this seemingly simple info for a defined range.
google-apps-script google-sheets
google-apps-script google-sheets
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
asked Nov 22 '18 at 21:53
Charles JohnsonCharles Johnson
109211
109211
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
.getValues() on a Range object returns a regular javascript array of arrays, which you can measure with .length.
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
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%2f53438371%2fapps-script-count-rows-in-variable-range%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
.getValues() on a Range object returns a regular javascript array of arrays, which you can measure with .length.
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
add a comment |
.getValues() on a Range object returns a regular javascript array of arrays, which you can measure with .length.
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
add a comment |
.getValues() on a Range object returns a regular javascript array of arrays, which you can measure with .length.
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
.getValues() on a Range object returns a regular javascript array of arrays, which you can measure with .length.
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
answered Nov 22 '18 at 21:57
cladelpinocladelpino
1159
1159
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
add a comment |
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
Thanks! So simple I'm embarrassed I didn't see it.
– Charles Johnson
Nov 22 '18 at 22:12
I've been there too
– cladelpino
Nov 22 '18 at 22:16
I've been there too
– cladelpino
Nov 22 '18 at 22:16
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.
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%2f53438371%2fapps-script-count-rows-in-variable-range%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
