Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I create a named range containing non-contiguous cells in PHPExcel?

Tags:

php

phpexcel

How do I create a named range containing non-contiguous cells in PHPExcel? Is it even possible? Thanks in advance!

Here's what I did:

$objPHPExcel->addNamedRange(
   new PHPExcel_NamedRange('ToggleRange', $activeSheet, 'C4:G5,C9:J10,C14:H15')
);

What's happening though is that the named range is only being applied to C4:G5, and not the other cells.

like image 865
Brian T Avatar asked Jan 30 '26 02:01

Brian T


1 Answers

$objPHPExcel->addNamedRange( 
    new PHPExcel_NamedRange(
        'MyNamedRange', 
        $objPHPExcel->getActiveSheet(), 
        'A1:A3,C1:C3,E1:E3'
    ) 
);
like image 125
Mark Baker Avatar answered Jan 31 '26 15:01

Mark Baker



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!