PHPExcel ThinkPHP mengeksport berbilang data imej-pengetahuan PHP-php.cn

Saya telah melakukan contoh eksport data ke Excel dalam projek sebelumnya boleh memberi sedikit inspirasi kepada rakan-rakan yang memerlukan!

Kaedah pengawal belakang:

        /*导入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;);

Salin selepas log masuk

Kod telah dikongsikan yang perlu saya perhatikan ialah ini adalah kod yang telah berjaya dilaksanakan dalam projek saya Perkara pertama yang anda perlu beri perhatian ialah Ya, anda mesti mengimport kelas teras phpExcel Fail perpustakaan kelas ini adalah alamat muat turun percuma: ThinkPHP melaksanakan fail perpustakaan kelas PHPExcel untuk mengeksport data ke dalam fail Excel . . Maka harus diperhatikan bahawa apabila mengeksport berbilang Apabila menggunakan gambar, anda mesti ingat untuk membuat instantiate berbilang pembolehubah gambar, jika tidak, akan ada konflik pembolehubah dan masalah liputan gambar. Masalah terakhir ialah apabila membaca data pangkalan data, jika tiada data gambar dalam pangkalan data, anda perlu Tentukan sama ada data kosong, jika tidak ralat program akan berlaku semasa operasi Jika ini diberi perhatian, maka fungsi kami akan berjalan dan membentangkan program dengan baik.

Atas ialah kandungan terperinci PHPExcel ThinkPHP mengeksport berbilang data imej. Untuk maklumat lanjut, sila ikut artikel berkaitan lain di laman web China PHP!