用thinkkphp和phpexcel导出数据到excel

三步。设置列数，填充表头，填充数据。百度下就行了。很多例子

$excel = new PHPExcel();
$title = array(); // 這個是你的表頭，也就是把你的會員表要導出的字段名組成數組
//設置excel列數 ，說通俗點就是有幾個字段就幾列。
for($i='A',$j='0';$j<($title);$j++,$i++){
$letter[]=$i;
}
$letter = array_values($letter);
//填充表头信息
for($i = 0;$i < count($title);$i++) {
$excel->getActiveSheet()->setCellValue("$letter[$i]1","$title[$i]");
}
//$memberlist是你的會員表數據
//填充數據
for ($i = 2;$i <= count($memberlist) + 1;$i++) {
$j = 0;
foreach ($memberlist[$i - 2] as $key=>$value) {
$excel->getActiveSheet()->setCellValue("$letter[$j]$i","$value");
$j++;
}
}
$write = new PHPExcel_Writer_Excel5($excel);
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename="會員資料.xls"');
header("Content-Transfer-Encoding:binary");
$write->save('php://output');