时间:2021-07-01 10:21:17 帮助过:13人阅读
使用PHPExcel导出文件
首先看看上面的文章,写入方法一样,只是中间多了数据库的操作,后面还有excel浏览器输出。
数据库代码(数据库配置文件自行完成)
conn=mysql_connect($config['host'],$config['username'],$config['password']) or die(mysql_error()); mysql_select_db($config['database'],$this->conn) or die(mysql_error()); mysql_query(set names .$config['charset']) or die(mysql_error()); } public function getResult($sql){ $resource = mysql_query($sql,$this->conn) or die(mysql_error()); $res = array(); while(($row=mysql_fetch_assoc($resource))!=false){ $res[] = $row; } return $res; } public function getUserinfo(){ $sql = 。。。; $res = self::getResult($sql); return $res; } }
数据库导出代码:
0){ $objPHPExcel->createSheet(); } $objPHPExcel->setActiveSheetIndex($i); $objSheet = $objPHPExcel->getActiveSheet(); $data = $db->getUserinfo(); $objSheet->setCellValue(A1,编号)->setCellValue(B1,登陆名) ->setCellValue(C1,昵称)->setCellValue(D1,电子邮箱) ->setCellValue(E1,学校)->setCellValue(F1,最后登陆时间); $j = 2; foreach ($data as $key => $value) { # code... $objSheet->setCellValue(A.$j,$value['id'])->setCellValue(B.$j,$value['user_login']) ->setCellValue(C.$j,$value['user_nicename'])->setCellValue(D.$j,$value['user_email']) ->setCellValue(E.$j,$value['sch_name'])->setCellValue(F.$j,$value['last_login_time']); $j++; } } $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel,Excel5); // $objWriter->save($dir.'/export.xls'); //生成excel文件 browser_export(Excel5,browser_excel03.xls); //浏览器输出 $objWriter->save(php://output); function browser_export($type, $filename){ if($type == Excel5){ header('Content-Type: application/vnd.ms-excel'); //excel2003 }else{ header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); //excel2007 } header('Content-Disposition: attachment;filename='.$filename.''); header('Cache-Control: max-age=0'); }
http://www.bkjia.com/PHPjc/1047175.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/1047175.htmlTechArticlePHPExcel导出mysql数据库数据 使用PHPExcel导出文件 首先看看上面的文章,写入方法一样,只是中间多了数据库的操作,后面还有excel浏览器输出...