利用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->