一个很初级的实例,也是常用的方法;
case "daochu": date_default_timezone_set('Asia/Shanghai'); require "include/PHPExcel.php"; $dir=dirname(__FILE__); $objPHPExcel=new PHPExcel(); $objSheet=$objPHPExcel->getActiveSheet(); $objSheet->setTitle("账单"); // $objSheet->setCellValue("A1","张三")->setCellValue("B1","分数"); $sql = "SELECT `id`, `mingcheng`, `jine`, `time`, `jingban`, `didian`, `fukuan`, `sfxx` FROM `jizhang` LIMIT 0, 30 "; $result=$conn->query($sql); $objSheet->setCellValue("A1","编号")->setCellValue("B1","名称")->setCellValue("C1","金额")->setCellValue("D1","时间")->setCellValue("E1","经办人")->setCellValue("F1","地点")->setCellValue("G1","是否付款")->setCellValue("H1","是否学校支出"); $i=2; while (list($id,$mingcheng,$jine,$time,$jingban,$didian,$fukuan,$sfxx)=$result->fetch_row()){ $objSheet->setCellValue("A$i","$id")->setCellValue("B$i","$mingcheng")->setCellValue("C$i","$jine")->setCellValue("D$i","$time")->setCellValue("E$i","$jingban")->setCellValue("F$i","$didian")->setCellValue("G$i","$fukuan")->setCellValue("H1","$sfxx"); $i++; } $objwriter=PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007"); brower_export('Excel2007','zhangdan.xlsx'); $objwriter->save("php://output"); // $objwriter->save($dir."/zhangdan.xlsx"); break;
function brower_export($type,$filename){ if ($type=="Excel5"){ header('Content-Type: application/vnd.ms-excel'); }else{ header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); } header('Content-Disposition: attachment;filename="'.$filename.'"'); header('Cache-Control: max-age=0'); }
文章评论