php导出excel 颜色,phpexcel导出excel的颜色与网页中颜色不一致的解决方法

使用phpexcel导出的excel的颜色与网页中颜色不一致，经过尝试，终于解决了。

先来看我的代码：

复制代码 代码如下:

require_once './PHPExcel.php';

require_once './Excel5.php';

require_once './get_excel_row.php';

require "../include/base.php";

require "../include/function/006/creatExcelDb.php";

define("COLOR1","#96B7F6");

//查 处理 数据--------------------------

$q = $db->query("select * from oa_event_sales");

while($a = $db->fetch_array($q)){

$list[] = $a;

}

$ce = new creatExcelDb();

$re = $ce->_run($list,'served_time','client_status','oid');

$all_nums=0;

$num=array();

foreach($re as $k=>$v){

$num[$k]=count($re[$k]);

$all_nums+=count($re[$k]);

}

$jq = array();

$title1 = client_status;

$title2 = fin_confirm;

$title3 = oid;

//去除数组中相同的值

foreach($re as $key => $val){

if(true){

foreach($val as $key2 => $val2){

if(!in_array($key2,$jq)){

$jq[] = $key2;

}

}

}

}

$arr_keys=array();

foreach($re as $k=>$v){

foreach($v as $k2=>$v2){

$arr_keys[]=$k2;

}

}

$c=a