file('file'); Storage::disk('local')->put('text.xlsx',file_get_contents($oFile)); $url = storage_path().'/app/text.xlsx'; $excel = PHPExcel_IOFactory::load($url); $sheet = $excel->getSheet(0); $row_num = $sheet->getHighestRow(); $data = []; for ($row = 2;$row <= $row_num;$row++){ $text = $excel->getActiveSheet()->getCell("A".$row)->getValue(); $length = mb_strlen($text); if ($length <= 510){ $data[]['text'] = $text; }elseif ($length > 510 && $length <= 1020){ $textArray = preg_split('/。/',$text); $count = count($textArray); $pos = ceil($count / 2); $text1 = ''; $text2 = ''; foreach ($textArray as $key => $item){ if ($key <= $pos){ $text1 .= $item.'。'; }else{ $text2 .= $item.'。'; } } $data[]['text'] = $text1; $data[]['text'] = $text2; }elseif ($length > 1020){ $textArray = preg_split('/。/',$text); $count = count($textArray); $pos = ceil($count / 3); $text1 = ''; $text2 = ''; $text3 = ''; foreach ($textArray as $key => $item){ if ($key <= $pos){ $text1 .= $item; }elseif($key <= $pos*2){ $text2 .= $item.'。'; }else{ $text3 .= $item.'。'; } } $data[]['text'] = $text1; $data[]['text'] = $text2; $data[]['text'] = $text3; } } TextLabel::query()->insert($data); return $this->response()->success('Success message...')->refresh(); } public function form() { $this->file('file', '请选择文件'); } public function html() { return <<导入EXCEL HTML; } }