title: Get merged cell value in every JSON object
body: <p>I have an excel file that looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/xLRSV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xLRSV.png" alt="enter image description here"></a></p>
  
  <p>As you can see, there are some merged cells. I've been using js-xlsx to convert the data to JSON objects in my application. Here is the code:</p>
  
  <pre><code>onFileLoad(loadedEvent: any) {
      let data = new Uint8Array(loadedEvent.target.result);
      let arr: Array&lt;string&gt; = new Array();
      for (let i = 0; i != data.length; i++) arr[i] = String.fromCharCode(data[i]);
      let bstr = arr.join("");
      let wb: XLSX.IWorkBook = XLSX.read(bstr, { type: "binary" });
      let workSheet = wb.Sheets[wb.SheetNames[0]];
      let jsonData = XLSX.utils.sheet_to_json(workSheet, {raw: true });
      console.log(jsonData);
  }
  </code></pre>
  
  <p>The code works fine for the row where it says "40", but at "41" the JSON object does not contain the fields from the merged cells. You can see that here:</p>
  
  <p><a href="https://i.stack.imgur.com/KaGAE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KaGAE.png" alt="enter image description here"></a></p>
  
  <p>Is there any way to make the  values from the merged cells be in every JSON object?</p>