duanqinbi9029 2014-06-11 14:34
浏览 152

在phpexcel中使用样式时,excel发现了不可读的内容

I am trying to set background color of a call based on cell value, But i am getting error when i use the below code

function bgColor($cell,$color){
 global $F; 
$F->getStyle($cell)->applyFromArray(
            array(
                'fill' => array(
                    'type' => PHPExcel_Style_Fill::FILL_SOLID,
                    'startcolor' => array('rgb' => $color),
                        'endcolor' => array('rgb' => $color)
                    //'color' => array('argb' => $color)
                    )
            )
    );
}

if i use rgb the following error occurs

Repaired Part: /xl/styles.xml part with XML error. (Styles) Load error. Line 2, column 934. Removed Feature: Format from /xl/styles.xml part (Styles) Removed Records: Style from /xl/styles.xml part (Styles)

if i use argb the first cell is filled with black color, while the argument passed to the color is yellow.

Ca anyone please tell me what i am doing wrong here

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#python#的问题:求帮写python代码
    • ¥20 MATLAB画图图形出现上下震荡的线条
    • ¥15 LiBeAs的带隙等于0.997eV,计算阴离子的N和P
    • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
    • ¥15 来真人,不要ai!matlab有关常微分方程的问题求解决,
    • ¥15 perl MISA分析p3_in脚本出错
    • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
    • ¥15 ubuntu虚拟机打包apk错误
    • ¥199 rust编程架构设计的方案 有偿
    • ¥15 回答4f系统的像差计算