How to make a few groups of columns?

Topics: Developer Forum, Project Management Forum, User Forum
Jun 6, 2011 at 11:23 AM
Edited Jun 15, 2011 at 1:19 PM

How to make several groups of column? For example I need 2 groups of column:

 - B, C

 - D, E, F

Unfortunately manual doesn't give clear information. In fact there are very poorly described working with setOutlineLevel.

If we do step by step:

$this->objPHPExcel->getActiveSheet()->getColumnDimension('B')->setOutlineLevel(1);
$this->objPHPExcel->getActiveSheet()->getColumnDimension('C')->setOutlineLevel(1);
$this->objPHPExcel->getActiveSheet()->getColumnDimension('D')->setOutlineLevel(1);
$this->objPHPExcel->getActiveSheet()->getColumnDimension('E')->setOutlineLevel(1);
$this->objPHPExcel->getActiveSheet()->getColumnDimension('F')->setOutlineLevel(1);

we receive one big group and how separate first group (B and C) from the second (D, E and F)?