phpexcel导入数据

绝地灬酷狼 2022-05-30 09:37 279阅读 0赞

$filename = $_FILES['file']['name'];
    $tmp_name = $_FILES['file']['tmp_name'];
    $msg = uploadFile($filename,$tmp_name)
    if ($msg) {
       echo '上传成功';
    } else {
        echo '上传失败';
    }
    
    function uploadFile($file, $filetempname)
    {
        
        //自己设置的上传文件存放路径
        $filePath = 'upFile/';
        $str = "";
        //注意设置时区
        $time=date("ymdHis");//去当前上传的时间
        //获取上传文件的扩展名
        $extend=strrchr ($file,'.');
        //上传后的文件名
        $name=$time.$extend;
        $uploadfile=$filePath.$name;//上传后的文件名地址
        //move_uploaded_file() 函数将上传的文件移动到新位置。若成功，则返回 true，否则返回 false。
        $result = move_uploaded_file($filetempname,$uploadfile);//假如上传到当前目录下
        if($result) //如果上传文件成功，就执行导入excel操作
        {
    
            $objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format
            $objPHPExcel = $objReader->load($uploadfile);
            $sheet = $objPHPExcel->getSheet(0);
            $highestRow = $sheet->getHighestRow();           //取得总行数
            $highestColumn = $sheet->getHighestColumn(); //取得总列数
            $objWorksheet = $objPHPExcel->getActiveSheet();
            $highestRow = $objWorksheet->getHighestRow();
    
            $highestColumn = $objWorksheet->getHighestColumn();
            $highestColumnIndex = PHPExcel_Cell::columnIndexFromString($highestColumn);//总列数
    
            $headtitle=array();
            for($row = 2;$row <= $highestRow;$row++)
            {
                $strs=array();
                //注意highestColumnIndex的列数索引从0开始
                for ($col = 0;$col < $highestColumnIndex;$col++)
                {
                    $strs[$col] =$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
                }
            }
            unlink($uploadfile); //删除上传的excel文件
            $msg = 1;
        } else {
            $msg = 0;
        }
        return $msg;
    }