php读取Excel文档里的图片

关注

原创最新推荐文章于 2026-05-31 16:13:36 发布 2.1k 阅读 AI 写同款· GEO 优化 ›

PhpSpreadsheet 读取 excel 里面的图片使用 phpSpreadSheet 插件去读取 excel 里面的图片时发现坑点很多，这里做一个总结。这里会把excel里面的图片读取，然后存放到服务器指定的目录。解决方案：不要使用.xls格式的excel，使用.xlsx。在composer.json配置。我使用的是 tp 框架。composer安装。阅读详情

利用phpspreadsheet插件实现，可根据单元格读取

public function index(){
        $objRead = IOFactory::createReader('Xlsx');
        $spreadsheet = $objRead->load('./test.xlsx');
        /* 获取指定的sheet表 */
        $currSheet = $spreadsheet->getSheet(0);
        /* 获取总行数 */
//        $rowCnt = $currSheet->getHighestRow();
//        var_dump($rowCnt);
//        var_dump($currSheet->getCell('B2')->getValue());
//        exit;
        $i = 0;
        foreach ($spreadsheet->getActiveSheet()->getDrawingCollection() as $drawing) {


            if ($drawing instanceof \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing) {

                ob_start();
                call_user_func(
                    $drawing->getRenderingFunction(),
                    $drawing->getImageResource()
                );
                $imageContents = ob_get_contents();
                ob_end_clean();
                switch ($drawing->getMimeType()) {
                    case \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_PNG :
                        $extension = 'png';
                        break;
                    case \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_GIF:
                        $extension = 'gif';
                        break;
                    case \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_JPEG :
                        $extension = 'jpg';
                        break;
                }
            } else {


                if($drawing->getCoordinates()=='C3'){
                    $zipReader = fopen($drawing->getPath(),'r');
                    $imageContents = '';
                    while (!feof($zipReader)) {
                        $imageContents .= fread($zipReader,1024);
                    }
                    fclose($zipReader);
                    $extension = $drawing->getExtension();
                }else{
                    continue;
                }





            }
            $myFileName = '00_Image_'.'b2'.'.'.$extension;
            file_put_contents('./'.$myFileName,$imageContents);
        }




    }

收录于