从官网下载phpexcel文件包。
从数据库导出数据到excel文件代码:<?php
include '../PHPExcel/PHPExcel.php'; //引入核心库文件
include '../PHPExcel/PHPExcel/Writer/Excel2007.php'; //引入excel2007操作类
include '../PHPExcel/PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel(); //实例化phpexcel对象
//创建人
$objPHPExcel->getProperties()->setCreator("{$_SESSION['adminName']}");
//最后修改人
$objPHPExcel->getProperties()->setLastModifiedBy("{$_SESSION['adminName']}");
//标题
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX all user list Document");
//题目
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX all user list Document");
//描述
$objPHPExcel->getProperties()->setDescription("all user list");
//关键字
$objPHPExcel->getProperties()->setKeywords("all user list");
//种类
$objPHPExcel->getProperties()->setCategory("office document");
//设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);
//设置表头
$objPHPExcel->getActiveSheet()->setCellValue('A1', "用户名");
$objPHPExcel->getActiveSheet()->setCellValue('B1', "密码");
$objPHPExcel->getActiveSheet()->setCellValue('C1', "邮箱");
$objPHPExcel->getActiveSheet()->setCellValue('D1', "电话");
$objPHPExcel->getActiveSheet()->setCellValue('E1', "真实姓名");
$objPHPExcel->getActiveSheet()->setCellValue('F1', "注册时间");
$objPHPExcel->getActiveSheet()->setCellValue('G1', "ip来源");
$sql = "SELECT * FROM user"; 查询数据库所有数据
$res = $nsodb -> get_results($sql,ARRAY_A);
foreach($res as $key=>$val){ 把结果集进行遍历一行一行写入excel
$key+=2;
$objPHPExcel->getActiveSheet()->setCellValue('A'.$key, $val['uid']);
$objPHPExcel->getActiveSheet()->setCellValue('B'.$key, $val['password']);
$objPHPExcel->getActiveSheet()->setCellValue('C'.$key, $val['mail']);
$objPHPExcel->getActiveSheet()->setCellValue('D'.$key, $val['phone']);
$objPHPExcel->getActiveSheet()->setCellValue('E'.$key, $val['name']);
$objPHPExcel->getActiveSheet()->setCellValue('F'.$key, $val['add_time']);
$objPHPExcel->getActiveSheet()->setCellValue('G'.$key, $val['ipaddress']);
}
// 高置列的宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);
ob_end_clean(); //清除缓存防止乱码
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="alluser.xlsx"'); //设置excel 文件名
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output'); //保存
exit;
?>