title: How to Export Multiple Row Headers in jQuery Datatables?
body: <p>Hi I am using jQuery <a href="https://datatables.net" rel="nofollow noreferrer">Datatables</a> 1.10. I am trying to export Datatable multiple header rows but not getting. But it is Exporting only second header row. I am using Buttons: </p>
  
  <pre class="lang-js prettyprint-override"><code> buttons: [{
          extend: 'excel',
          header: true
  
      }, {
          extend: 'print',
          header: true
      }],
  </code></pre>
  
  <p>My table Structure like </p>
  
  <pre class="lang-html prettyprint-override"><code>&lt;table id="example" style="color: black;" class="display compact cell-border" cellspacing="0"&gt;
      &lt;thead&gt;
          &lt;tr&gt;
              &lt;th rowspan="2"&gt;Sl.No&lt;/th&gt;
              &lt;th rowspan="2"&gt;Zone&lt;/th&gt;
              &lt;th colspan="2"&gt;Allotted&lt;/th&gt;
              &lt;th colspan="2"&gt;Vacant&lt;/th&gt;
              &lt;th colspan="2"&gt;Amenities&lt;/th&gt;
              &lt;th colspan="2"&gt;Total&lt;/th&gt;
          &lt;/tr&gt;
          &lt;tr&gt;
              &lt;th&gt;No Of Plots&lt;/th&gt;
              &lt;th&gt;Area&lt;/th&gt;
              &lt;th&gt;No Of Plots&lt;/th&gt;
              &lt;th&gt;Area&lt;/th&gt;
              &lt;th&gt;No Of Plots&lt;/th&gt;
              &lt;th&gt;Area&lt;/th&gt;
              &lt;th&gt;No Of Plots&lt;/th&gt;
              &lt;th&gt;Area&lt;/th&gt;
          &lt;/tr&gt;
      &lt;/thead&gt;
  &lt;/table&gt;                           
  </code></pre>