Member Avatar for baloch123
baloch123 0 Newbie Poster

Hello

I have excel file having few cells merged for Title.
e.g
B1:F1 are merged cells,i want to align text of these merged cells to center.keeping the cells merged.
I have use this code but it didn't work

$objPHPExcel->getActiveSheet()->mergeCells('B1:F1');
$objPHPExcel->getActiveSheet()->getStyle('B1:F1')->getAlignment()
->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
Edited by baloch123 because: Adding code
  • 1 Contributor
  • 0 Replies
  • 81 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.