我要评论一：方法介绍
导出插入图片主要使用\phpoffice\phpspreadsheet\worksheet\drawing实现
$drawing = new \phpoffice\phpspreadsheet\worksheet\drawing();
$drawing->setname('logo');//设置图片名称
$drawing->setdescription('logo');//设备图片描述
$drawing->setpath('./images/officelogo.jpg');//设置图片地址
$drawing->setheight(36);//设置图片高度
$drawing->setcoordinates('a1');//设置图片绘制到指定单元格
$drawing->setworksheet($spreadsheet->getactivesheet());//将图片绘制到工作表二：实现实例
$spreadsheet = new spreadsheet();//创建一个新的excel文档
$sheet = $spreadsheet->getactivesheet();//获取当前操作sheet的对象
//将图片绘制到excel中
$drawing = new \phpoffice\phpspreadsheet\worksheet\drawing();
$drawing->setpath($img);
$drawing->setheight(50);
$drawing->setcoordinates('a1');
$drawing->setworksheet($sheet);
$writer = new xlsx($spreadsheet);
$writer->save('xxx.xlsx');//生成excel文件
//将多个图片绘制到excel中
$spreadsheet = new spreadsheet();//创建一个新的excel文档
$sheet = $spreadsheet->getactivesheet();//获取当前操作sheet的对象
//将图片绘制到excel中
foreach ($imgs as $img) {
$drawing = new \phpoffice\phpspreadsheet\worksheet\drawing();
$drawing->setpath($img);
$drawing->setheight(50);
$drawing->setcoordinates('a1');
$drawing->setworksheet($sheet);
}
$writer = new xlsx($spreadsheet);
$writer->save('xxx.xlsx');//生成excel文件三：参考
基础操作参考：
文档地址：https://phpspreadsheet.readthedocs.io/
github地址：https://github.com/phpoffice/phpspreadsheet
以上就是php使用phpoffice/phpspreadsheet导出图片实例的详细内容，更多关于phpoffice/phpspreadsheet导出图片的资料请关注代码网其它相关文章！
发表评论