title: Node - Parse excel files with merged cells
body: <p>I have to parse a variety of excel files, some of which are a complete wreck (and I have no control over the format as they are supplied externally). Some of these also have multiple sheets.</p>
  
  <p>For standard files with rows of data I have used xlsx-to-json successfully, but for the others I have no solution so far, here is an common example.</p>
  
  <pre><code>----------------------------------------------------------
  |              |____normal___|____normal___|____normal___|
  |    merged    |____normal___|____normal___|____normal___|
  |              |____normal___|____normal___|____normal___|
  ----------------------------------------------------------
  </code></pre>
  
  <p>I have no clue how to even begin working on this thing, please advise, I'm sure SOMEONE has run into this.</p>