shopncexcel导出

来源：互联网发布：淘宝多大可以开店编辑：程序博客网时间：2024/05/19 17:27

33好商城excel导出

/*
* 会员excel导出
*/
public function memberecelOp(){
$member_list = [];

// echo '<pre>';
// print_r($member_list);
// $model = Model('stat');exit;
//获取全部店铺结账数据
//导出Excel
import('libraries.excel');
$excel_obj = new Excel();
$excel_data = array();
//设置样式
$excel_obj->setStyle(array('id'=>'s_title','Font'=>array('FontName'=>'微软雅黑','Size'=>'12','Bold'=>'1')));
//header
$excel_data[0][0] = array('styleid'=>'s_title','data'=>'登录用户名');
$excel_data[0][1] = array('styleid'=>'s_title','data'=>'真实姓名');
$excel_data[0][2] = array('styleid'=>'s_title','data'=>'邮箱');

//data
foreach ($member_list as $k=>$v){
$excel_data[$k+1][0] = array('data'=>$v['member_name']);
$excel_data[$k+1][1] = array('data'=>$v['member_truename']);
$excel_data[$k+1][2] = array('data'=>$v['member_email']);

}
$excel_data = $excel_obj->charset($excel_data,CHARSET);
$excel_obj->addArray($excel_data);
$excel_obj->addWorksheet($excel_obj->charset('会员详细信息',CHARSET));
$excel_obj->generateXML($excel_obj->charset('会员详细信息',CHARSET).date('Y-m-d-H',time()));
exit();

}

0 0