第七色在线视频,2021少妇久久久久久久久久,亚洲欧洲精品成人久久av18,亚洲国产精品特色大片观看完整版,孙宇晨将参加特朗普的晚宴

<!--?使用PHPExcel導(dǎo)出文件代碼實現(xiàn)，PHPExcel探索之旅教程-慕課網(wǎng)?-->

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

<?php

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

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

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

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

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

$objSheet->setCellValue("A1","姓名")->setCellValue("B1","分?jǐn)?shù)");//?給當(dāng)前活動Sheet填充數(shù)據(jù)

$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導(dǎo)出文件代碼實現(xiàn)

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分?jǐn)?shù)');

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

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

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

3-2 使用PHPExcel導(dǎo)出文件代碼實現(xiàn)

2018-11-14

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分?jǐn)?shù)');

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

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

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

筆記：導(dǎo)出步驟

$dir=dirname(__FILE__);

$objPHPExcel= new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle('demo');

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分?jǐn)?shù)');

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

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

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

老師的邏輯好強(qiáng)大

1，引入數(shù)據(jù)庫

2，引入PHPExcel

3,實例化數(shù)據(jù)庫 并傳入數(shù)據(jù)庫配置參數(shù)

4，實例化PHPExcel類

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

5，新建內(nèi)置表 根據(jù)數(shù)據(jù)庫數(shù)據(jù)可以建幾個內(nèi)置表

6，創(chuàng)建新內(nèi)置表

$objPHPExcel->createSheet();

7，把新創(chuàng)建的sheet設(shè)定為當(dāng)前sheet 再循環(huán)里用

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

8，獲取當(dāng)前活動sheet

$objSheet = $objPHPExcel->getActiveSheet();

9，查詢數(shù)據(jù)庫數(shù)據(jù)存入表中

設(shè)置每個sheet的名字

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

設(shè)置A1行

$objSheet->setCellValue('A1','姓名')->setCellValue('B1','分?jǐn)?shù)')；

10，填充數(shù)據(jù)

11，生成excel文件 保存

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

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

mark !!!

PHPExcel導(dǎo)入文件,讀取Excel數(shù)據(jù)