PHP Excel表格导出图片方法

1、进入PHP Excel官网后，找到右边的download按钮，下载，下载完成的是一个压缩文件，解压放到你的项目目录里。

2、查看解压文件是否有PHPExcel_Worksheet_Drawing图片文件类。

3、创建一个excel.php文件，开始编写PHP Excel到出。

实例代码：

<?php
    /**
     * PHP Excel表格导出图片方法
     * 2015-07-30 
     */
    
     function ExcelCustomers(){
         
        /*引入phpexcel核心类文件*/
        
        include ROOT_PATH.'/system/libraries/phpExcel/PHPExcel.php';
        
        /*实例化excel类*/
        
        $excel = new PHPExcel();
        
        
        /*实例化excel图片处理类*/
        
        $objDrawing = new PHPExcel_Worksheet_Drawing();
        
        
        
        /*设置文本对齐方式*/
    
        $excel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        
        $excel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
        
        $objActSheet = $excel->getActiveSheet();

        $letter = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N');
    
        /*设置表头数据*/
        $tableheader = array('导出日期','姓名', '身份证号', '民族','性别' ,'地址','房号','入住次数','身份头像');
        
        
    /*    填充表格表头*/
        
        for($i = 0;$i < count($tableheader);$i++) {
        
            $excel->getActiveSheet()->setCellValue("$letter[$i]1","$tableheader[$i]");
            /*设置font*/
            $excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setName(iconv('gbk', 'utf-8', '宋体'));
            $excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setSize(16);
            $excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setBold(true);
            /*设置下划线*/
            //$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
            /*设置字体颜色*/
            //$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
            //$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_WHITE);
            /*设置表格宽度*/
            $objActSheet->getColumnDimension("$letter[$i]")->setWidth(20);
            $objActSheet->getColumnDimension("$letter[2]")->setWidth(30);
            $objActSheet->getColumnDimension("$letter[5]")->setWidth(60);
        


        }
        
        $startdate = !empty($_POST['startdate']) ? $_POST['startdate'] : date('Y-m-d',time());
                    
        /* 设置表格数据*/
        $hotel_customer = M('hotel_customer');
        $sql = "SELECT addtime,username,idcard,gender,national,address,photo,photo_s,number,check_num FROM tc_hotel_customer WHERE last_checkin = '".$startdate."'";
        $Obj = $hotel_customer ->query($sql);
        if(!empty($Obj)){
            foreach ($Obj as $k=>$v){
                $Obj[$k]['addtime'] = date('Y-m-d',time());
                list($Oldrwidth, $Oldheight) = getimagesize($v['photo']);
                if($Oldrwidth > 126 && $Oldheight > 102){
                    $Obj[$k]['photos'] = $v['photo_s'];
                }else{
                    $Obj[$k]['photos'] = $v['photo'];
                }
                if($v['gender'] == 1){
                    $Obj[$k]['gender'] = '男';
                }else{
                    $Obj[$k]['gender'] = '女';
                }
                 unset($Obj[$k]['photo']);
                 unset($Obj[$k]['photo_s']);
            }
        }else{
        
            echo "<script>alert('亲，今天没人入住哟！');location.href='index.php?ac=hotel_customers';</script>";
            exit;
        }
            
        /*向每行单元格插入数据*/
        
        for ($i = 0;$i < count($Obj);$i++) {
            
            
            
            $j = $i + 2;

            /*设置表格高度*/
            
            $excel->getActiveSheet()->getRowDimension($j)->setRowHeight(50);
            $excel->getActiveSheet()->getStyle($j)->getFont()->setSize(12);
            /*设置表格格式*/
            $excel->getActiveSheet()->getStyle("$letter[2]$j")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER);
         for ($row = 0;$row < count($Obj[$i]);$row++) {
                $photos = '';
                if ($row == (count($Obj[$i]) - 1 )) {
                
                /*实例化excel图片处理类*/
        
                $objDrawing = new PHPExcel_Worksheet_Drawing();
                if(!empty($Obj[$i]['photos'])){
                        $photo = substr($Obj[$i]['photos'],7);
                        $photoAry = explode('/',$photo);
                    
                        if(in_array('uploadfiles',$photoAry)){
                            unset($photoAry[0]);
                            $photos = implode('/',$photoAry);
                            //var_dump($photos);exit;
                            /*设置图片路径 切记：只能是本地图片*/
                            $objDrawing->setPath($photos);
                        
                        }
                
                }else{
                
                    $objDrawing->setPath($photos,false);
                }
                
                    
                    /*设置图片高度*/
                    $objDrawing->setWidth(20);
                    $objDrawing->setHeight(60);
                    
                    /*设置图片要插入的单元格*/
                    
                    $objDrawing->setCoordinates("$letter[$row]$j");
                    
                    /*设置图片所在单元格的格式*/
                    
                    $objDrawing->setOffsetX(50);
                    $objDrawing->setRotation(20);
                    
                    $objDrawing->getShadow()->setVisible(true);
                    
                    $objDrawing->getShadow()->setDirection(50);
                    
                    $objDrawing->setWorksheet($excel->getActiveSheet());
                    
                    continue;
                
                }
                
                    $excel->getActiveSheet()->setCellValue("$letter[0]$j",$Obj[$i]['addtime']);
                    $excel->getActiveSheet()->setCellValue("$letter[1]$j",$Obj[$i]['username']);
                    $excel->getActiveSheet()->setCellValue("$letter[2]$j",$Obj[$i]['idcard']);
                    $excel->getActiveSheet()->setCellValue("$letter[3]$j",$Obj[$i]['national']);
                    $excel->getActiveSheet()->setCellValue("$letter[4]$j",$Obj[$i]['gender']);
                    $excel->getActiveSheet()->setCellValue("$letter[5]$j",$Obj[$i]['address']);
                    $excel->getActiveSheet()->setCellValue("$letter[6]$j",$Obj[$i]['number']);
                    $excel->getActiveSheet()->setCellValue("$letter[7]$j",$Obj[$i]['check_num']);
                
                
                
            }
        
        }
        $date = $startdate."的住客资料";
  
        /*实例化excel输入类并完成输出excel文件*/
    
        $write = new PHPExcel_Writer_Excel5($excel);
        //var_dump($write);exit;
        
        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=$date.xls");
        
        header("Content-Transfer-Encoding:binary");
        
        $write->save('php://output');
            
            
        


        //var_dump($row);exit;
        
        
    }
    ?>