php如何加载excel表格数据推荐

摘要： 从官网下载phpexcel文件包。下载地址：http://phpexcel.codeplex.com/releases/view/119187从数据库导出数据到excel文件代码：...

从官网下载phpexcel文件包。

下载地址：http://phpexcel.codeplex.com/releases/view/119187

从数据库导出数据到excel文件代码：

php<?php   include '../PHPExcel/PHPExcel.php';  //引入核心库文件    include '../PHPExcel/PHPExcel/Writer/Excel2007.php'; //引入excel2007操作类     include '../PHPExcel/PHPExcel/IOFactory.php';       $objPHPExcel = new PHPExcel(); //实例化phpexcel对象      //创建人   $objPHPExcel->getProperties()->setCreator("{$_SESSION['adminName']}");   //最后修改人   $objPHPExcel->getProperties()->setLastModifiedBy("{$_SESSION['adminName']}");   //标题   $objPHPExcel->getProperties()->setTitle("Office 2007 XLSX all user list Document");   //题目   $objPHPExcel->getProperties()->setSubject("Office 2007 XLSX all user list Document");   //描述   $objPHPExcel->getProperties()->setDescription("all user list");   //关键字   $objPHPExcel->getProperties()->setKeywords("all user list");   //种类   $objPHPExcel->getProperties()->setCategory("office document");              //设置当前的sheet   $objPHPExcel->setActiveSheetIndex(0);      //设置表头      $objPHPExcel->getActiveSheet()->setCellValue('A1', "用户名");     $objPHPExcel->getActiveSheet()->setCellValue('B1', "密码");   $objPHPExcel->getActiveSheet()->setCellValue('C1', "邮箱");   $objPHPExcel->getActiveSheet()->setCellValue('D1', "电话");   $objPHPExcel->getActiveSheet()->setCellValue('E1', "真实姓名");   $objPHPExcel->getActiveSheet()->setCellValue('F1', "注册时间");   $objPHPExcel->getActiveSheet()->setCellValue('G1', "ip来源");      $sql = "SELECT * FROM user"; 查询数据库所有数据    $res = $nsodb -> get_results($sql,ARRAY_A);      foreach($res as $key=>$val){ 把结果集进行遍历一行一行写入excel       $key+=2;             $objPHPExcel->getActiveSheet()->setCellValue('A'.$key, $val['uid']);            $objPHPExcel->getActiveSheet()->setCellValue('B'.$key, $val['password']);            $objPHPExcel->getActiveSheet()->setCellValue('C'.$key, $val['mail']);            $objPHPExcel->getActiveSheet()->setCellValue('D'.$key, $val['phone']);            $objPHPExcel->getActiveSheet()->setCellValue('E'.$key, $val['name']);       $objPHPExcel->getActiveSheet()->setCellValue('F'.$key, $val['add_time']);       $objPHPExcel->getActiveSheet()->setCellValue('G'.$key, $val['ipaddress']);   }   // 高置列的宽度       $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(30);     $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);     $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(30);     $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);   $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);    $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);    $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);         ob_end_clean(); //清除缓存防止乱码    header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');     header('Content-Disposition: attachment;filename="alluser.xlsx"'); //设置excel 文件名      header('Cache-Control: max-age=0');       $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');       $objWriter->save('php://output'); //保存     exit;?>