Creating Multi-Colum Headers?

Topics: Developer Forum, User Forum
Mar 11, 2009 at 12:24 PM
Hi,
Thanks for the great library.
Is there a way to create multi-column excel headers with this?

Eg:
-------------------
|      Header A     |
-------------------
| A1 | A2 | A3 | A4|
--------------------
Coordinator
Mar 11, 2009 at 5:30 PM
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Header A');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 'A1');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 'A2');
$objPHPExcel->getActiveSheet()->setCellValue('C2', 'A3');
$objPHPExcel->getActiveSheet()->setCellValue('D2', 'A4');
$objPHPExcel->getActiveSheet()->mergeCells('A1:D1');
Mar 12, 2009 at 7:56 AM
Great, thank you Mark!