php读取excel

<?php
require_once "PHPExcel\PHPExcel.php";
 
//读数据
$filename = 'C:\wamp\www\aa\2.xls';
$objReader = PHPExcel_IOFactory::createReaderForFile($filename);; //准备打开文件
$objPHPExcel = $objReader->load($filename);   //载入文件
$objPHPExcel->setActiveSheetIndex(0);         //设置第一个Sheet
$data = $objPHPExcel->getActiveSheet()->getCell('A2')->getValue();  //获取单元格A2的值
echo $data;



foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {     //遍历工作表
       echo 'Worksheet - ' , $worksheet->getTitle() ; echo '<br/>';
       foreach ($worksheet->getRowIterator() as $row) {       //遍历行
             echo '    Row number - ' , $row->getRowIndex() ;echo '<br/>';
            $cellIterator = $row->getCellIterator();   //得到所有列
            $cellIterator->setIterateOnlyExistingCells( false); // Loop all cells, even if it is not set
             foreach ($cellIterator as $cell) {  //遍历列
                   if (!is_null($cell)) {  //如果列不给空就得到它的坐标和计算的值
                         echo '        Cell - ' , $cell->getCoordinate() , ' - ' , $cell->getCalculatedValue();echo '<br/>';
                  }
            }
      }
}



 
?>