ThinkPHP导出Excel类:
public function export(){
$log_db=M("log");
$pageSize=8;
$start = I('get.pageNow');
//dump($start);
if(!empty($start)){
$list=$log_db->order("iddesc")->limit("$start,$pageSize")->select();
}else{
$list=$log_db->order("iddesc")->select();
}
vendor('phpexcel.PHPExcel');
$excel = new \PHPExcel();
//set width
$excel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$excel->getActiveSheet()->getColumnDimension('B')->setWidth(75);
$excel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
$excel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$sheet =$excel->setActiveSheetIndex(0);
$sheet->setCellValue('A1','账号名称');
$sheet->setCellValue('B1','操作内容');
$sheet->setCellValue('C1','IP地址');
$sheet->setCellValue('D1','操作时间');
$i = 2;
foreach ($list as $v)
{
$sheet->setCellValue('A'.$i,$v['user_name']);
$sheet->setCellValue('B'.$i,$v['desc']);
$sheet->setCellValue('C'.$i,$v['ip']);
$sheet->setCellValue('D'.$i,$v['create_time']);
$i++;
}
//输出内容
ob_end_clean();//解决乱码
header('Expires: 0');
header("Pragma: no-cache");
header('Content-Type:application/octet-stream');
header('Content-Type:application/vnd.ms-excel');
header('Content-Disposition:attachment;filename="操作记录('.date('Ymd').').xlsx"');
header('Content-Transfer-Encoding:binary');
$writer =\PHPExcel_IOFactory::createWriter($excel,'Excel2007');
$writer->save('php://output');
}