小实例,新人中的新人。请多多指教
_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元
