title: SheetJS js-xlsx - Add hyperlink formula in cell range
body: <p>I am unable to decrypt <a href="https://www.npmjs.com/package/xlsx" rel="nofollow noreferrer">the documentation</a>...</p>
  
  <p>The goal is to create a link formula in <strong>each</strong> cell based on another cell.</p>
  
  <pre class="lang-js prettyprint-override"><code>let wb = XLSX.utils.book_new();
  wb.Props = {
      Title: `export`,
      Subject: "export",
  };
  
  let ws_data = [
      [
          "sku",
          "product",
          "picture"
      ]
  ];
  
  products.map(item =&gt; {
      ws_data.push([
          item.sku,
          item.product,
          `=HYPERLINK("/pics/"&amp;${item.sku}&amp;".jpg";"link")`,
      ])
  })
  
  wb.SheetNames.push("data");
  let ws = XLSX.utils.aoa_to_sheet(ws_data);
  wb.Sheets["data"] = ws;
  let wbout = XLSX.write(wb, { bookType: 'xlsx', type: 'binary' });
  
  saveByteArray([convertBinaryToOctetStream(wbout)], `export.xlsx`);
  </code></pre>
  
  <p>Obviously, this simply puts the <code>=HYPERLINK("/pics/all/"&amp;sku&amp;".jpg";"link")</code> text in the cell. How can it be the actual formula?</p>