tp5 phpexcel导出excel表格

 

下载：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文件
	}