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
}