search

liuggio / ExcelBundle

Excel integration in Symfony2 thanks to https://github.com/PHPOffice/PHPExcel library
www.welcometothebundle.com
MIT License
369 stars 142 forks source link

How can I merge two or multiple columns or rows? #99

Closed RodolVelasco closed 8 years ago

RodolVelasco commented 8 years ago

I cant find a way to merge columns or rows from the controller

liuggio commented 8 years ago

This is the documentation of the symfony bundle, please can you refer to the php library doc. directly?

RodolVelasco commented 7 years ago

I found a solution:

$phpExcelObject->setActiveSheetIndex(0)->setCellValue('B2', 'TEST TEST TEST TEST')->mergeCells('B2:F2');