use app\models\execl;
use \PHPExcel;
/*execl导入数据*/
public function Execlupload(){
if(Yii::$app->request->isPost){
$tmp_file = $_FILES ['execl'] ['tmp_name'];
$file_types = explode ( ".", $_FILES ['execl'] ['name'] );
$file_type = $file_types [count ( $file_types ) - 1];
if (strtolower ( $file_type ) != "xlsx"){
return 4;/*文件类型错误*/
}
$savePath = "execlupload/";/*存储地址*/
$str = date ( 'ymdhis' );
$file_name = $str . "." . $file_type;
if(!@move_uploaded_file($tmp_file,$savePath.$file_name)){
return 3;/*上传失败*/
}else{
$objPHPExcel = new \PHPExcel;
$objReader = \PHPExcel_IOFactory::createReader("Excel2007"); //创建读入器Excel5
$excelFile = dirname(dirname(__FILE__)).'/web/execlupload/'.$file_name;//获得文件绝对路径
$objExcel = $objReader->load($excelFile,'UTF-8'); //加载文件
$sheet = $objExcel->getSheet(0);
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
if($highestRow>1){
for($row = 2;$row <= $highestRow; $row++){
$data = array();
for($column = 'A'; $column <= $highestColumn; $column++){
$data[] = trim($sheet->getCell($column.$row)->getValue());
}
$data1 = $data[0];/*进行入库操作*/
if($data){
$ok = 1;
}
}
if($ok==1){
//导入成功 删除文件
unlink($excelFile);
return 1;/*成功*/
}else{
return 2;/*失败*/
}
}
}
}
}