php导出excel

最新推荐文章于 2022-04-18 14:23:46 发布

xufengnian_boke

最新推荐文章于 2022-04-18 14:23:46 发布

阅读量230

点赞数

文章标签： php

本文链接：https://blog.csdn.net/xufengnian_boke/article/details/106188001

版权

php导出Excel表格

    public function excel()
    {
       $ids = $this->request->param('order_id/a');
//     print_r($ids);exit;
        if (!$ids) {
            $this->error('数据异常');
        }

        $list = Db::name('pig_order')->where('id','in',$ids)->select();
        foreach ($list as $kk => $vv){
            $list[$kk]['buy_mobile'] = Db::name('user')->where('id',$vv['uid'])->value('mobile');
            $list[$kk]['sell_mobile'] = Db::name('user')->where('id',$vv['sell_id'])->value('mobile');
            $list[$kk]['pig_name'] = Db::name('task_config')->where('id',$vv['pig_id'])->value('name');
        }

        vendor("PHPExcel.PHPExcel");
        $objPHPExcel = new \PHPExcel();
        // 设置sheet
        $objPHPExcel->setActiveSheetIndex(0);
        // 设置列的宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);

        // 设置表头
        $objPHPExcel->getActiveSheet()->SetCellValue('A1', '订单号');
        $objPHPExcel->getActiveSheet()->SetCellValue('B1', '买家手机号');
        $objPHPExcel->getActiveSheet()->SetCellValue('C1', '卖家手机号');
        $objPHPExcel->getActiveSheet()->SetCellValue('D1', '价格');
        $objPHPExcel->getActiveSheet()->SetCellValue('E1', '宠物名称');
       
        $num = 2;
        foreach ($list as $k => $v) {
            $objPHPExcel->getActiveSheet()->SetCellValue('A' . $num, $v['order_no']);
            $objPHPExcel->getActiveSheet()->SetCellValue('B' . $num, $v['buy_mobile']);
            $objPHPExcel->getActiveSheet()->SetCellValue('C' . $num, $v['sell_mobile']);
            $objPHPExcel->getActiveSheet()->SetCellValue('D' . $num, $v['price']);
            $objPHPExcel->getActiveSheet()->SetCellValue('E' . $num, $v['pig_name']);
            $num++;
        }
        // 文件名称
        $fileName = "订单信息" . date('Y-m-d', time()) . rand(1, 1000);
        $xlsName = iconv('utf-8', 'gb2312', $fileName);
        // 设置工作表名
        $objPHPExcel->getActiveSheet()->setTitle('订单表');
        //下载 excel5与excel2007
        $objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);

        ob_end_clean();     // 清除缓冲区,避免乱码
        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;charset=UTF-8");
        header("Content-Type:application/octet-stream");
        header("Content-Type:application/download");
        header("Content-Disposition:attachment;filename=" . $xlsName . ".xls");
        header("Content-Transfer-Encoding:binary");
        //$objWriter->save("worker.xls");
        $objWriter->save('php://output');
       
        return json(['code'=>1,'msg'=>'成功']);
    }