使用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