PHP导入Excel文件

清华大佬耗费三个月吐血整理的几百G的资源,免费分享!....>>>

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