PHP读取Excel图片对象，并保存替换为相对路径

下面由PHP教程栏目给大家介绍PHP读取Excel图片对象，并保存替换为相对路径方法，希望对需要的朋友有所帮助！

PHP利用PhpSpreadsheet 和 xlswriter 读取Excel图片对象，保存替换为相对路径

spreadsheet = $reader->load($excel_file);

 $config = ['path' => dirname($excel_file)];
 $this->xls_writer = new Excel($config);

 $this->image_path = dirname($excel_file) . $this->relative_path;
 if (!is_dir($this->image_path)) {
     mkdir($this->image_path, 0755);
 }
    }

    
    public function handle()
    {
 $write_filename = date('YmdHis') . '.xlsx';
 $sheetCount = $this->spreadsheet->getSheetCount();
 for ($i = 0; $i < $sheetCount; $i++) {
     $worksheet = $this->spreadsheet->getSheet($i);
     $data = $worksheet->toArray();
     $sheetNames = $this->spreadsheet->getSheetNames();
     var_dump($sheetCount, $sheetNames);
     // 读取并修改
     foreach ($worksheet->getDrawingCollection() as $drawing) {
  
  list($startColumn, $startRow) = Coordinate::coordinateFromString($drawing->getCoordinates());
  $image_filename = "/{$i}-" . $drawing->getCoordinates();
  $image_suffix = $this->saveImage($drawing, $image_filename);
  $image_name = ltrim($this->relative_path, '/') . "{$image_filename}.{$image_suffix}";
  var_dump($image_name);
  $startColumn = $this->ABC2decimal($startColumn);

  $data[$startRow - 1][$startColumn] = $image_name;
     }

     // 写入文件
     if ($i == 0) {
  $this->sheet_writer = $this->xls_writer->fileName($write_filename, $sheetNames[$i])->data($data);
     } else {
  // 向文件中追加工作表
  $this->sheet_writer->addSheet($sheetNames[$i])->data($data);
     }
 }
 // 最后的最后，输出文件
 $filePath = $this->sheet_writer->output();
 var_dump($filePath);
    }

    
    protected function saveImage(Drawing $drawing, $image_filename)
    {
 $image_filename .= '.' . $drawing->getExtension();
 switch ($drawing->getExtension()) {
     case 'jpg':
     case 'jpeg':
  $source = imagecreatefromjpeg($drawing->getPath());
  imagejpeg($source, $this->image_path . $image_filename);
  break;
     case 'gif':
  $source = imagecreatefromgif($drawing->getPath());
  imagegif($source, $this->image_path . $image_filename);
  break;
     case 'png':
  $source = imagecreatefrompng($drawing->getPath());
  imagepng($source, $this->image_path . $image_filename);
  break;
     default:
  throw new Exception('image format error!');
 }

 return $drawing->getExtension();
    }

    
    protected function ABC2decimal($abc)
    {
 $ten = 0;
 $len = strlen($abc);
 for ($i = 1; $i <= $len; $i++) {
     $char = substr($abc, 0 - $i, 1);//反向获取单个字符

     $int = ord($char);
     $ten += ($int - 65) * pow(26, $i - 1);
 }
 return $ten;
    }
}

以上就是PHP读取Excel图片对象，并保存替换为相对路径的详细内容，更多请关注考高分网其它相关文章！