New to Kendo UI for jQuery? Start a free 30-day trial

Sheets.hyperlinks

configuration

Specify a collection of hyperlinks that will be applied to the corresponding cells. You can set only one link per cell.

sheets.hyperlinks

Array

<script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [
      {
        hyperlinks: [{ref: "A1", target: "https://google.com"}, {ref: "A2", target: "https://youtube.com"}],
        rows: [
          { cells: [ { value: "Google" } ] },
          { cells: [ { value: "Youtube" } ] }
        ]
      }
    ]
  });

  workbook.toDataURLAsync().then(dataURI => {
    kendo.saveAs({
      dataURI,
      fileName: "Test.xlsx"
    });
  });
</script>

sheets.hyperlinks.ref

String

The cell to which the link must be applied. Examples - "A1", "A2", "B3", "AA2", "BA2", "C5".

<script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [
      {
        hyperlinks: [{ref: "A1", target: "https://google.com"}, {ref: "A2", target: "https://youtube.com"}],
        rows: [
          { cells: [ { value: "Google" } ] },
          { cells: [ { value: "Youtube" } ] }
        ]
      }
    ]
  });

  workbook.toDataURLAsync().then(dataURI => {
    kendo.saveAs({
      dataURI,
      fileName: "Test.xlsx"
    });
  });
</script>

sheets.hyperlinks.target

String

The target link that will be opened when the cell is clicked.

<script>
  var workbook = new kendo.ooxml.Workbook({
    sheets: [
      {
        hyperlinks: [{ref: "A1", target: "https://google.com"}, {ref: "A2", target: "https://youtube.com"}],
        rows: [
          { cells: [ { value: "Google" } ] },
          { cells: [ { value: "Youtube" } ] }
        ]
      }
    ]
  });

  workbook.toDataURLAsync().then(dataURI => {
    kendo.saveAs({
      dataURI,
      fileName: "Test.xlsx"
    });
  });
</script>