Practical phpxlsx

Images

Introduction

Adding images to spreadsheets requires using the addImage method setting the position and the number of rows and columns to fill.

Valid format files for working with images are JPG, PNG, and GIF. Base64 images can also be added. SVG contents can be added using addSvg.

If you use a template, you can replace an existing image using the replaceVariableImage method.

Adding images

The method for adding new images in the active sheet is addImage:

    public function addImage($image, $position, $options = array())

This method includes the following parameters:

The following sample code adds an image in the B5 position with column and row sizes:

$options = array(
    'colSize' => 3,
    'rowSize' => 7,
);
$xlsx->addImage('image.png', 'B5', $options);

Backgrounds

If instead of inserting an image in the active sheet you want to place it as background, use addBackgroundImage:

public function addBackgroundImage($image, $options = array())

You have to indicate the path, base64 or stream of the image in it. For example:

$xlsx->addBackgroundImage('image.jpg');

Replacing images in a template

As explained on Working with templates, phpxlsx includes the replaceVariableImage method to replace images in templates.