insert image

[dimaregabriele]

How do I insert an image into the xls file? the image is present on the server. format png.

[AndreyNazarchuk]

$sheeti = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$sheeti->setName('name');
$sheeti->setDescription('description');
$sheeti->setPath('/filename.png');
$sheeti->setHeight(90);
$sheeti->setCoordinates("G14");
$sheeti->setOffsetX(20);
$sheeti->setOffsetY(5);
$sheeti->setWorksheet($sheet);

[leadstar116]

I can insert image into xls format file.
But when I write it into pdf using MPDF library, image is broken.
How can I fix this?

[danielpolifabro]

leadstar116, Its happing with me too.
I can save a totally formatted xlsx file (including images in header and footer)
but when I use Mpdf library to convert to PDF these resources dont apper.

[leadstar116]

Hi, Daniel

Did you try to set absolute path for image?
It works for me.
Give full path of image.
It will appear on pdf but with broken style, I guess.

[dimaregabriele]

I found that if I open the excel file, I insert the image, and save the file with another name there are no problems, otherwise it goes wrong.

[githubjeka]

Probably cause is #877 (comment)

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.