phpexcel 读取excel文件在将数据插入数据库

public function acIndex(){$fileName = "C:\Users\**\Desktop\省市区编码 .xlsx";if (!file_exists($fileName)) {exit("文件" . $fileName . "不存在");}$objPHPExcel = PHPExcel_IOFactory::load($fileName);$sheetCount = $objPHPExcel->getSheetCount();$sheetSelected = 0;$objPHPExcel->setActiveSheetIndex($sheetSelected);$rowCount = $objPHPExcel->getActiveSheet()->getHighestRow();$columnCount = $objPHPExcel->getActiveSheet()->getHighestColumn();$dataArr = array();for ($row = 1; $row <= $rowCount; $row++) {//列数循环 , 列数是以A列开始for ($column = 'A'; $column <= $columnCount; $column++) {$dataArr[] = $objPHPExcel->getActiveSheet()->getCell($column . $row)->getValue();}}$sqlData = [[]];//根据自己的列表情况处理数据for ($i=2547,$j=0;$i<=count($dataArr);$i+=6,$j++){$sqlData[$j]['province_name']=$dataArr[$i];$sqlData[$j]['province_id']=$dataArr[$i+1];$sqlData[$j]['city_name']=$dataArr[$i+2];$sqlData[$j]['city_id']=$dataArr[$i+3];$sqlData[$j]['county_name']=$dataArr[$i+4];$sqlData[$j]['county_id']=$dataArr[$i+5];}var_dump($sqlData);//直接处理sqlData}