PhpSpreadSheet Javascript AJAX jQuery PHP Example MORE

How to add multiple image in PhpSpreadsheet

I often see developers facing difficulties to add multiple images in a single excel sheet. In this example I solved the issue.

<?php

    require __DIR__ . '/vendor/autoload.php';

    /* Create new Spreadsheet object */
    $spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

    /* add code that show the issue here... */
    function addImage($path,$coordinates,$sheet){
        $drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
        $drawing->setPath($path);
        $drawing->setCoordinates($coordinates);
        $drawing->setWorksheet($sheet);
    }

    addImage('./images/example1/file.jpg','A1',$spreadsheet->getActiveSheet());
    addImage('./images/example2/file.jpg','B1',$spreadsheet->getActiveSheet());
    addImage('./images/example3/file.jpg','C1',$spreadsheet->getActiveSheet());