phpoffice/phpspreadsheet导出

protected $is_export = false;//是否开启导出
protected $exportName = '';//导出excel名称
protected $exportField = '';//导出excel名称

public function create()
    {
        if(!$this->is_export) $this->error('未开启导出');
        $request = $this->request;
        try{
            $page = $request->post('page', 1);

            $tableName = $this->model->getTable();//获取表名
            $prefix = getenv('DB_PREFIX');//获取表前缀
            $tables = Db::select("SHOW FULL COLUMNS FROM `{$prefix}{$tableName}`");//查询表结构
            $exportField = [];
            foreach ($tables as $key=>$value){
                $exportField[] = $value->Comment?:$value->Field;//处理表结构
            }
            $page_pre = $request->post('limit')??$this->model->count();
            $data = $this->model->index( $this->filter, $page, $page_pre, $this->field, $this->order, $this->join);
            $exportName = "导出".(!empty($this->exportName)?$this->exportName:$tableName)."信息".date('Y-m-d',time());
            if(!empty($this->exportField)){
                $exportField = $this->exportField;
            }
            $path = Excel::excelExport($exportName,$exportField,$data->toArray()['data']);
            $this->back['path'] = $path;
        }catch (\Exception $e){
            $this->error($e->getMessage());
        }
        $this->success('导出成功');
    }

public static function excelExport($title="",$headArr = [], $data = [],$fileName = '') {
        $fileName       .= "_" . date("Y_m_d", time());
        $spreadsheet    = new Spreadsheet();

        $objPHPExcel    = $spreadsheet->getActiveSheet();
        $objPHPExcel->setTitle($title);
        $objPHPExcel->setCellValueByColumnAndRow(1, 1, $title);
        // 设置表头
        $key = ord("A");
        foreach ($headArr as $v) {
            $colum = chr($key);
            $objPHPExcel->setCellValue($colum . '1', $v);
            $key += 1;
        }

        $column = 2;
        foreach ($data as $key => $rows) { // 行写入
            $span = ord("A");
            foreach ($rows as $keyName => $value) { // 列写入
                $objPHPExcel->setCellValue(chr($span) . $column, $value);
                $span++;
            }
            $column++;
        }

        header('Content-Type: application/vnd.ms-excel');
        header('Content-Disposition: attachment;filename="' . $fileName . '.xlsx"');
        header('Cache-Control: max-age=0');
        $writer = new Xlsx($spreadsheet);
        $path = public_path().'/excel/'.$title.'.xls';
        $writer->save($path);
        //删除临时的sheet
        $spreadsheet->disconnectWorksheets();
        unset($spreadsheet);
        return $path;
    }