PHPExcel导入文件步骤:
1.实例化excel读取对象
2.加载excel文件
全部加载
选择加载
3.读取excel文件
全部读取
逐行读取
代码:
- <?php
- header("Content-Type:text/html;charset=utf-8");
- $dir = dirname(__FILE__);
- require $dir.'/PHPExcel/IOFactory.php';
- $filename = $dir."/export.xls";
- //部分加载
- $fileType = PHPExcel_IOFactory::identify($filename);
- $objReader = PHPExcel_IOFactory::createReader($fileType);
- $sheetName = array("Worksheet 1");
- $objReader->setLoadSheetsOnly($sheetName);
- $objPHPExcel = $objReader->load($filename);
- //全部加载
- //$objPHPExcel = PHPExcel_IOFactory::load($filename); //加载文件
- //全部读取
- /*
- $sheetCount = $objPHPExcel->getSheetCount();
- for($i=0; $i<$sheetCount; $i++){
- $data = $objPHPExcel->getSheet($i)->toArray(); //读取数据到数组
- var_dump($data);
- }*/
- //逐行读取
- foreach($objPHPExcel->getWorkSheetIterator() as $sheet){
- foreach($sheet->getRowIterator() as $row){
- if($row->getRowIndex() < 2) continue; //忽略第一行
- foreach ($row->getCellIterator() as $cell) {
- $data = $cell->getValue();
- echo $data.' ';
- }
- echo '<br/>';
- }
- echo '<br/><hr/>';
- }
来源: http://www.phpxs.com/code/1002916/