public function daoru(){
$file = request()->file('excel');
$info = $file->move(ROOT_PATH . 'public' . DS . 'uploads' . DS . 'excel');
$path = ROOT_PATH . 'public' . DS . 'uploads' . DS . 'excel/' . $info->getSaveName();
Vendor('PHPExcel.PHPExcel');
$objReader = new \PHPExcel_Reader_Excel2007();
//$path='00001.xlsx';
$objPHPExcel = $objReader->load($path,$encode='utf-8');//获取excel文件
$sheet = $objPHPExcel->getSheet(0); //激活当前的表
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$a=0;
//将表格里面的数据循环到数组中
for($i=2;$i<=$highestRow;$i++)
{
//*从第二行开始
$data[$a]['data'] = $objPHPExcel->getActiveSheet()->getCell("A".$i)->getValue();
$data[$a]['qubu'] = $objPHPExcel->getActiveSheet()->getCell("B".$i)->getValue();
$data[$a]['tuandui'] = $objPHPExcel->getActiveSheet()->getCell("C".$i)->getValue();
$data[$a]['tsr'] = $objPHPExcel->getActiveSheet()->getCell("D".$i)->getValue();
$data[$a]['zhiji'] = $objPHPExcel->getActiveSheet()->getCell("E".$i)->getValue();
$data[$a]['toubao'] = $objPHPExcel->getActiveSheet()->getCell("F".$i)->getValue();
$data[$a]['beibaoren'] = $objPHPExcel->getActiveSheet()->getCell("G".$i)->getValue();
$data[$a]['beifei'] = $objPHPExcel->getActiveSheet()->getCell("H".$i)->getValue();
$data[$a]['mingc'] = $objPHPExcel->getActiveSheet()->getCell("I".$i)->getValue();
$data[$a]['order'] = $objPHPExcel->getActiveSheet()->getCell("J".$i)->getValue();
$data[$a]['ststus'] = $objPHPExcel->getActiveSheet()->getCell("K".$i)->getValue();
// 这里的数据根据自己表格里面有多少个字段自行决定
$a++;
}
//往数据库添加数据
dump($data);die;
}
thinkPHP5使用PHPExcel导入表格数据
于 2022-05-09 15:49:37 首次发布