PHPExcel

最新推荐文章于 2021-03-22 23:27:20 发布

sugang_ximi

最新推荐文章于 2021-03-22 23:27:20 发布

阅读量835

点赞数

分类专栏： PHP 文章标签： excel phpexcel php读取Excel

本文链接：https://blog.csdn.net/sugang_ximi/article/details/45171931

版权

PHP 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

<?php
set_time_limit(0);  
require '/usr/www/job/inc/class/phpexcel/PHPExcel.php';  
  
// 设置缓存  
// $cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_apc;    
// $cacheSettings = array('cacheTime' => 600);  
// PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);  
// 读取excel  
$filename = '/usr/www/job/webdev/position_new/Controller/2012/myhome/register.xls';  
$objReader = PHPExcel_IOFactory::createReaderForFile($filename);  
$objReader->setReadDataOnly(true);  
$objPHPExcel = $objReader->load($filename);  
$objWorksheet = $objPHPExcel->getActiveSheet();  
foreach($objWorksheet->getRowIterator() as $i=>$row) {
    $cellIterator = $row->getCellIterator();  
    $cellIterator->setIterateOnlyExistingCells(false);  
      
    $companyName = $userName = '';  
    foreach($cellIterator as $k=>$cell) {  
        $cellValue = $cell->getValue();  
        if ( $k == 0 ) {  
            $companyName = trim(iconv('utf-8','gbk',$cellValue));  
        } else {  
            $userName = trim(iconv('utf-8','gbk',$cellValue));  
        }  
    }
}  
?>