xxxxxxxxxx
public function upload(Request $request)
{
$file = $request->file('file');
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx();
$reader->setReadDataOnly(true);
$spreadsheet = $reader->load($file);
$sheet = $spreadsheet->getSheet(0)->toArray();
$one = $sheet[0];
unset($sheet[0]);
$array = [];
foreach ($sheet as $row) {
if (!is_null($row[1])) {
$array[] = array_combine($one, $row);
}
}
return response()->json($array, 200, [], JSON_UNESCAPED_UNICODE);
}