PHP利用phpexcel导入Excel表到Mysql数据库

<?php 
 require_once 'PHPExcel.php';
 require_once 'PHPExcel/IOFactory.php';
 require_once 'PHPExcel/Reader/Excel5.php';
 //以上三步加载phpExcel的类
 $objReader = PHPExcel_IOFactory::createReader('Excel5');//use excel2007 for 2007 format
 $filename="1.xls";//指定excel文件从上传中取出
 $objPHPExcel = $objReader->load($filename); //$filename可以是上传的文件，或者是指定的文件
 $sheet = $objPHPExcel->getSheet(0);
 $highestRow = $sheet->getHighestRow(); // 取得总行数
 $highestColumn = $sheet->getHighestColumn(); // 取得总列数
 $k = 0;
 //循环读取excel文件,读取一条,插入一条
 //j表示从哪一行开始读取
 //$a表示列号
 $conn = mysqli_connect($servername, $username, $password, $dbname); //连接数据库，自己修改即可
 mysqli_set_charset($coon, "utf8"); //设置字符utf-8
 for($j=2;$j&lt;=$highestRow;$j++) //j=2是因为第一行表为提示，从第二行开始取 { 
 $a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();//获取A列的值
 $b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();//获取B列的值
 $c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();//获取C列的值
 $sql = "INSERT INTO kt (ktname,ktform,ktteacher)
 VALUES ('$a','$b','$c')"; //插入数据库
 $result = mysqli_query($conn, $sql);
 if($result){
 $sta="ok";
 }
 else{
 $sta="on";
 }
 }
 if($sta=="ok"){
 echo '<script>alert("数据导入成功！");window.location.href="xk_change.php";</script>';
 }}
 $filename = $pwd;
 fopen($filename,'a+');
 unlink($filename);
 ?>