PHP Excel设置整个列数据对齐方式不起作用 [英] Php Excel set whole column data alignment not working

问题描述

我正在使用此代码将E列数据设置为右对齐，但未显示出效果

I am Using this code For E column data set to right align but Its not showing me effect

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

如果我写E6而不是'E'，则它将E6单元格数据显示在右侧.

instead of 'E' if i write E6 then it display E6 cell data to right.

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

推荐答案

您是正确的:PHPExcel不支持行和列样式.

You're correct: row and column styles aren't supported by PHPExcel.

单元格样式是，但是您也可以通过一系列单元格来设置样式:

Cell styling is, but you can also set style by a range of cells:

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

这篇关于PHP Excel设置整个列数据对齐方式不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！