php - 我可以选择多个单元格或一组范围来设置它们的样式吗？

Question

我知道我可以 access a range of cells in order to format them :

$objPHPExcel->getActiveSheet()->getStyle('B3:B7')->getFill()
    ->setFillType(PHPExcel_Style_Fill::FILL_SOLID)
    ->getStartColor()->setARGB('FFFF0000');

现在有办法吗？如果有，我如何在 getStyle() 调用中定义多个单元格或一组范围？我试过了

$objPHPExcel->getActiveSheet()->getStyle('B3:B7;C6:C12')->getFill()->...

和

$objPHPExcel->getActiveSheet()->getStyle('B3;C9;D2;E6')->getFill()->...

但两者均无效并引发错误。

Answer 1

根据 Mark Baker (Coordinator of the PHPOffice suite of Open Source libraries) ,

that doesn't work, [you can] only [define] one range at a time.

来源:上面的评论。