phpExcel---自定义函数

require_once '../class/c_mysql.class.php'; $db = new c_mysql(); $sql = "select group_name,group_email,member_name,member_email,member_department from email_group;"; $db->connect(); $db->query($sql); $db->close(); while($row = $db->fetch_row()){ $data[] = $row; } $title = array('群组名称','群组邮箱','成员姓名','成员邮箱','成员所在部门'); /*****************函数调用*********************/function exportXlsx($title,$content){ require_once '../PHPExcel/PHPExcel.php'; require_once '../PHPExcel/PHPExcel/Writer/Excel2007.php'; //创建一个excel $objPHPExcel = new PHPExcel(); //保存excel—2007格式 $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel); //向excel中插入数据 $letter = range("A","Z"); $row = 2;//从第二行开始插入数据，预留出第一行插入列名 foreach($content as $line){ $i = 0; foreach($line as $cell){ $objPHPExcel->getActiveSheet()->setCellValue($letter[$i] . $row, $cell); $i++; } $row++; } //将标题输入到excel中 foreach($title as $key => $cell){ $objPHPExcel->getActiveSheet()->setCellValue($letter[$key] . '1', $cell); } //设置宽width $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(40); $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30); $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35); $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(35); $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(100); //第一行居中，其他行默认 foreach($title as $key => $cell){ $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . '1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . '1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . '1')->getFill()->getStartColor()->setARGB('FFC3C3C3'); //设置border的color $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . '1')->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . '1')->getBorders()->getAllBorders()->getColor()->setARGB('FF000000'); } //给其他行填充颜色 $line_count = count($content) + 2; foreach($title as $key => $cell){ //设置border的color for($i=2;$igetActiveSheet()->getStyle($letter[$key] . $i)->getBorders()->getAllBorders()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN); $objPHPExcel->getActiveSheet()->getStyle($letter[$key] . $i)->getBorders()->getAllBorders()->getColor()->setARGB('FF000000'); } } header("Pragma: public"); header("Expires: 0"); header("Cache-Control:must-revalidate, post-check=0, pre-check=0"); header("Content-Type:application/force-download"); header("Content-Type:application/vnd.ms-execl"); header("Content-Type:application/octet-stream"); header("Content-Type:application/download"); $filename = '群组信息.xlsx'; $filename = iconv('UTF-8','GB2312',$filename); header("Content-Disposition:attachment;filename=$filename"); header("Content-Transfer-Encoding:binary"); $objWriter->save('php://output'); }