search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.19k forks source link

Multiple Column Group #1304

Open thwoi opened 7 years ago

thwoi commented 7 years ago

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

pranavwhiz commented 5 years ago

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.