title: get computed value of excel sheet cell in Node.js
body: <p>I'm using node.js to process my excel sheets with <a href="https://www.npmjs.com/package/exceljs" rel="nofollow noreferrer">exceljs</a> module. </p>
  
  <p>I'm writing values into few cells and other cells are already containing formulas. I want to trigger those formulas and want to store values in sheet programatically.</p>
  
  <p>For E.g. I have below sheet structure:
  <a href="https://i.stack.imgur.com/nWi0w.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nWi0w.png" alt="enter image description here"></a></p>
  
  <p>I'hv written below code to insert values in cells A1 and B1.</p>
  
  <pre><code>var workbook = new Excel.Workbook();
  workbook.xlsx.readFile(__base + 'test.xlsx')
    .then(function() {
      var worksheet = workbook.getWorksheet(2);
      var row = worksheet.getRow(1);
      row.getCell(1).value = 2; // A1's value set to 2
      row.getCell(2).value = 8; // B1's value set to 8
    };
    row.commit();
    workbook.xlsx.writeFile(__base + 'test.xlsx');                            
  });
  </code></pre>
  
  <p>When I'm trying to fetch value of c1 then its returning me formula with result 0. Below is the code to fetch values.</p>
  
  <pre><code>workbook.xlsx.readFile(__base + 'test.xlsx')
      .then(function() {
      var worksheet = workbook.getWorksheet(2);
      var row = worksheet.getRow(1);
      console.log(row.getCell(1).value);
      console.log(row.getCell(2).value);
      console.log(row.getCell(3).value);
  });
  </code></pre>
  
  <p>OUTPUT:</p>
  
  <p><a href="https://i.stack.imgur.com/NcjMe.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NcjMe.png" alt="enter image description here"></a></p>
  
  <p><strong>How to get computed values or how to trigger computation in excel programatically and to store it in cell?</strong></p>
  
  <p>Output result of cell C1 should be 10 in console i.e. A1+B1 (2+8).</p>