这里只粘贴了使用的代码,里面需要引用phpexcel,在上面搜索phpexcel就有很多下载的
/**
* 客户导出
*
**/
public function excelExport($customerList=false){
C('OUTPUT_ENCODE', false);
import("ORG.PHPExcel.PHPExcel");
$objPHPExcel = new PHPExcel();
$objProps = $objPHPExcel->getProperties();
$objPHPExcel->setActiveSheetIndex(0);
$objActSheet = $objPHPExcel->getActiveSheet();

$objActSheet->setTitle('Sheet1');
$ascii = 65;
$cv = '';
//联系人字段
$contacts_fields_list = array();
$contacts_fields_list[0]['field'] = 'name';
$contacts_fields_list[0]['name'] = '用户名';
$contacts_fields_list[1]['field'] = 'telephone';
$contacts_fields_list[1]['name'] = '电话';

foreach($contacts_fields_list as $field){
$objActSheet->setCellValue($cv.chr($ascii).'1', $field['name']);
$ascii++;
if($ascii == 91){
$ascii = 65;
$cv .= chr(strlen($cv)+65);
}
}

/*$where['owner_role_id'] = array('in',implode(',', getSubRoleId()));
$where['is_deleted'] = 0;*/
$list = M('user')->select();
$ascii = 65;
$cv = '';
$i = 2;
foreach($list as $val){
foreach($contacts_fields_list as $valu){
//防止使用科学计数法,在数据前加空格
if($valu['field'] == 'telephone' || $valu['field'] =='qq'){
$objActSheet->setCellValue($cv.chr($ascii).$i, ' '.$val[$valu['field']]);
}else{
$objActSheet->setCellValue($cv.chr($ascii).$i, $val[$valu['field']]);
}

$ascii++;
if($ascii == 91){
$ascii = 65;
$cv .= chr(strlen($cv)+65);
}
}
$ascii = 65;
$cv = '';
$i++;
}

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
ob_end_clean();
header("Content-Type: application/vnd.ms-excel;");
header("Content-Disposition:attachment;filename=5kcrm_user_".date('Y-m-d',mktime()).".xls");
header("Pragma:no-cache");
header("Expires:0");
$objWriter->save('php://output');
}这里只粘贴了使用的代码,里面需要引用phpexcel,在上面搜索phpexcel就有很多下载的

再来一个简单的导出的方法:public function oexcel()
{
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename=user.xls');
header('Pragma: no-cache');
header('Expires: 0');
$title = array('手机', '昵称');
$data = M('user')->field("login,uname")->select();
echo iconv('utf-8', 'gbk', implode("\t", $title)), "\n";
foreach ($data as $value) {
echo iconv('utf-8', 'gbk', ' '.implode("\t", $value)), "\n";
}

}

评论() 相关

收藏

赞

q4323636

ThinkPHP 是一个免费开源的,快速、简单的面向对象的 轻量级PHP开发框架 ,创立于2006年初,遵循Apache2开源协议发布,是为了敏捷WEB应用开发和简化企业应用开发而诞生的。ThinkPHP从诞生以来一直秉承简洁实用的设计原则,在保持出色的性能和至简的代码的同时,也注重易用性。并且拥有众多的原创功能和特性,在社区团队的积极参与下,在易用性、扩展性和性能方面不断优化和改进,已经成长为国内最领先和最具影响力的WEB应用开发框架,众多的典型案例确保可以稳定用于商业以及门户级的开发。