跳至 [1] [全屏预览] load(mb.xlsx); // 载入excel文件$sheet = $phpexcel->getsheet(0); // 读取第一個工作表$highestrow = $sheet->gethighestrow(); // 取得总行数$highestcolumm = $sheet->gethighestcolumn(); // 取得总列数//1.导入配置文件require(conf/dbconfig.php);//2.连接mysql、并选择数据库$link = @mysql_connect(host, user, pass) or die(数据库连接失败！);mysql_select_db(dbname, $link);//循环读取excel文件,读取一条,插入一条for ($j = 2; $j getactivesheet()->getcell(a . $j)->getvalue();//获取a列的值 $telephone = $phpexcel->getactivesheet()->getcell(b . $j)->getvalue();//获取b列的值 $fenzu = $phpexcel->getactivesheet()->getcell(c . $j)->getvalue();//获取c列的值 $school = $phpexcel->getactivesheet()->getcell(d . $j)->getvalue();//获取d列的值 $banji = $phpexcel->getactivesheet()->getcell(e . $j)->getvalue();//获取e列的值 $sql = insert into `drtable`(`id`, `name`, `telephone`, `fenzu`, `school`, `banji`) values (null,'{$name}','{$telephone}','{$fenzu}','{$school}','{$banji}'); mysql_query($sql, $link); echo $sql;}?>