duan246558 2019-04-11 12:20
浏览 151

使用其他单元格突出显示单元格时的PHPExcel条件格式

I am generating an excel sheet with PHPExcel, when using conditional formatting with highlight excel cells based on another cell. The conditions works fine. but value shows twice in cell.

Here is my code:

$objConditional43= new PHPExcel_Style_Conditional();    
$objConditional43->setConditionType(PHPExcel_Style_Conditional::CONDITION_EXPRESSION)->setOperatorType(PHPExcel_Style_Conditional::OPERATOR_BETWEEN)->addCondition('AND((S46<>AA124))');
$objConditional43->getStyle()->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getEndColor()->setARGB(PHPExcel_Style_Color::COLOR_RED); 
$conditionalStyles = $objPHPExcel->getActiveSheet()->getStyle('S46')->getConditionalStyles();
array_push($conditionalStyles, $objConditional43);
$objPHPExcel->getActiveSheet()->getStyle('S46')->setConditionalStyles($conditionalStyles);

My result: enter image description here

Expecting result: I am Expecting result like below

enter image description here

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题
    • ¥15 matlab中使用gurobi时报错
    • ¥15 这个主板怎么能扩出一两个sata口
    • ¥15 不是,这到底错哪儿了😭