PHPExcel如何应用文本对齐水平填充-PHPExcel样式对齐::水平填充 - PHPExcel how to apply text alignment horizontal fill - PHPExcel_Style_Alignment::HORIZONTAL_Fill

PHPExcel how to apply text alignment horizontal fill - PHPExcel_Style_Alignment::HORIZONTAL_Fill

我正在使用PHPExcel创建excel文档。。。尝试将单元格文本对齐设置为水平以填充

$this->objPHPExcel->getDefaultStyle()
    ->getAlignment()
    ->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_Fill);

尝试将该选项添加到Alignment.php中，但没有成功

const HORIZONTAL_Fill = 'fill';

谢谢！

有效对齐样式

水平对齐样式是否可以使用：HORIZONTAL_LEFT = 'left', HORIZONTAL_RIGHT = 'right', HORIZONTAL_CENTER = 'center', HORIZONTAL_CENTER_CONTINUOUS = 'centerContinuous' and HORIZONTAL_JUSTIFY = 'justify'.

垂直对齐样式是否可以使用：VERTICAL_BOTTOM = 'bottom', VERTICAL_TOP = 'top', VERTICAL_CENTER = 'center', VERTICAL_JUSTIFY = 'justify' and HORIZONTAL_GENERAL = 'general'.

我认为您要查找的常量是

PHPExcel_Style_Alignment::HORIZONTAL_JUSTIFY

所有可用于PHPExcel_Style_Assignment的常量都可以在PHPExcel/Style/Assignment.php文件的顶部找到定义

对于PHPOffice更新版本（Laravel 5.*语法）

use PhpOffice'PhpSpreadsheet'Style'Alignment;
$style = array(
            'alignment' => array(
                'horizontal' => Alignment::HORIZONTAL_CENTER,
            )
        );
$activeSheet->getStyle("A1:D1")->applyFromArray($style);

试试这个，它对我有用。

$objPHPExcel->getActiveSheet()->getStyle('A11')->getAlignment()->applyFromArray(
     array('horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_FILL)
    );