自己的导表

 public function  daochu()
{
    //1.从数据库中取出数据
            $list = Db::name('pay')
            ->alias('a')
            ->field('a.*,mid_user_auth.real_name,mid_user_auth.tel,mid_user_auth.bank_name')
            ->join('mid_user','a.uid=mid_user.uid')
            ->join('mid_user_auth','mid_user_auth.real_no=mid_user.real_no')
            ->order('a.create_time ')
            ->select();



    //halt($list);
    //2.加载PHPExcle类库
//    vendor('PHPExcel.PHPExcel');
    //3.实例化PHPExcel类
        $objPHPExcel = new \PHPExcel();
        $objPHPExcel->getProperties()->setCreator("AiMoney")//创建人
        ->setLastModifiedBy("AiMoney")//最后修改人
        ->setTitle('12354')//标题
        ->setSubject('12354')//题目
        ->setDescription('12354')//描述
        ->setKeywords("订单")//关键字
        ->setCategory("Test result file");//种类
    //4.激活当前的sheet表
    $objPHPExcel->setActiveSheetIndex(0);
    //5.设置表格头（即excel表格的第一行）
    $objPHPExcel->setActiveSheetIndex(0)
//        ->setCellValue('A1', 'ID')
//        ->setCellValue('B1', '防伪码')
//        ->setCellValue('C1', '标签码');
        ->setCellValue('A1', '订单编号')
        ->setCellValue('B1', '姓名')
        ->setCellValue('C1', '消费金额')
        ->setCellValue('D1', '电话')
        ->setCellValue('E1', '消费卡号')
        ->setCellValue('F1', '消费银行')
        ->setCellValue('G1', '消费类型')
        ->setCellValue('H1', '手续费')
        ->setCellValue('I1', '费率')
        ->setCellValue('J1', '通道')
        ->setCellValue('K1', '备注')
        ->setCellValue('L1', '消费情况')
        ->setCellValue('M1', '状态')
        ->setCellValue('N1', '消费时间')
        ->setCellValue('O1', '分润');
    //设置A列水平居中
//    $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()
//        ->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
    //设置单元格宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(13);
        $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(13);




    //6.循环刚取出来的数组，将数据逐一添加到excel表格。
    for($i=0;$i<count($list);$i++){
        $objPHPExcel->getActiveSheet()->setCellValue('A'.($i+2),$list[$i]['pno']);//订单编号
        $objPHPExcel->getActiveSheet()->setCellValue('B'.($i+2),$list[$i]['real_name']);//姓名
        $objPHPExcel->getActiveSheet()->setCellValue('C'.($i+2),$list[$i]['money']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('D'.($i+2),$list[$i]['tel']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('E'.($i+2),$list[$i]['c_no']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('F'.($i+2),$list[$i]['bank_name']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('G'.($i+2),$list[$i]['type']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('H'.($i+2),$list[$i]['server']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('I'.($i+2),$list[$i]['rate']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('J'.($i+2),$list[$i]['rate']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('K'.($i+2),$list[$i]['rate']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('L'.($i+2),$list[$i]['rate']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('M'.($i+2),$list[$i]['money']);//防伪码

        $objPHPExcel->getActiveSheet()->setCellValue('N'.($i+2),$list[$i]['create_time']);//防伪码
        $objPHPExcel->getActiveSheet()->setCellValue('O'.($i+2),$list[$i]['money']);//防伪码
    }
    //7.设置保存的Excel表格名称
    $filename = '文件下载'.date('ymd',time()).'.xls';
    //8.设置当前激活的sheet表格名称；
    $objPHPExcel->getActiveSheet()->setTitle('防伪码');
    //9.设置浏览器窗口下载表格
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");
    header('Content-Disposition:inline;filename="'.$filename.'"');
    //生成excel文件
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
    //下载文件在浏览器窗口
    $objWriter->save('php://output');
    exit;
}

}