KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using SpreadsheetApp.getActiveRange().getValues(); to get the value of a range of cells, but it doesn't return the hyperlink associated with that cell, only the text. Is there any way to get the hyperlink or do I have to add another field with the url in it? Thanks. UPDATE: This is how I ended up using it to build a link list. <ul> <? var range = SpreadsheetApp.getActiveRange(); var data = range.getValues(); var links = range.getFormulas(); for(var i=1; i < data.length; i++){ if(data[i][0] !== ''){ ?> <li><a href="<?= links[i][0].split("\"")[1]; ?>"><?= data[i][0]; ?></a></li> <? } } ?> </ul>
Tags (comma-separated)
Save Edits
Cancel