php - Can I select multiple cells or a set of ranges in order to style them? -
i know can access range of cells in order format them:
$objphpexcel->getactivesheet()->getstyle('b3:b7')->getfill() ->setfilltype(phpexcel_style_fill::fill_solid) ->getstartcolor()->setargb('ffff0000');
now there way, , if yes, how can define multiple cells or set of ranges within getstyle()
call? tried
$objphpexcel->getactivesheet()->getstyle('b3:b7;c6:c12')->getfill()->...
and
$objphpexcel->getactivesheet()->getstyle('b3;c9;d2;e6')->getfill()->...
but both didn't work , threw error.
according mark baker (coordinator of phpoffice suite of open source libraries),
that doesn't work, [you can] [define] 1 range @ time.
source: comments above.
Comments
Post a Comment