replaceVariableImage

Array with the names of the placeholder template image variables as keys and the image paths, base64 contents, streams or GdImage objets that should replace them.

options

The possible keys and values of this array are:

Key	Type	Description
alt	string	Alt value.
colOffset	array	'from' (int) column size offset from. 'to' (int) column size offset to.
colSize	int	Number of columns used by the image.
descr	string	Descr value.
mime	string	Forces a mime (image/jpg, image/jpeg, image/png, image/gif, image/bmp, image/webp).
rowOffset	array	'from' (int) row size offset from. 'to' (int) row size offset to.
rowSize	int	Number of rows used by the image.
target	string	sheets (default), headers, footers.

Exceptions

Image doesn't exist.

Code samples

Example #1

require_once 'classes/CreateXlsx.php';

$xlsx = new CreateXlsxFromTemplate('template.xlsx');

// replace image in sheets target
$xlsx->replaceVariableImage(array('IMAGE_1' => 'image.png'));

// replace image in headers target
$options = array(
	'target' => 'headers',
);
$xlsx->replaceVariableImage(array('IMAGE_HEADER' => 'image.jpg'), $options);

// replace image in footers target
$options = array(
	'target' => 'footers',
);
$xlsx->replaceVariableImage(array('IMAGE_FOOTER' => 'image.jpg'), $options);

$xlsx->saveXlsx('output');

The resulting XLSX looks like:

Release notes

phpxlsx 4.0:
- alt, colOffset, colSize, descr, rowOffset and rowSize options.
- WebP images.
- GdImage as image source.

phpxlsx 2.5:
- stream and base64 as image source.

phpxlsx 2.0:
- supported drawingHF tags.

phpxlsx 1.0:
- new method.