Does not work drawing about phpspreadsheet HOT 4 CLOSED

I confirm that the following code wil output an xlsx with an image, but an xls without an image (assuming a test.jpg beside the script) as seen in LibreOffice 5:

<?php

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

$spreadsheet = new PhpOffice\PhpSpreadsheet\Spreadsheet();

$drawing = new PhpOffice\PhpSpreadsheet\Worksheet\Drawing(); 
$drawing->setPath('test.jpg');
$drawing->setWorksheet($spreadsheet->getActiveSheet());

$writer = new PhpOffice\PhpSpreadsheet\Writer\Xlsx($spreadsheet);
$writer->save('test.xlsx');

$writer = new PhpOffice\PhpSpreadsheet\Writer\Xls($spreadsheet);
$writer->save('test.xls');

Unfortunately I won't have time to investigate further. But if you could determine exactly what commit broke the feature, it would be very helpful.

from phpspreadsheet.

I found strange place when debug this problem in PhpOffice\PhpSpreadsheet\Writer\Excel5:

Switch never execute any switch block because expected that class will start with "\" in but class name start from latin character. I guess it can be reason of this issue but not check it.

from phpspreadsheet.

I checked it, drawing now attached.
Submited PR with fix: #61

from phpspreadsheet.

My need is same, I have tried from view with html img tag but it does not worked. then I have tried below methods :

public static function beforeSheet(BeforeSheet $event) {
    
    $drawing = new Drawing();
    $drawing->setPath(public_path('sent_files/35/100_1521622088/35_final_card.png'));
    $drawing->setCoordinates('A3');
    $drawing->setWidth(150);
    $drawing->setHeight(100);
    $drawing->setWorksheet($event->sheet);
}

I am getting bellow error :

Type error: Argument 1 passed to PhpOffice\\PhpSpreadsheet\\Worksheet\\BaseDrawing::setWorksheet() must be an instance of PhpOffice\\PhpSpreadsheet\\Worksheet\\Worksheet or null, instance of Maatwebsite\\Excel\\Sheet given, called in /php_projects/my-details/app/Exports/ReportDataFromSbExport.php on line 113

from phpspreadsheet.