php读取带密码的excel,PHP读取Excel图片对象，并保存替换为相对路径

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

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

/**

* 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;

}

}