Excel导出

//设置header头文件
        header("content-type:text/html;charset=utf-8");
        //设置文件大小的限制
        ini_set("memory_limit",'1024M');
        //引入类文件
        Loader::import("PHPExcel.Classes.PHPExcel");
        //实例化文文件
        $obj = new \PHPExcel();
        //打开excel,获取当前展示出来的页面
        $sheet = $obj->getActiveSheet();

        //查询数据库
        $data = Db::table("day7")->select();
        //赋值表格(sheet重命名标题)
        $sheet->setTitle("测试导出");
        //给单元格赋值
        $sheet->setCellValue("A1","ID")
            ->setCellValue("B1","导航名称")
            ->setCellValue("C1","导航链接");

        //开始位置从第二行开始
        $j = 2;
        foreach($data as $k=>$v){
            $sheet->setCellValue("A".$j,$v['id'])
                ->setCellValue("B".$j,$v['file_name'])
                ->setCellValue("C".$j,$v['path']);
            $j++;
        }
        //导出
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment;filename="01simple.xlsx"');
        header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
        header('Cache-Control: max-age=1');

// If you're serving to IE over SSL, then the following may be needed
        header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
        header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified
        header ('Cache-Control: cache, must-revalidate'); // HTTP/1.1
        header ('Pragma: public'); // HTTP/1.0

        $objWriter = \PHPExcel_IOFactory::createWriter($obj, 'Excel2007');
        $objWriter->save('php://output');