Office Script: Add Hyperlink to a column within an Excel Table

Thanks SergeiBaklan yes, it works for url as literal, but not when the value is taken from a named range. It indicated some error, but changing:

const v = cell.getValue()

by

const v = cell.getValue().toString()

it works. Here is the updated formula:

function main(workbook: ExcelScript.Workbook) {

  const tableName = "TB_TEST"
  //const url = "https://MYSITE.atlassian.net/browse/"
  const url = workbook.getNamedItem("jiraSiteIssue").getValue().toString()
  console.log(`url: '${url}'`)
  const keyColumn = workbook
    .getTable(tableName)
    .getColumn(1)
    .getRangeBetweenHeaderAndTotal()
  const rows = keyColumn.getRowCount()
  for (let i = 0; i < rows; i++) {
    const cell = keyColumn.getCell(i, 0);
    const v = cell.getValue().toString();
    const hyperlink: ExcelScript.RangeHyperlink = {
      address: url + v,
      screenTip: url + v,
      textToDisplay: v
    };
    cell.setHyperlink(hyperlink);
  }
}

it indicates a performance warning in line 14, I was trying to use a variant as in your other example, but I couldn't make it works. Under this approach the warning can be removing getting the values first.

Update: I found the way to get the value of the named range, it should be like this:

const url = workbook.getNamedItem("jiraSiteIssue").getRange().getValue()

Here it the final script:

function main(workbook: ExcelScript.Workbook) {
  const tableName = "TB_TEST"
  //const url = "https://MYSITE.atlassian.net/browse/"
  const url = workbook.getNamedItem("jiraSiteIssue").getRange().getValue()
  console.log(`url: '${url}'`)
  const keyColumn = workbook
    .getTable(tableName)
    .getColumn(1)
    .getRangeBetweenHeaderAndTotal()
  const rows = keyColumn.getRowCount()
  const values = keyColumn.getValues()
  for (let i = 0; i < rows; i++) {
    const cell = keyColumn.getCell(i, 0)
    const v = values[i][0].toString();
    const hyperlink: ExcelScript.RangeHyperlink = {
      address: url + v,
      screenTip: url + v,
      textToDisplay: v
    }
    cell.setHyperlink(hyperlink)
  }
}

Yes it works when there are empty cells.

Thanks again,

David