Url Sheet Google - Alessandro Barazzuol

Url Sheet Google

function getHyperlinkFromCell_new() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Foglio1");
  var urls = sheet.getRange("A1:A2").getRichTextValues();
  for (var i = 0; i < urls.length; i++) {
    for (var j = 0; j < urls[i].length; j++) {
      Logger.log(urls[i][j].getLinkUrl());
    }
  }
}