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

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

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

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2021/1/11 0011
 * Time: 8:59
 */

namespace App\Services;

use PhpOffice\PhpSpreadsheet\Cell\Coordinate;
use PhpOffice\PhpSpreadsheet\Exception;
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
use Vtiful\Kernel\Excel;

/**
 * 读取Excel图片并保存其路径
 * Class ExcelImagePathServer
 * @package App\Services
 */
class ExcelImagePathServer
{
    /**
* @var string
*/
    protected $relative_path = '/images';

    /**
* @var Spreadsheet
*/
    protected $spreadsheet;

    /**
* @var Excel
*/
    protected $xls_writer;

    /**
* @var Excel
*/
    protected $sheet_writer;

    /**
* @var string
*/
    protected $image_path;

    /**
* ExcelImagePathServer constructor.
* @param string $excel_file
* @throws \PhpOffice\PhpSpreadsheet\Reader\Exception
*/
    public function __construct($excel_file)
    {
   $reader = IOFactory::createReader('Xlsx');
   $this->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);
   }
    }

    /**
* @throws Exception
*/
    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) {
 /**@var $drawing 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);
    }

    /**
* 保存图片
*
* @param Drawing $drawing
* @param $image_filename
* @return string
* @throws Exception
*/
    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();
    }

    /**
* 坐标转换
*
* @param $abc
* @return float|int
*/
    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图片对象，并保存替换为相对路径的详细内容！

查看更多关于PHP读取Excel图片对象，并保存替换为相对路径的详细内容...