$data = $request->post();
if(empty($data['month'])){
return json(['code'=>201,'date'=>'','message'=>'考勤月份不能为空']);
}
if(empty($data['excelUel'])){
return json(['code'=>201,'date'=>'','message'=>'上传文件不能为空']);
}
$filename = "storage/{$data['excelUel']}";
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
//开启只读模式
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($filename);
$sheet = $spreadsheet->getSheet(0);
//获取当前总行数
$rows = $sheet->getHighestRow();
// 取得总列数
$highestColumn = $sheet->getHighestColumn();
$users = [];
for($i = 1; $i <= $rows; $i++) {
$temp = [];
$temp['name'] = $sheet->getCell('A' . $i)->getValue();
$temp['sex'] = $sheet->getCell('B' . $i)->getValue();
$temp['age'] = $sheet->getCell('C' . $i)->getValue();
# 防止空行情况
if (!$temp['name']) {
continue;
}
$users[] = $temp;
}
return json(['code'=>200,'date'=>$highestColumn,'dades'=>$users,'message'=>'导入成功']);
11-17
2228
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
11-08
4643
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)