PHPExcel
PHPExcel copied to clipboard
Multiple Column Group
How can I group multiple columns? For example, I want to group column A, B and C together?
You can that do by making "Outline Level" same for all these columns, e.g.
$spreadsheet->getActiveSheet() ->getColumnDimension ('A') ->setOutlineLevel(1) ->setVisible(false) ->setCollapsed(true);
$spreadsheet->getActiveSheet() ->getColumnDimension ('B') ->setOutlineLevel(1) ->setVisible(false) ->setCollapsed(true);
$spreadsheet->getActiveSheet() ->getColumnDimension ('C') ->setOutlineLevel(1) ->setVisible(false) ->setCollapsed(true);
As you can see in above example I have merge A,B and C by setting their "Outline Level" same i.e. 1.