php如何批量导入excel表格文件

2025-04-02 07:26:47
推荐回答(1个)
回答1:

$data = new Spreadsheet_Excel_Reader();//实例化    
02                $data->setOutputEncoding('utf-8');//设置读取编码    
03                $data->read($p);//$p就是excel文件路径    
04                     
05                for ($i = 2; $i <= $data->sheets[0]['numRows']; $i++) {    
06                    //传如数组,将一行信息写入数据库;    
07                    $arr = $data->sheets[0]['cells'][$i];    
08                    if($arr){    
09                        $r = addUserLine($arr,$posts['bid']);    
10                        if($r){    
11                        echo "楼栋:".$r['bldgname']." 房间:".$r['roomname']." 学员:".$r['name']." 学号:".$r['sid']." 导入成功";    
12                        }else{    
13                            echo "";    
14                        }    
15                    }    
16                }