php phpexcel 内容靠最右边_PHPExcel右对齐图像

我正在尝试使用PHPExcel对齐图像,但我不能,因为图像覆盖在工作表上方.

// Create new picture object

$objDrawing = new PHPExcel_Worksheet_Drawing();

$objDrawing->setPath('my_img.jpg');

// Insert picture

$objDrawing->setCoordinates('A1');

$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

// Style cell

$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);

A1的文本对齐方式更改为右对齐,但图像仍然在左侧对齐.

解决方法:

有同样的挑战：如何正确地将图片与单元格对齐.我正在使用PHP Spreadsheet,它继承了PHP Excel.这有效：

use PhpOffice\PhpSpreadsheet\Worksheet;

use PhpOffice\PhpSpreadsheet\Worksheet\Drawing;

$ws = $spreadsheet->getActiveSheet();

$logoPath = __DIR__ . '/reporting/templates/SmallLogo.jpg';

$drawing = new Drawing();

$drawing->s