我正在使用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 PhpOfficePhpSpreadsheetStyleAlignment;
$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)
);