毛宏钢

导航

excel库中数据下载

PHP实现EXCEL下载数据

 

 1 <?php
 2 include("Classes/PHPExcel.php");
 3 $exce=new PHPExcel();
 4 $exce->setActiveSheetIndex(0)->setCellValue("A1","id")->setCellValue("B1","conte")->setCellValue("C1","num")->setCellValue("D1","dat")->setCellValue("F1","title")->setCellValue("G1","author");
 5 $pdo=new PDO("mysql:host=127.0.0.1;dbname=testz","root","root");
 6 $data=$pdo->query("select*from book")->fetchAll();
 7 foreach($data as $k=>$v){
 8 $exce->setActiveSheetIndex(0)->setCellValue("A".($k+2),$v['id'])
 9 ->setCellValue("B".($k+2),$v['conte'])
10 ->setCellValue("C".($k+2),$v['num'])
11 ->setCellValue("D".($k+2),$v['dat'])
12 ->setCellValue("E".($k+2),$v['title'])
13 ->setCellValue("F".($k+2),$v['author']);
14 }
15 
16 header('Content-Disposition: attachment;filename="01simple.xls"');
17 header ('Pragma: public'); // HTTP/1.0
18 
19 $objWriter = PHPExcel_IOFactory::createWriter($exce, 'Excel5');
20 $objWriter->save('php://output');
21 exit;
22 
23 ?>

 

posted on 2019-07-16 14:37  毛宏钢  阅读(105)  评论(0)    收藏  举报