php excel代码导出

c大山

已于 2022-07-11 14:59:10 修改

阅读量224

点赞数

分类专栏： phpexcel 文章标签： php thinkphp

于 2022-07-11 14:58:10 首次发布

本文链接：https://blog.csdn.net/qwa23r/article/details/125721613

版权

phpexcel 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

链接：https://pan.baidu.com/s/1bfsTSH6EJNs5cy1y6jF3jQ
提取码：1111
下载 phpexcel 放到 vendor 里面复制下面代码直接引用

		vendor('PHPExcel.PHPExcel');
		vendor('PHPExcel.PHPExcel.IOFactory');
		$excel = new \PHPExcel();
		$name = '工资统计表';
		//针对中文名转码
		iconv('UTF-8', 'gb2312', $name);
		//表头,名称可自定义
		$header= ['老师姓名','学生旺旺','学生姓名','学生微信','预约日期','预约时间段','课程名','操作类型','金额','代理客服','备注'];
		$excel->setActiveSheetIndex(0);
		//设置表名
		$excel->getActiveSheet()->setTitle($name);
		$excel->getActiveSheet()->getDefaultRowDimension()->setRowHeight(18);

		//列坐标
		$letter = ['A','B','C','D','E','F','G','H','I','J','K'];
		//生成表头
		for($i=0;$i<count($header);$i++){
			//设置表头值
			$excel->getActiveSheet()->setCellValue("$letter[$i]1",$header[$i]);
			//设置行高
			$excel->getActiveSheet()->getRowDimension(1)->setRowHeight(40);
			//设置表头字体样式
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setName('宋体');
			//设置表头字体大小
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setSize(13);
			//设置表头字体是否加粗
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->setBold(true);
			//设置表头文字水平居中
			$excel->getActiveSheet()->getStyle($letter[$i].'1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
			$excel->getActiveSheet()->getStyle($letter[$i].'1')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
			//设置单元格背景色
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFill()->getStartColor()->setARGB('FFFFFFFF');
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFill()->getStartColor()->setARGB('FF6DBA43');
			//设置字体颜色
			$excel->getActiveSheet()->getStyle("$letter[$i]1")->getFont()->getColor()->setARGB('FFFFFFFF');
		}

		$excel->getActiveSheet()->getColumnDimension("A")->setWidth(16);
		$excel->getActiveSheet()->getColumnDimension("B")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("C")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("D")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("E")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("F")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("G")->setWidth(44);
		$excel->getActiveSheet()->getColumnDimension("H")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("I")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("J")->setWidth(20);
		$excel->getActiveSheet()->getColumnDimension("K")->setWidth(20);

		//写入数据
			//从第二行开始写入数据（第一行为表头）

			$excel->getActiveSheet()->setCellValue('A'.(2),'real_name');
			$excel->getActiveSheet()->setCellValue('B'.(2),'want');
			$excel->getActiveSheet()->setCellValue('C'.(2),'english_name');
			$excel->getActiveSheet()->setCellValue('D'.(2),'wechat');
			$excel->getActiveSheet()->setCellValue('E'.(2),'reserve_date');
			$excel->getActiveSheet()->setCellValue('F'.(2),'period');
						$excel->getActiveSheet()->setCellValue('G'.(2),"口语预约");
				$excel->getActiveSheet()->setCellValue('H'.(2),' 口语预约 ');

			$excel->getActiveSheet()->setCellValue('I'.(2),'price');
			$excel->getActiveSheet()->setCellValue('J'.(2),'agent_name');
			$excel->getActiveSheet()->setCellValue('K'.(2),'remark');
		//清理缓冲区，避免中文乱码
		ob_end_clean();
		//导出数据
		$obj=new \PHPExcel_Writer_Excel5($excel);//实例化 将对象放入表格中
		header('Content-Type: applicationnd.ms-excel');
		header("Content-Disposition: attachment;filename=工资统计表.xls");
		header('Cache-Control: max-age=0');
		$obj->save('php://output');