php(thinkphp)导出excel

1.使用 PHPExcel，上官网下载
2.将其中Classes包放入E:\nginx-1.19.6\html\server\ThinkPHP\Library\Vendor\PHPExcel-Classes
3.

public function export()
    {
        $datetime = getdate();
        $filename = $datetime['year'] . "_" . $datetime['mon'] . "_" . $datetime['mday'] . "_" . $datetime['hours'] . "_diancai_statistic.xlsx";
//        print $filename;
        $excel = new \PHPExcel();
        $db = M('statistic');
        $result = $db->query("select * from diancai.diancai_statistic order by id asc ;");
        $columns = $db->query("show columns from diancai_statistic;");
//        for ($i = 0; $i < sizeof($columns); $i++) {
//            print $columns[$i]['field'];
//        }

        $excel->setActiveSheetIndex(0);
        for ($i = 0; $i <= sizeof($columns); $i++) {
            for ($j = 0; $j < sizeof($result); $j++) {
//                print $result[$i][strtolower($columns[$j]['field'])]."\n";
                $excel->getActiveSheet()->setCellValueByColumnAndRow($j, $i, $result[$i][strtolower($columns[$j]['field'])]);
            }
        }
        $objWriter = \PHPExcel_IOFactory::createWriter($excel, "Excel5");
        $objWriter->save(iconv("utf-8", "utf-8", $filename));
        header("Content-Type: application/vmd.ms-excel");
        header("Content-Disposition: attachment;filename=$filename");
        header("Cache-Control: max-age=0;");
        $objWriter->save("php://output");
    }