- public function data_excel(){ include_onceLIB_ROOT_PATH."3rdParty/phpexcel/PHPExcel.php";
- $objPHPExcel=new PHPExcel();
- $objPHPExcel->setActiveSheetIndex(0)
- ->setCellValue('A1', '相近字')
- ->setCellValue('B1', '可能的字');
- $i= 0;
- foreach($temp as $key=>$value) {
- $i++;
- $objPHPExcel->getActiveSheet(0)->setCellValue('A'.($i+1),$key);
- $objPHPExcel->getActiveSheet(0)->setCellValue('B'.($i+1),$value);
- }
- // sheet命名
- $objPHPExcel->getActiveSheet()->setTitle('易错字统计');
- $objPHPExcel->setActiveSheetIndex(0);
- // excel头参数
- header('Content-Type: application/vnd.ms-excel');
- header('Content-Disposition: attachment;filename="('.date('Ymd-His').').xlsx"');//日期为文件名后缀
- header('Cache-Control: max-age=0');
- $objWriter= PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');//excel5为xls格式,excel2007为xlsx格式
- $objWriter->save('php://output');
- exit;
- }
来源: