How I can make URL link to sheet in google spreadsheet?

Multi tool use
Multi tool use












0















I made sheet name list from a file and got their URL.
I used hyperlink() to make these link to each sheet.
But it doesn't work. Pleas tell me what's wrong.



!Please see the image file that I attached.
It showed this when I put the function I made at cell A1.
enter image description here



Here's code that I wrote in script editor.



function sheetNames2() {
var out = new Array()
var url = "=hyperlink("https://docs.google.com/spreadsheets/d/1W7L9DDo_w7lNk-AE05_ghi5y8LmaAJT2EGG-yfs3gQI/edit#gid="
var urls = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++)
urls.push(url + sheets[i].getSheetId() + ""," + """+ sheets[i].getName()+ """ + ")")
return urls
}









share|improve this question

























  • Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

    – Nathan
    Jan 1 at 5:01











  • Check out this answer here: webapps.stackexchange.com/a/108080

    – s1c0j1
    Jan 1 at 9:19
















0















I made sheet name list from a file and got their URL.
I used hyperlink() to make these link to each sheet.
But it doesn't work. Pleas tell me what's wrong.



!Please see the image file that I attached.
It showed this when I put the function I made at cell A1.
enter image description here



Here's code that I wrote in script editor.



function sheetNames2() {
var out = new Array()
var url = "=hyperlink("https://docs.google.com/spreadsheets/d/1W7L9DDo_w7lNk-AE05_ghi5y8LmaAJT2EGG-yfs3gQI/edit#gid="
var urls = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++)
urls.push(url + sheets[i].getSheetId() + ""," + """+ sheets[i].getName()+ """ + ")")
return urls
}









share|improve this question

























  • Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

    – Nathan
    Jan 1 at 5:01











  • Check out this answer here: webapps.stackexchange.com/a/108080

    – s1c0j1
    Jan 1 at 9:19














0












0








0








I made sheet name list from a file and got their URL.
I used hyperlink() to make these link to each sheet.
But it doesn't work. Pleas tell me what's wrong.



!Please see the image file that I attached.
It showed this when I put the function I made at cell A1.
enter image description here



Here's code that I wrote in script editor.



function sheetNames2() {
var out = new Array()
var url = "=hyperlink("https://docs.google.com/spreadsheets/d/1W7L9DDo_w7lNk-AE05_ghi5y8LmaAJT2EGG-yfs3gQI/edit#gid="
var urls = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++)
urls.push(url + sheets[i].getSheetId() + ""," + """+ sheets[i].getName()+ """ + ")")
return urls
}









share|improve this question
















I made sheet name list from a file and got their URL.
I used hyperlink() to make these link to each sheet.
But it doesn't work. Pleas tell me what's wrong.



!Please see the image file that I attached.
It showed this when I put the function I made at cell A1.
enter image description here



Here's code that I wrote in script editor.



function sheetNames2() {
var out = new Array()
var url = "=hyperlink("https://docs.google.com/spreadsheets/d/1W7L9DDo_w7lNk-AE05_ghi5y8LmaAJT2EGG-yfs3gQI/edit#gid="
var urls = new Array()
var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
for (var i=0 ; i<sheets.length ; i++)
urls.push(url + sheets[i].getSheetId() + ""," + """+ sheets[i].getName()+ """ + ")")
return urls
}






api url google-sheets spreadsheet






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Jan 1 at 5:43







EGene

















asked Jan 1 at 4:41









EGeneEGene

164




164













  • Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

    – Nathan
    Jan 1 at 5:01











  • Check out this answer here: webapps.stackexchange.com/a/108080

    – s1c0j1
    Jan 1 at 9:19



















  • Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

    – Nathan
    Jan 1 at 5:01











  • Check out this answer here: webapps.stackexchange.com/a/108080

    – s1c0j1
    Jan 1 at 9:19

















Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

– Nathan
Jan 1 at 5:01





Where's the code that actually inserts these to the sheet? We just see you returning an array in a function.

– Nathan
Jan 1 at 5:01













Check out this answer here: webapps.stackexchange.com/a/108080

– s1c0j1
Jan 1 at 9:19





Check out this answer here: webapps.stackexchange.com/a/108080

– s1c0j1
Jan 1 at 9:19












0






active

oldest

votes











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
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53993048%2fhow-i-can-make-url-link-to-sheet-in-google-spreadsheet%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































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.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53993048%2fhow-i-can-make-url-link-to-sheet-in-google-spreadsheet%23new-answer', 'question_page');
}
);

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







a,c4EyGyS,OuS4Xxk
oFyLR4G9AaGQ KujquSnP,epVP08ym

Popular posts from this blog

Monofisismo

Angular Downloading a file using contenturl with Basic Authentication

Olmecas