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);
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);
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);
Since nobody explained how to style an entire column, which was part of the question, here's the code:
$lastrow = $objPHPExcel->getActiveSheet()->getHighestRow();
$objPHPExcel->getActiveSheet()
->getStyle('E1:E'.$lastrow)
->getAlignment()
->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
Try this code. It works well.And I have confirmed.
$activeSheet = $phpExcelObject->getActiveSheet();
//..
//...
$activeSheet->getStyle("E")
->getAlignment()
->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_RIGHT);
This code align the column E in horizontal right
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With