国产日韩欧美精品,free×性护士vidos中国,荡女精品导航

Home

Daily Programming

PHP Knowledge

ThinkPHP's PHPExcel exports multiple image data

眼眸間的深情

Dec 17, 2021 am 10:32 AM

I have done an example of data export to Excel in a previous project. I recently needed to export image data. I have never encountered such a project, so when the process is successful, I hereby record it. I hope it can give some inspiration to friends in need!

Back -end controller method:

        /*導(dǎo)入phpExcel核心類(lèi) */
        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 格式
 
        //實(shí)例化PHPExcel類(lèi)
        $objPHPExcel = new PHPExcel();
 
        $objPHPExcel->createSheet(0);
        $objPHPExcel->setActiveSheetIndex(0);
        $currentSheet = $objPHPExcel->getActiveSheet();
 
//      $objPHPExcel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(300);#設(shè)置單元格行高（此方法經(jīng)過(guò)個(gè)人測(cè)試，發(fā)現(xiàn)會(huì)出現(xiàn)excel變形）
 
        // 設(shè)置內(nèi)容居中
        $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);
        
        // 設(shè)置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);
 
        // 設(shè)置頭部單元格注釋信息
        $currentSheet->setCellValue(&#39;A1&#39;, "數(shù)據(jù)1");
        $currentSheet->setCellValue(&#39;B1&#39;, "數(shù)據(jù)2");
        $currentSheet->setCellValue(&#39;C1&#39;, "數(shù)據(jù)3");
        $currentSheet->setCellValue(&#39;D1&#39;, "數(shù)據(jù)4");
        $currentSheet->setCellValue(&#39;E1&#39;, "數(shù)據(jù)5");
        $currentSheet->setCellValue(&#39;F1&#39;, "數(shù)據(jù)6");
        $currentSheet->setCellValue(&#39;G1&#39;, "數(shù)據(jù)7");
        $currentSheet->setCellValue(&#39;H1&#39;, "數(shù)據(jù)8");
        $currentSheet->setCellValue(&#39;I1&#39;, "數(shù)據(jù)9");
        $currentSheet->setCellValue(&#39;J1&#39;, "數(shù)據(jù)10");
        $currentSheet->setCellValue(&#39;K1&#39;, "數(shù)據(jù)11");
        $currentSheet->setCellValue(&#39;L1&#39;, "數(shù)據(jù)12");
        $currentSheet->setCellValue(&#39;M1&#39;, "照片數(shù)據(jù)1");
        $currentSheet->setCellValue(&#39;N1&#39;, "照片數(shù)據(jù)2");
        $currentSheet->setCellValue(&#39;O1&#39;, "照片數(shù)據(jù)3");
        $currentSheet->setCellValue(&#39;P1&#39;, "照片數(shù)據(jù)4");
 
        $idx = 2;
 
        //查詢出數(shù)據(jù)庫(kù)內(nèi)的數(shù)據(jù)信息
        //查詢出所需信息
        $searchInfo = M(&#39;數(shù)據(jù)表&#39;)->select();
 
        //組裝查詢條件
        $year_time_result = 自定義設(shè)置的查詢條件;
 
        $i = 0;
        foreach ($searchInfo as &$y){
 
            $i++;
 
            //設(shè)置數(shù)據(jù)所在單元格
            $currentSheet->setCellValue(&#39;A&#39; . $idx, 數(shù)據(jù)1);
            $currentSheet->setCellValue(&#39;B&#39; . $idx, 數(shù)據(jù)2);
            $currentSheet->setCellValue(&#39;C&#39; . $idx, 數(shù)據(jù)3);
            $currentSheet->setCellValue(&#39;D&#39; . $idx, 數(shù)據(jù)4);
            $currentSheet->setCellValue(&#39;E&#39; . $idx, 數(shù)據(jù)5);
            $currentSheet->setCellValue(&#39;F&#39; . $idx, 數(shù)據(jù)6);
            $currentSheet->setCellValue(&#39;G&#39; . $idx, 數(shù)據(jù)7);
            $currentSheet->setCellValue(&#39;H&#39; . $idx, 數(shù)據(jù)8);
            $currentSheet->setCellValue(&#39;I&#39; . $idx, 數(shù)據(jù)9);
            $currentSheet->setCellValue(&#39;J&#39; . $idx, 數(shù)據(jù)10);
            $currentSheet->setCellValue(&#39;K&#39; . $idx, 數(shù)據(jù)11);
            $currentSheet->setCellValue(&#39;L&#39; . $idx, 數(shù)據(jù)12);
 
            //設(shè)置單元格高度，這個(gè)是重點(diǎn)哦
            $currentSheet->getRowDimension($idx) -> setRowHeight(100);
 
            //圖片處理類(lèi)，這個(gè)才是圖片導(dǎo)出的關(guān)鍵哦
            $objDrawing = new PHPExcel_Worksheet_Drawing();
 
            //開(kāi)始設(shè)置圖片
 
            //照片數(shù)據(jù)1
            if(!empty(照片數(shù)據(jù)1)){
                $objDrawing->setPath(照片數(shù)據(jù)1);
                // 設(shè)置圖片寬度高度
                $objDrawing->setHeight(100);//照片高度
                $objDrawing->setWidth(100); //照片寬度
                /*設(shè)置圖片要插入的單元格*/
                $objDrawing->setCoordinates(&#39;M&#39;.$idx);
                // 圖片偏移距離
                $objDrawing->setOffsetX(0);
                $objDrawing->setOffsetY(0);
                $objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //圖片處理類(lèi)，這個(gè)才是圖片導(dǎo)出的關(guān)鍵哦
            $objDrawing1 = new PHPExcel_Worksheet_Drawing();
 
            //照片數(shù)據(jù)2
            if(!empty(照片數(shù)據(jù)2)){
                $objDrawing1->setPath(照片數(shù)據(jù)2);
                // 設(shè)置圖片寬度高度
                $objDrawing1->setHeight(100);//照片高度
                $objDrawing1->setWidth(100); //照片寬度
                /*設(shè)置圖片要插入的單元格*/
                $objDrawing1->setCoordinates(&#39;N&#39;.$idx);
                // 圖片偏移距離
                $objDrawing1->setOffsetX(0);
                $objDrawing1->setOffsetY(0);
                $objDrawing1->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //圖片處理類(lèi)，這個(gè)才是圖片導(dǎo)出的關(guān)鍵哦
            $objDrawing2 = new PHPExcel_Worksheet_Drawing();
 
            //照片數(shù)據(jù)3
            if(!empty(照片數(shù)據(jù)3)){
                $objDrawing2->setPath(照片數(shù)據(jù)3);
                // 設(shè)置圖片寬度高度
                $objDrawing2->setHeight(100);//照片高度
                $objDrawing2->setWidth(100); //照片寬度
                /*設(shè)置圖片要插入的單元格*/
                $objDrawing2->setCoordinates(&#39;O&#39;.$idx);
                // 圖片偏移距離
                $objDrawing2->setOffsetX(0);
                $objDrawing2->setOffsetY(0);
                $objDrawing2->setWorksheet($objPHPExcel->getActiveSheet());
            }
 
            //圖片處理類(lèi)，這個(gè)才是圖片導(dǎo)出的關(guān)鍵哦
            $objDrawing3 = new PHPExcel_Worksheet_Drawing();
 
            //照片數(shù)據(jù)4
            if(!empty(照片數(shù)據(jù)4)){
                $objDrawing3->setPath(照片數(shù)據(jù)4);
                // 設(shè)置圖片寬度高度
                $objDrawing3->setHeight(100);//照片高度
                $objDrawing3->setWidth(100); //照片寬度
                /*設(shè)置圖片要插入的單元格*/
                $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="導(dǎo)出excel的文件名（可自定義）"&#39;);
        header("Content-Transfer-Encoding:binary");
        $write->save(&#39;php://output&#39;);

code to share. It needs to be noticed that this time this is the code for the success of my project. You must import the phpExcel core class. This class library file is the key. Free download address: ThinkPHP implements the PHPExcel class library file for exporting data to Excel files. Then it should be noted that when exporting multiple pictures Be sure to remember to instantiate multiple image variables, otherwise variable conflicts and image coverage problems will occur. The last problem is that when reading database data, if the image data does not exist in the database, you need to read the data. Determine whether it is empty, otherwise a program error will occur during operation. If these are paid attention to, then our function will run and present the program well.

The above is the detailed content of ThinkPHP's PHPExcel exports multiple image data. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn