使用PHPExcel导出的文件不对,怎么解决?

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
            header('Content-Type: application/vnd.ms-excel');
            header('Content-Disposition: attachment;filename="01simple.xls"');
            header('Cache-Control: max-age=0');
            $objWriter->save('php://output');//保存的文件不对
            $objWriter->save("./ttt.xls");//保存的包含网页信息

img

img

可以参考一下


    /**
     * 导出
     */
    public function exportExcel()
    {

        $data = input('data', '', 'trim,strip_tags');

        $dataArr = json_decode($data, true);

        if (empty($dataArr)) {
            $this->error('没有数据可以导出');
        }

        $PHPExcel = new \PHPExcel(); //实例化PHPExcel类,类似于在桌面上新建一个Excel表格
        $PHPSheet = $PHPExcel->getActiveSheet(); //获得当前活动sheet的操作对象
        $PHPSheet->setTitle('导出潜客管理数据'); //给当前活动sheet设置名称

        //表头
        //给当前活动sheet填充数据,数据填充是按顺序一行一行填充的,假如想给A1留空,可以直接setCellValue(‘A1’,’’);
        $PHPSheet->setCellValue('A1', 'ID')
            ->setCellValue('B1', '线索名称')
            ->setCellValue('C1', '意向标签')
            ->setCellValue('D1', '联系人')
            ->setCellValue('E1', '联系方式')
            ->setCellValue('F1', '线索来源')
            ->setCellValue('G1', '跟进阶段')
            ->setCellValue('H1', '负责人')
            ->setCellValue('I1', '负责部门')
            ->setCellValue('J1', '最后跟进时间');

        foreach ($dataArr as $k1 => $v1) {
            $cell = $k1 + 2;
            $PHPSheet->setCellValue('A' . $cell, $v1['id'])
                ->setCellValue('B' . $cell, $v1['customer_name'])
                ->setCellValue('C' . $cell, $v1['intention_label'])
                ->setCellValue('D' . $cell, $v1['contacts'])
                ->setCellValue('E' . $cell, $v1['contact_us'])
                ->setCellValue('F' . $cell, $v1['clue_source'])
                ->setCellValue('G' . $cell, $v1['follow_stage'])
                ->setCellValue('H' . $cell, $v1['person_charge'])
                ->setCellValue('I' . $cell, $v1['person_department'])
                ->setCellValue('J' . $cell, $v1['last_follow_time']);
        }

        $time = date("Ymd");
        $execlpath = './uploads/potenTableExcel/' . $time . '/';

        if (!file_exists($execlpath)) {
            mkdir($execlpath);
        }

        $execlpath .= rand_string(12, '', time()) . 'excel.xls';

        $PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, 'Excel2007'); //按照指定格式生成Excel文件,‘Excel2007’表示生成2007版本的xlsx

        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=11111.xlsx');

        $PHPWriter->save($execlpath);

        $this->success('导出成功,请到任务列表下载');
    }