博客

用到的是PHPExcel,

我放置的文件目录是Common\Org

具体使用方法见demo:

        /**
	 * 中奖名单导出
	 *
	 */
	public function check_out_winners(){
		$winners = D('winners');
		$data = $winners->join("tb_prize p on __WINNERS__.prize_id = p.id ")->field("tb_winners.id,username,phone,address,name,ip,create_time")->select();
		$headArr = array('id','姓名','手机号','地址','奖品','ip','时间');
        import("Common.Org.PHPExcel");
        import("Common.Org.PHPExcel.Writer.CSV");
        import("Common.Org.PHPExcel.Writer.Excel5");
        //
        import("Common.Org.PHPExcel.IOFactory.php");
        $fileName = "winners";

        $this->exportExcel($fileName,$headArr,$data); //数据导出
	}
	function exportExcel($fileName,$headArr,$data){
        if(empty($data) || !is_array($data)){
            die("data must be a array");
        }
        if(empty($fileName)){
            exit;
        }
        $date = date("Y_m_d",time());
        $fileName .= "_{$date}.csv";

        //创建新的PHPExcel对象
        $objPHPExcel = new \PHPExcel();

        $objProps = $objPHPExcel->getProperties();

        //设置表头
        $kk = ord("A");
        //r_dump($headArr);
        foreach($headArr as $v){
            $colum = chr($kk);
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($colum.'1',$v);
            $kk += 1;
        }

        $column = 2;
        $objActSheet = $objPHPExcel->getActiveSheet();
        foreach($data as $key => $rows){ //行写入
            $span = ord("A");
            foreach($rows as $keyName=>$value){// 列写入
                $j = chr($span);
                $objActSheet->setCellValue($j.$column,$value);
                //$objPHPExcel->getActiveSheet()->setCellValue($column, 'www.baidu.com');
                //$objPHPExcel->getActiveSheet()->getCell($j.$column)->getHyperlink()->setUrl('//www.phpexcel.net');

                //$objActSheet->setCellValue('F'.$column, 'www.phpexcel.net');
                $objActSheet->getCell('F'.$column)->getHyperlink()->setUrl('//www.baidu.com');
                $span++;
            }
            $column++;
        }

        //$fileName = iconv("UTF-8", "GBK", $fileName);
        //设置活动单指数到第一个表,所以Excel打开这是第一个 表
        $objPHPExcel->setActiveSheetIndex(0);
        header('Content-Type: application/vnd.ms-excel');
        header("Content-Disposition: attachment;filename=\"$fileName\"");
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
        $objWriter->save('php://output'); //文件通过浏览器下载
      exit;

    }