mysql导入excel为什么丢行_Excel导入mysql数据丢掉

Excel导入mysql数据丢失

昨天晚上弄了一个晚上都没解决，来这里求助下，谢谢各位了

for($j=3;$j<=$highestRow;$j++)//表头不读取

{

$a = $objPHPExcel->getActiveSheet()->getCell("A".$j)->getValue();

$a=iconv("UTF-8","GBK//IGNORE",$a);//转码

$b = $objPHPExcel->getActiveSheet()->getCell("B".$j)->getValue();

$b=iconv("UTF-8","GBK//IGNORE",$b);//转码

//$c = $objPHPExcel->getActiveSheet()->getCell("C".$j)->getValue();

//$d = $objPHPExcel->getActiveSheet()->getCell("D".$j)->getValue();

//$e = $objPHPExcel->getActiveSheet()->getCell("E".$j)->getValue();

$sql = "INSERT INTO paee_course VALUES('".$a."','".$b."')";//,".$c.",".$d.",".$e."

echo $sql."$j&#