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

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -