Export Multiple Header row

waqarjan333

<thead>
<tr style="background-color: #3c8dbc; color: #FFFFFF; font-weight: bold; text-align: center;">
<th style=" text-align: center;" width="10%">Department</th>
<th style=" text-align: center;" width="5%" colspan="2">MM</th>
<th style=" text-align: center;" width="5%" colspan="2">MF</th>
<th style=" text-align: center;" width="10%" colspan="2">Morning</th>
<th style=" text-align: center;" width="5%" colspan="2">EM</th>
<th style=" text-align: center;" width="5%" colspan="2">EF</th>
<th style=" text-align: center;" width="10%" colspan="2">Evening</th>
<th style=" text-align: center;" width="5%" colspan="2">NM</th>
<th style=" text-align: center;" width="5%" colspan="2">NF</th>
<th style=" text-align: center;" width="10%" colspan="2">Night</th>
<th style=" text-align: center;" width="10%" colspan="2">Male</th>
<th style=" text-align: center;" width="10%" colspan="2">Female</th>
<th style=" text-align: center;" width="10%" colspan="2">Total</th>
</tr>
<tr style="background-color: #3c8dbc; color: #FFFFFF; font-weight: bold; text-align: center;">
<th>Department</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
<th>Count</th>
<th>Amount</th>
</tr>
</thead>

colin

This thread should help, it's asking the same thing.

Cheers,

Colin