PHP導入Excel文件

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/>';  
    }