ThinkPHP의 PHPExcel은 여러 이미지 데이터를 내보냅니다.-PHP 지식-php.cn

数据 프로젝트에서 엑셀 인스턴스를 내보내려고 데이터를 작성했는데, 최근에는 이런 프로젝트를 접하지 못해서, 조금이나마 영감을 드리고자 합니다. 도움이 필요한 친구를 위해! ： 백엔드 컨트롤러 방식: 控

        /*导入phpExcel核心类 */
        require_once APP_PATH.&#39;PHPExcel/PHPExcel.php&#39;;
        require_once APP_PATH.&#39;PHPExcel/PHPExcel/Writer/Excel5.php&#39;;     // 用于其他低版本xls
        require_once APP_PATH.&#39;PHPExcel/PHPExcel/Writer/Excel2007.php&#39;; // 用于 excel-2007 格式
 
        //实例化PHPExcel类
        $objPHPExcel = new PHPExcel();
 
        $objPHPExcel->createSheet(0);
        $objPHPExcel->setActiveSheetIndex(0);
        $currentSheet = $objPHPExcel->getActiveSheet();
 
//      $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(300);#设置单元格行高（此方法经过个人测试，发现会出现excel变形）
 
        // 设置内容居中
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;A&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;B&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;C&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;D&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;E&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;F&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;G&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;H&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;I&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;J&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;K&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;L&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;M&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;N&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;O&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle(&#39;P&#39;)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        
        // 设置excel宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;A&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;B&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;C&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;D&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;E&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;F&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;G&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;H&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;I&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;J&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;K&#39;)->setWidth(20);
        $objPHPExcel->getActiveSheet()->getColumnDimension(&#39;L&#39;)->setWidth(20);
 
        // 设置头部单元格注释信息
        $currentSheet->setCellValue(&#39;A1&#39;, "数据1");
        $currentSheet->setCellValue(&#39;B1&#39;, "数据2");
        $currentSheet->setCellValue(&#39;C1&#39;, "数据3");
        $currentSheet->setCellValue(&#39;D1&#39;, "数据4");
        $currentSheet->setCellValue(&#39;E1&#39;, "数据5");
        $currentSheet->setCellValue(&#39;F1&#39;, "数据6");
        $currentSheet->setCellValue(&#39;G1&#39;, "数据7");
        $currentSheet->setCellValue(&#39;H1&#39;, "数据8");
        $currentSheet->setCellValue(&#39;I1&#39;, "数据9");
        $currentSheet->setCellValue(&#39;J1&#39;, "数据10");
        $currentSheet->setCellValue(&#39;K1&#39;, "数据11");
        $currentSheet->setCellValue(&#39;L1&#39;, "数据12");
        $currentSheet->setCellValue(&#39;M1&#39;, "照片数据1");
        $currentSheet->setCellValue(&#39;N1&#39;, "照片数据2");
        $currentSheet->setCellValue(&#39;O1&#39;, "照片数据3");
        $currentSheet->setCellValue(&#39;P1&#39;, "照片数据4");
 
        $idx = 2;
 
        //查询出数据库内的数据信息
        //查询出所需信息
        $searchInfo = M(&#39;数据表&#39;)->select();
 
        //组装查询条件
        $year_time_result = 自定义设置的查询条件;
 
        $i = 0;
        foreach ($searchInfo as &$y){
 
            $i++;
 
            //设置数据所在单元格
            $currentSheet->setCellValue(&#39;A&#39; . $idx, 数据1);
            $currentSheet->setCellValue(&#39;B&#39; . $idx, 数据2);
            $currentSheet->setCellValue(&#39;C&#39; . $idx, 数据3);
            $currentSheet->setCellValue(&#39;D&#39; . $idx, 数据4);
            $currentSheet->setCellValue(&#39;E&#39; . $idx, 数据5);
            $currentSheet->setCellValue(&#39;F&#39; . $idx, 数据6);
            $currentSheet->setCellValue(&#39;G&#39; . $idx, 数据7);
            $currentSheet->setCellValue(&#39;H&#39; . $idx, 数据8);
            $currentSheet->setCellValue(&#39;I&#39; . $idx, 数据9);
            $currentSheet->setCellValue(&#39;J&#39; . $idx, 数据10);
            $currentSheet->setCellValue(&#39;K&#39; . $idx, 数据11);
            $currentSheet->setCellValue(&#39;L&#39; . $idx, 数据12);
 
            //设置单元格高度，这个是重点哦
            $currentSheet->getRowDimension($idx) -> setRowHeight(100);
 
            //图片处理类，这个才是图片导出的关键哦
            $objDrawing = new PHPExcel_Worksheet_Drawing();
 
            //开始设置图片
 
            //照片数据1
            if(!empty(照片数据1)){
                $objDrawing->setPath(照片数据1);
                // 设置图片宽度高度
                $objDrawing->setHeight(100);//照片高度
                $objDrawing->setWidth(100); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing->setCoordinates(&#39;M&#39;.$idx);
                // 图片偏移距离
                $objDrawing->setOffsetX(0);
                $objDrawing->setOffsetY(0);
                $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //图片处理类，这个才是图片导出的关键哦
            $objDrawing1 = new PHPExcel_Worksheet_Drawing();
 
            //照片数据2
            if(!empty(照片数据2)){
                $objDrawing1->setPath(照片数据2);
                // 设置图片宽度高度
                $objDrawing1->setHeight(100);//照片高度
                $objDrawing1->setWidth(100); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing1->setCoordinates(&#39;N&#39;.$idx);
                // 图片偏移距离
                $objDrawing1->setOffsetX(0);
                $objDrawing1->setOffsetY(0);
                $objDrawing1->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //图片处理类，这个才是图片导出的关键哦
            $objDrawing2 = new PHPExcel_Worksheet_Drawing();
 
            //照片数据3
            if(!empty(照片数据3)){
                $objDrawing2->setPath(照片数据3);
                // 设置图片宽度高度
                $objDrawing2->setHeight(100);//照片高度
                $objDrawing2->setWidth(100); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing2->setCoordinates(&#39;O&#39;.$idx);
                // 图片偏移距离
                $objDrawing2->setOffsetX(0);
                $objDrawing2->setOffsetY(0);
                $objDrawing2->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //图片处理类，这个才是图片导出的关键哦
            $objDrawing3 = new PHPExcel_Worksheet_Drawing();
 
            //照片数据4
            if(!empty(照片数据4)){
                $objDrawing3->setPath(照片数据4);
                // 设置图片宽度高度
                $objDrawing3->setHeight(100);//照片高度
                $objDrawing3->setWidth(100); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing3->setCoordinates(&#39;P&#39;.$idx);
                // 图片偏移距离
                $objDrawing3->setOffsetX(0);
                $objDrawing3->setOffsetY(0);
                $objDrawing3->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            $idx++;
 
        }
 
        $write = new PHPExcel_Writer_Excel5($objPHPExcel);
        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(&#39;Content-Disposition:attachment;filename="导出excel的文件名（可自定义）"&#39;);
        header("Content-Transfer-Encoding:binary");
        $write->save(&#39;php://output&#39;);

로그인 후 복사

코드가 공유됩니다. 이번에 정리해야 할 것은 내 프로젝트의 성공 코드라는 것입니다. Phpexcel의 핵심 카테고리입니다. 이 클래스 라이브러리 파일이 핵심입니다. 무료 다운로드 주소:

ThinkPHP는 데이터를 Excel 파일로 내보내기 위한 PHPExcel 클래스 라이브러리 파일을 구현합니다

. 그렇지 않으면 변수 충돌과 이미지 덮어쓰기 문제가 발생합니다. 마지막 문제는 데이터베이스 데이터를 읽을 때 데이터베이스에 이미지 데이터가 없는 경우 데이터가 비어 있는지 판단해야 한다는 것입니다. 그렇지 않으면 프로그램 오류가 발생합니다. 예외가 발생합니다. 이러한 사항에 주의를 기울이면 우리 기능이 실행되고 프로그램이 매우 잘 표시됩니다.

위 내용은 ThinkPHP의 PHPExcel은 여러 이미지 데이터를 내보냅니다.의 상세 내용입니다. 자세한 내용은 PHP 중국어 웹사이트의 기타 관련 기사를 참조하세요!