fastadmin导出excel,去除标签

public function explo(){
    $obj = new \PHPExcel();
    $q =查询需要到出的数据;
    $data= [];
    foreach($q as $k=>$v){
        $data[$k]['category']=$v->category->name;
        $question=str_replace(' ','',$v->question);
        $question=trim(strip_tags($question));
        $question=htmlspecialchars($question);
        $data[$k]['title']=$question;
        $data[$k]['answer']=$v->answer;

        $reference=str_replace(' ','',$v->reference);
        $reference=trim(strip_tags($reference));
        $reference=htmlspecialchars($reference);
        $data[$k]['reference']=$reference;

        $level=str_replace(' ','',$v->difficult->name);
        $level=trim(strip_tags($level));
        $level=htmlspecialchars($level);

        $data[$k]['level']=$level;

        foreach ($v->options as $kk=>$vv){
            $options=str_replace(' ','',$vv->content);
            $options=str_replace('"','',$options);
            $options=trim(strip_tags($options));
            $options=htmlspecialchars($options);
            $data[$k][$kk]=$options;
        }

    }
    foreach ($data as $k => $v) {
        $obj->setActiveSheetIndex(0)
            ->setCellValue('A'.$k, $v['category'])
            ->setCellValue( 'B'.$k, $v['title'])
            ->setCellValue( 'C'.$k, $v['answer'])
            ->setCellValue( 'D'.$k, $v['reference'])
            ->setCellValue( 'E'.$k, $v['level']);

        if(isset($v[0])){
            $obj->setActiveSheetIndex(0)
                ->setCellValue('F'.$k, $v[0]);
        }
        if(isset($v[1])){
            $obj->setActiveSheetIndex(0)
                ->setCellValue('G'.$k, $v[1]);
        }
        if(isset($v[2])){
            $obj->setActiveSheetIndex(0)
                ->setCellValue('H'.$k, $v[2]);
        }
        if(isset($v[3])){
            $obj->setActiveSheetIndex(0)
                ->setCellValue('I'.$k, $v[3]);
        }
        if(isset($v[4])){
            $obj->setActiveSheetIndex(0)
                ->setCellValue('J'.$k, $v[4]);
        }
    }
    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    header('Content-Disposition: attachment;filename="732.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');
    exit;
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值