PHPExcel icon indicating copy to clipboard operation
PHPExcel copied to clipboard

Multiple Column Group

Open thwoi opened this issue 7 years ago • 1 comments

How can I group multiple columns? For example, I want to group column A, B and C together?

thwoi avatar Aug 31 '17 08:08 thwoi

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.

pranavwhiz avatar Dec 06 '18 10:12 pranavwhiz