Apps Script: how to get hyperlink from a cell where there is no formula

by

When a cell has only one URL, you can retrieve the URL from the cell using the following simple script.

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1");
var url = sheet.getRange("A2").getRichTextValue().getLinkUrl(); //removed empty parentheses after getRange in line 2

Source: https://gist.github.com/tanaikech/d39b4b5ccc5a1d50f5b8b75febd807a6

More Related Contents:

  1. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  2. Is there a way to evaluate a formula that is stored in a cell?
  3. No permission to call msgBox in Google Apps Scripting
  4. Periodically refresh IMPORTXML() spreadsheet function
  5. Selecting the last value of a column
  6. Using built-in spreadsheet functions in a script
  7. Google Sheet use Importxml error could not fetch url [duplicate]
  8. Google Spreadheets Scripts: check if cell is empty
  9. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  10. How to create INDIRECT array string of multiple sheet references in Google Sheets?
  11. Is it possible to ‘prefill’ a google form using data from a google spreadsheet?
  12. How to protect the Apps Script code in a Google spreadsheet?
  13. Automatic timestamp when a cell is filled out
  14. How to auto select range from a filter without having to manually enter it?
  15. Script to Change Row Color when a cell changes text
  16. Sheet.getRange(1,1,1,12) what does the numbers in bracket specify?
  17. How to get onFormSubmit to trigger automatically?
  18. Copying a spreadsheet copies all linked files as well
  19. copy data from one sheet to another in google app script and append a row, one small issue
  20. Google App Scripts cannot be given Authorization or Permission
  21. How to get the correct range to set the value to a cell?
  22. Refresh data retrieved by a custom function in Google Sheet
  23. How to extract the link from a cell now that links are not reflected as HYPERLINK?
  24. Dynamically creating spreadsheet menu items
  25. Increment Cell value by one by clicking
  26. email notification if cell is changed
  27. Dynamic selection options in Google Apps Script for forms
  28. Determine current user in Apps Script
  29. Google spreadsheet “Cannot call method “getRange” of null”
  30. Is it possible to create macro buttons to navigate in Google Sheets?

Leave a Comment