亚洲在线久爱草,狠狠天天香蕉网,天天搞日日干久草,伊人亚洲日本欧美

<!--?使用PHPExcel導出文件代碼實現，PHPExcel探索之旅教程-慕課網?-->

<!--?視頻教程地址：http://www.xianlaiwan.cn/video/8364?-->

<?php

$dir=dirname(__FILE__);?//找到當前腳本所在目錄

require?$dir."/PHPExcel/PHPExcel.php";?//加載文件

$objPHPExcel=new?PHPExcel();?//?實例化PHPEXcel類，等同于在桌面上新建一個excel表格

$objSheet=$objPHPExcel->getActiveSheet();?//?獲得當前活動sheet的操作對象

$objSheet->setTitle("demo");//?給當前活動Sheet設置名稱，即工作表名

$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分數");//?給當前活動Sheet填充數據

$objSheet->setCellValue("A2","張三")->setCellValue("B2","68");

$objSheet->setCellValue("A3","李四")->setCellValue("B3","80");

$objSheet->setCellValue("A4","王五")->setCellValue("B4","78");

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel2007");//?按照指定格式生成excel文件。

$objWriter->save($dir."/demo.xlsx");

?>

3-2 使用PHPExcel導出文件代碼實現

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分數');

$objSheet->setCellValue('A2','張三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

3-2 使用PHPExcel導出文件代碼實現

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分數');

$objSheet->setCellValue('A2','張三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

筆記：導出步驟

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分數');

$objSheet->setCellValue('A2','張三')->setCellValue('B2','100');

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,'Excel2007');

$objWriter->save($dir.'demo.xlsx');

老師的邏輯好強大

1，引入數據庫

2，引入PHPExcel

3,實例化數據庫 并傳入數據庫配置參數

4，實例化PHPExcel類

$objPHPExcel = new PHPExcel();//等同于在桌面新建一個excel

5，新建內置表 根據數據庫數據可以建幾個內置表

6，創建新內置表

$objPHPExcel->createSheet();

7，把新創建的sheet設定為當前sheet 再循環里用

$objPHPExcel->setActiveSheetIndex($i-1);

8，獲取當前活動sheet

$objSheet = $objPHPExcel->getActiveSheet();

9，查詢數據庫數據存入表中

設置每個sheet的名字

$objSheet->setTitle('excel_'.$i);

設置A1行

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分數')；

10，填充數據

11，生成excel文件 保存

$objWrite=PHPExcel_IOFactory::createWrite($objPHPExcel,'Excel5');

$objWrite->save($dir.'/export_1.xls');

mark !!!

PHPExcel導入文件,讀取Excel數據