将每个重复5行中给定的excel数据导入到数据库中的一行。Laravel 5.8

use PhpOffice\PhpSpreadsheet\IOFactory;
use App\YourModel;

$spreadsheet = IOFactory::load('path/to/your/file.xlsx');
$worksheet = $spreadsheet->getActiveSheet();
$data = [];

foreach ($worksheet->getRowIterator() as $row) {
    $cellIterator = $row->getCellIterator();
    $cellIterator->setIterateOnlyExistingCells(false);
    $rowData = [];

    foreach ($cellIterator as $cell) {
        $rowData[] = $cell->getValue();
    }

    $data[] = $rowData;
}

$processedData = [];
$i = 0;

while ($i < count($data)) {
    $group = array_slice($data, $i, 5);
    $mergedRow = [];

    foreach ($group[0] as $key => $value) {
        $mergedValue = implode(' | ', array_column($group, $key));
        $mergedRow[$key] = $mergedValue;
    }

    $processedData[] = $mergedRow;
    $i += 5;
}

foreach ($processedData as $row) {
    YourModel::create($row);
}