$errors = array();
//检查上传的文件是否符合规则
if(empty($_FILES['centerinfofile']['name'])){
$errors['nofile']='请选择上传文件';
$this->error('请选择上传文件');
}
//判断文件扩展名
$fil_extendname = strtolower(end(explode('.',basename($_FILES['centerinfofile']['name']))));
if($fil_extendname!='xls'){
$errors['errorfile']='文件类型错误,请选择EXCEL';
$this->error('文件类型错误,请选择EXCEL');
}
//检查文件名格式
$length = strpos($_FILES['centerinfofile']['name'],'.');
$point = strpos($_FILES['centerinfofile']['name'],'.',$length+1);
if($point){
$errors['point']='文件名中不可以有 .';
$this->error('文件名中不可以有 .');
}
Vendor("PHPExcel.PHPExcel");
//服务器上的临时文件名
$temp_filename = substr($_FILES['centerinfofile']['name'],0,$length);
//对文件名进行编码
$filename=iconv("utf-8","gb2312",$_FILES['centerinfofile']['name']);
$path = 'Upload/recruitStuTmp/'.$filename;
$flag = move_uploaded_file($_FILES['centerinfofile']['tmp_name'], 'Upload/recruitStuTmp/'.$filename);
if($flag){
require_once 'Classes/PHPExcel/IOFactory.php';
$peReader = new PHPExcel_Reader_Excel5();
$pe = $peReader->load($path); //读取的表
$sheet = $pe->getActiveSheet($path);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数 (英文字母)
//防止用户开启多余的新行,重新统计最大行数
for($count = 4;$countgetCellByColumnAndRow(2, $count)->getValue();
if(empty($tmpVal)){
$highestRow = $count;
break;
}[code="java"][/code]
}
//$sheet->getCellByColumnAndRow(2, $row)->getValue();
}else{
//error
}
try{
//操作结束后删除上传的Excel
unlink($path);
}catch (Exception $e){
}