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.
$objPHPExcel->addNamedRange(
new PHPExcel_NamedRange(
'MyNamedRange',
$objPHPExcel->getActiveSheet(),
'A1:A3,C1:C3,E1:E3'
)
);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With