php - 在 PHPExcel 中检索图像

Question

我想使用 PHPExcel 从 excel 文件读取/检索图像到 PHP。此代码用于从特定单元格中检索值。

    $objPHPExcel->getActiveSheet()->getCell('B5')->getValue();

这仅检索单元格值，但我无法检索图像。有办法吗？

Answer 1

Googling phpexcel read image产生了 this page作为第二个结果。它会告诉您如何执行此操作。

直接引用相关信息:

$objPHPExcel->getActiveSheet()->getDrawingCollection() will return an ArrayObject of all the image objects in the active worksheet.

These objects will be either PHPExcel_Worksheet_Drawing or PHPExcel_Worksheet_MemoryDrawing objects: you can identify which using is_a(). You can then use the methods appropriate to that class (as described in the API) either to read the image data from file (for PHPExcel_Worksheet_Drawing objects) or directly from the PHPExcel_Worksheet_MemoryDrawing object itself. The getName() and getDescription() methods can be used to retrieve the relevant values from the image object.

Note that it's also possible to have image objects associated with print headers:

$objPHPExcel->getActiveSheet()->getHeaderFooter()->getImages() can be used to retrieve images from the header/footer. This is an array of PHPExcel_Worksheet_HeaderFooterDrawing objects. All the PHPExcel_Worksheet_Drawing methods can be used to extract the image file from these objects.