php 使用phpexcel实现数据导出

先做一个简单的数据的导入导出，明天将图片打包下载，oss移动文件，和数据导出完善，

namespace app\admin\controller;

use think\Controller;
use think\Request;
use PHPExcel;
use PHPExcel_IOFactory;

class Demo extends Controller
{
    public function  index()
    {
        # sql查询
        $data = \app\admin\model\Area::select()->toArray();

        $title = '地区表';

        // 随机生成的文件名
        $fileName = $title . '(' . date("Y-m-d", time()) . '）' . '.xls';

        # 引入phpexcel类文件
        vendor("PHPExcel.PHPExcel.PHPExcel");
        vendor("PHPExcel.PHPExcel.IOFactory");

        //加载第三方类库
        //实例化excel类
        $excelObj = new PHPExcel;

        //构建列数--根据实际需要构建即可
        $letter = array('A', 'B', 'C', 'D');
        //表头数组--需和列数一致
        $tableheader = array('城市id', '城市姓名', '父id', '级别');

        # 设置表头
        for($i = 0;$i < count($tableheader);$i++) {
            $excelObj->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
        }

        # 传递数据
        for ($i = 2;$i <= count($data) + 1;$i++) {
            $j = 0;
            foreach ($data[$i - 2] as $key=>$value) {
                $excelObj->getActiveSheet()->setCellValue("$letter[$j]$i","$value");
                $j++;
            }
        }

        $write = new \PHPExcel_Writer_Excel5($excelObj);
        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=".$fileName);
        header("Content-Transfer-Encoding:binary");
        $write->save('php://output');
        die;
    }
}