How to Export Multiple Row Headers in jQuery Datatables?
<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>