您好,欢迎访问一九零五行业门户网

phpexcel导入小例子

小实例,新人中的新人。请多多指教
_upload();               
                if($filename){                 
                $file='./public/upload/excel/'.date('ymd').'/'.$filename; 
                 //导入excel类                 
                 vendor('phpexcel.phpexcel');                 
                 vendor('phpexcel.phpexcel.iofactory');                 
                 vendor('phpexcel.phpexcel.reader.excel5');                 
                 vendor('phpexcel.phpexcel.reader.excel2007'); 
 /* require_once './thinkphp/extend/library/org/net/phpexcel.class.php'; require_once './thinkphp/extend/library/org/net/phpexcel/iofactory.php'; require_once './thinkphp/extend/library/org/net/phpexcel/reader/excel5.php';*/                       
                 /*获取excel文件类型,确定版本*/                 
                 $extend=pathinfo($file);                 
                 $extend = strtolower($extend[extension]);                 
                 $extend=='xlsx'?$reader_type='excel2007':$reader_type='excel5';                 
                 $objreader = phpexcel_iofactory::createreader($reader_type);                 
                 if(!$objreader){                     
                 $this->error('抱歉!excel文件不兼容。'); //执行失败,直接抛出错误中断                 
                 }                 
                 $objphpexcel= $objreader->load($file);                  
                 $objworksheet= $objphpexcel->getactivesheet();                 
                 $highestrow= $objworksheet->gethighestrow();                   
                 $highestcolumn = $objworksheet->gethighestcolumn();                  
                 $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn);//总列数                 
                 $headtitle =array();                 
                 for($cols =0 ;$colsgetcellbycolumnandrow($cols, 1)->getvalue();                  
                 }                 
                 if(empty($headtitle[0])){
                       for($cols =0 ;$cols                       $headtitle[$cols] =(string)$objworksheet->getcellbycolumnandrow($cols, 2)->getvalue();                     
                       }                 
                 }                                          
                 $strs=array();                             
                 /*第二行开始读取*/                 
                 for ($row =2;$row                      for($cols =0 ;$cols                     $strs[$row][$cols] =(string)$objworksheet->getcellbycolumnandrow($cols, $row)->getvalue();                     
                     }                 
                 }                 
                 dump($strs);//显示结果             
             }         
         }     
     }
ad:真正免费,域名+虚机+企业邮箱=0元
其它类似信息

推荐信息