php 输出excel表格

$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;

 

评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值