$resultData = [];
$table = '';
$table .= "<table>
<thead>
<tr>
<th class='name'>类别</th>
<th class='name'>班级</th>
<th class='name'>语文</th>
<th class='name'>英语</th>
<th class='name'>数学</th>
<th class='name'>物理</th>
<th class='name'>化学</th>
<th class='name'>生物</th>
<th class='name'>政治</th>
<th class='name'>地理</th>
<th class='name'>历史</th>
<th class='name'>通用技术</th>
</tr>
</thead>
<tbody>";
foreach ($resultData as $v) {
$table .= "<tr>
<td class='name'>{$v['class_type']}</td>
<td class='name'>{$v['class_num']}</td>";
$table .= isset($v['1']) ? "<td class='name'>{$v['1']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['2']) ? "<td class='name'>{$v['2']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['3']) ? "<td class='name'>{$v['3']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['4']) ? "<td class='name'>{$v['4']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['5']) ? "<td class='name'>{$v['5']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['6']) ? "<td class='name'>{$v['6']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['7']) ? "<td class='name'>{$v['7']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['8']) ? "<td class='name'>{$v['8']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['9']) ? "<td class='name'>{$v['9']}</td>" : "<td class='name'> - </td>";
$table .= isset($v['10']) ? "<td class='name'>{$v['10']}</td>" : "<td class='name'> - </td>";
$table .= "</tr>";
}
$table .= "</tbody>
</table>";
//通过header头控制输出excel表格
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename="高二批改数量表.xls"');
header("Content-Transfer-Encoding:binary");
echo $table;