php操作EXCEL(三)Excelの内容を読み取る

<meta charset="UTF-8">
/**
 * Created by PhpStorm.
 * User:     
 * Date: 2018/5/12
 * Time: 19:27
 */
$dir=dirname(__FILE__);   //          
require $dir.'/PHPExcel/PHPExcel/IOFactory.php';    //    excel     
$filename=$dir."/export_1.xls";                  //       xls  
$objPHPExcel=PHPExcel_IOFactory::load($filename);//    

#

      1：   

$sheetCount=$objPHPExcel->getSheetCount();//  excel       sheet
for($i=0;$i<$sheetCount;$i++){
    $data =$objPHPExcel->getSheet($i)->toArray();//    sheet              
    print_r($data);
}exit();

#  2：  PHPexcel                     ,     
     //               
foreach ($objPHPExcel->getWorksheetIterator() as $sheet){//     sheet
    foreach ($sheet->getRowIterator() as $row){//    
        //         ,         
        if($row->getRowIndex()<2){
            continue;
        }

        foreach ($row->getCellIterator() as $cell){ //    
            $data=$cell->getValue(); //       
            echo $data."";
            echo '';
        }
        echo '';
    }
}exit();