Image in row show bad position

[hernandoglobal]

1️⃣ Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before? (Currently 3.1.x)

2️⃣ What version of the package, Laravel and PHP do you use? Please provide the FULL version number.

• Laravel Excel version: [3.1]
• Laravel version: [8]
• PHP version: [7.3]

3️⃣ Describe your issue. Please be short, but concise.

I xport excel, with images using function drawings, but the imagen put on the first row ant then put the info.

4️⃣ How can the issue be reproduced? Please provide easy-to-reproduce steps (repository, simple code example, failing unit test).

controller:

public function export(Request $request) 
    {
        $producto = Producto::select('cod_producto', 'referencia_producto', 'descrip_producto', 'precenta_producto', 'valor_producto', 'ruta_img')
                    ->where('Estado_producto', 'activo' )
                    ->get();
        return (new ProductoExport($producto))->download('Productos.xlsx');
}

Export:

<?php

namespace App\Exports;

use App\Models\Producto;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\WithDrawings;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
use Maatwebsite\Excel\Concerns\WithCustomStartCell;

class ProductoExport implements FromCollection,WithHeadings, WithDrawings, WithCustomStartCell
{
    public function __construct($data)
    {
        $this->productos = $data;
    }


    public function headings(): array
    {
        return [
            'COD', 'REF', 'DESCRIPCION', 'EMP', 'PRECIO','FOTO',
        ];
    }

    use Exportable;
    
    public function drawings()
    {
        $drawings = [];

        foreach($this->productos as $k=>$drawing_temp)
        {
            if($drawing_temp)
            {
                    $drawing = new Drawing();
                    $drawing->setName('image');
                    $drawing->setDescription('image');
                    // $drawing->setPath(public_path('08/'.$drawing_temp->cod_producto.'.jpg'));
                    $drawing->setPath(public_path('08/18045.jpg'));
                    $drawing->setHeight(70);
                    $drawing->setOffsetX(100);
                    $drawing->setOffsetY(100);
                    $drawing->setCoordinates('H'.($k+4));
                    $drawings[] = $drawing;
            }
        }
        return $drawings;
    }

    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return $this->productos;
        
    }

    public function startCell(): string
    {
        return 'A4';
    }
}

5️⃣ What should be the expected behaviour?

how can I put the image in the same row tha the info? thaks.

[patrickbrouwers]

As you are using PhpSpreadsheet logic to insert the images, I can't be of much help here.

[DoubleTime]

any luck on this?

Using Drawing or image at blade produce same error, image not in correct cell.

[hhino-dev]

I got same problem and solved by moving the drawing process into AfterSheet event. (I did not use WithDrawing concern)
Here is a part of my code.

~~~
    public function getDrawings():array
    {
        $rowNum = 2;
        $drawings = [];

        foreach ($this->collection() as $row) {

            $drawing = new Drawing();
            $drawing->setPath($row->imagePath);
            $drawing->setCoordinates('A'.$rowNum);
            $drawings[] = $drawing;

            $rowNum++;
        }

        return $drawings;
    }

    public function registerEvents():array
    {
        return [
            AfterSheet::class => function (AfterSheet $event) {
                $workSheet = $event->sheet->getDelegate();

                // insert images
                foreach ($this->getDrawings() as $drawing) {
                    $drawing->setWorksheet($workSheet);
                }
            },
        ];
    }
}

[msslgomez]

You're a life safer, the only solution after 2+ hours of trying that actually works!

[ggrigoryan93]

Please provide all code. Not clear how to use

[ggrigoryan93]

Can you please provide all code?

[Tepchiva]

<?php

namespace App\Exports;

use Maatwebsite\Excel\Events\AfterSheet;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithStyles;
use PhpOffice\PhpSpreadsheet\Style\Border;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;
use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class EmployeeExport implements FromCollection, WithHeadings, WithMapping, ShouldAutoSize, WithEvents, WithStyles {
    function __construct(protected $query){

    }
    public function headings(): array
    {
        return [
            'Emp. Code',
            'Full Name',
            'Department',
            'Position',
            'Branch',
            'Phone Number',
            'QR V-Card'
        ];
    }

    public function map($item): array
    {
        return [
            $item->employee_id,
            $item->full_name,
            $item->department_name,
            $item->position_name,
            $item->branch_name,
            $item->phone_number,
        ];
    }

    public function collection()
    {
        return $this->query->get();
        
    }

    public function setImage($workSheet) {
        $this->collection()->each(function($employee,$index) use($workSheet) {
            $drawing = new Drawing();
            $drawing->setName($employee->full_name);
            $drawing->setDescription($employee->full_name);
            $drawing->setPath(public_path('images/placeholders/user.png'));
            $drawing->setHeight(40);
            $index+=2;
            $drawing->setCoordinates("G$index");
            $drawing->setWorksheet($workSheet);
        });
    }

    public function registerEvents():array {
        return [
            AfterSheet::class => function (AfterSheet $event) {
                $event->sheet->getDefaultRowDimension()->setRowHeight(60);
                $workSheet = $event->sheet->getDelegate();
                $this->setImage($workSheet);
            },
        ];
    }
    public function styles(Worksheet $sheet) {
        $count = count($this->query->get());
        $sheet->getStyle('A1:G1')->getFont()->setBold(true);
        $sheet->getStyle('A1:G1')->applyFromArray([
            'borders' => [
                'allBorders' => [
                    'borderStyle' => Border::BORDER_THIN,
                    'color' => ['argb' => '000'],
                ],
            ],

        ]);

        $sheet->getStyle('A1:G1')->getFill()->applyFromArray([
            'fillType' => 'solid',
            'rotation' => 0,
            'color' => ['rgb' => '8D4019'],
        ]);
    }
}

[ggrigoryan93]

Thank you :)

[MuhammadSyahmi98]

Thank you work for me!

[ashott1997]

Works, thank you, you are amazing axpers:) !!!