把数个EXCEL表导入数据库时,如果遇到有相同列数(比如列数都是B)怎么办?求大神解答~
部分代码如下
if ($highestColumn == B){
D('teacher')->execute('truncate table teacher');
for ($i = 2; $i <= $highestRow; $i++) {
$data['tno'] =$objPHPExcel->getActiveSheet()->getCell("A" . $i)->getValue();
$data['tname'] =$objPHPExcel->getActiveSheet()->getCell("B" .$i)->getValue();
D('teacher')->add($data);
}
$this->success('导入成功!');
}else if ($highestColumn == B){
D('course')->execute('truncate table course');
for ($i = 2; $i <= $highestRow; $i++) {
$data['CourseNo'] =$objPHPExcel->getActiveSheet()->getCell("A" . $i)->getValue();
$data['CourseName'] =$objPHPExcel->getActiveSheet()->getCell("B" .$i)->getValue();
D('course')->add($data);
}
$this->success('导入成功!');
}