PhpSpreadsheet how to center an image in a cell?

Question

phpspreadsheet

PhpSpreadsheet Tell me how to place an image in a cell in the center?
the picture is smaller than the height of the cell, the cell should have center styles.

'alignment'=>[
'horizontal'=>\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,'vertical'=>\PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER
  ],

and for some reason the picture runs over the neighboring BORDER

, only the TEXT in this cell is centered...

Answer 1

I will answer myself))

$drawing->setOffsetX(($spreadsheet->getActiveSheet()->getColumnDimension('A1')->getWidth()-$drawing->getWidth())/2);
$drawing->setOffsetY(($spreadsheet->getActiveSheet()->getColumnDimension('A1')->getHeight()-$drawing->getHeight())/2);