PHPExcel条件格式不太正确 [英] PHPExcel conditional formatting not quite right
本文介绍了PHPExcel条件格式不太正确的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试在满足此条件的第2行之后的每一行的所有单元格的底部添加边框:
I'm trying to add a border to the bottom of all cells in every row after row 2 that satisfies this condition:
$objConditional1 = new PHPExcel_Style_Conditional();
$objConditional1->setConditionType(PHPExcel_Style_Conditional::CONDITION_EXPRESSION)
->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_EQUAL)
->addCondition('AND((B2<>B3),B2<>"")');
$objConditional1->getStyle()->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$conditionalStyles = $sheet->getStyle('B2')->getConditionalStyles();
array_push($conditionalStyles, $objConditional1);
$sheet->getStyle('B2')->setConditionalStyles($conditionalStyles);
$sheet->duplicateConditionalStyle(
$sheet->getStyle('B2')->getConditionalStyles(),
'B3:B9999'
);
- 我不确定我是否知道如何在第2行之后的每一行和每一列中添加此条件...
- 第二,未按预期添加边框...在excel中,格式显示为(无)...
我可以帮忙吗?
目标是看起来像这样:
The goal is to look like this:
推荐答案
添加内容位于最后一行!做完了.. ta da
The addition is in the last line! Did the job.. ta da
$objConditional1 = new PHPExcel_Style_Conditional();
$objConditional1->setConditionType(PHPExcel_Style_Conditional::CONDITION_EXPRESSION)
->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_EQUAL)
->addCondition('AND((B2<>B3),B2<>"")');
$objConditional1->getStyle()->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
$conditionalStyles = $sheet->getStyle('B2')->getConditionalStyles();
array_push($conditionalStyles, $objConditional1);
$sheet->getStyle('A$2:$U$10000')->setConditionalStyles($conditionalStyles);
这篇关于PHPExcel条件格式不太正确的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文