本文共 2402 字，大约阅读时间需要 8 分钟。

下载：PHPExcel  https://github.com/PHPOffice/PHPExcel

解压后：Classes文件夹改名为PHPExcel 

方法一：然后把PHPExcel文件夹放到根目录vendor文件夹下

//导出    public function studentexport(){						$student = db('student')->select();     //数据库查询				$path = dirname(__FILE__); //找到当前脚本所在路径				 vendor("PHPExcel.PHPExcel"); //方法一				$PHPExcel = new \PHPExcel();				$PHPSheet = $PHPExcel->getActiveSheet();				$PHPSheet->setTitle("demo"); //给当前活动sheet设置名称				$PHPSheet->setCellValue("A1", "ID")					->setCellValue("B1", "城市编号")					->setCellValue("C1", "PATH")					->setCellValue("D1", "PCODE")					->setCellValue("E1", "城市名");				$i = 2;				foreach($student as $data){									$PHPSheet->setCellValue("A" . $i, $data['id'])										->setCellValue("B" . $i, $data['type'])										->setCellValue("C" . $i, $data['guishu'])										->setCellValue("D" . $i, $data['hezuodanwei'])										->setCellValue("E" . $i, $data['name']);									$i++;					}				$PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, "Excel2007");				header('Content-Disposition: attachment;filename="表单数据.xlsx"');				header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');				$PHPWriter->save("php://output"); //表示在$path路径下面生成demo.xlsx文件	}

方法二：然后把PHPExcel文件夹放到根目录extend文件夹下

//导出    public function studentexport(){						$student = db('student')->select();     //数据库查询				$path = dirname(__FILE__); //找到当前脚本所在路径				 //vendor("PHPExcel.PHPExcel"); //方法一                 require "../extend/PHPExcel/PHPExcel.php";				$PHPExcel = new \PHPExcel();				$PHPSheet = $PHPExcel->getActiveSheet();				$PHPSheet->setTitle("demo"); //给当前活动sheet设置名称				$PHPSheet->setCellValue("A1", "ID")					->setCellValue("B1", "城市编号")					->setCellValue("C1", "PATH")					->setCellValue("D1", "PCODE")					->setCellValue("E1", "城市名");				$i = 2;				foreach($student as $data){									$PHPSheet->setCellValue("A" . $i, $data['id'])										->setCellValue("B" . $i, $data['type'])										->setCellValue("C" . $i, $data['guishu'])										->setCellValue("D" . $i, $data['hezuodanwei'])										->setCellValue("E" . $i, $data['name']);									$i++;					}				$PHPWriter = \PHPExcel_IOFactory::createWriter($PHPExcel, "Excel2007");				header('Content-Disposition: attachment;filename="表单数据.xlsx"');				header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');				$PHPWriter->save("php://output"); //表示在$path路径下面生成demo.xlsx文件	}