有没有办法使用laravel EXCEL读取和修改EXCEL文件

如果还有其他人需要帮助，这对我很管用.

<?php

namespace App\Http\Controllers;

use App\Imports\FirstSheetImport;
use App\Imports\WorkingPaperImport;
use App\Models\Project;
use App\Models\WorkSheet;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Validator;
use Maatwebsite\Excel\Facades\Excel;

use PhpOffice\PhpSpreadsheet\Reader\Xlsx as ReaderXlsx;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx as WriterXlsx;

class WorkingPaperExportController extends Controller
{
    public function projectWorkingPaper(Request $request)
    {
        $data = $request->only('project_id');

        $rules = [
            'project_id' => 'required|exists:project_has_schedules,project_id',
        ];

        $validator = Validator::make($data, $rules);

        if ($validator->fails()) {
            return response()->json(['message' => $validator->errors()], 400);
        }

        $project = Project::with('masterSchedules')->find($data['project_id']);

        $activeSchedules = [];

        foreach ($project['masterSchedules'] as $schedule) {
            $activeSchedules[] = $schedule['id'];
        }

        $workSheetSymbols = [];

        foreach ($activeSchedules as $schedule_id) {
            $groupedSchedules = WorkSheet::where('schedule_id', $schedule_id)->get();

            foreach ($groupedSchedules as $individialSchedule) {
                $workSheetSymbols[] = $individialSchedule['symbol'];
            }
        }

        if ($workSheetSymbols) {

            // read the excel file here
            $templatePath = storage_path('app/template/workingpaper.xlsx');

            $reader = new ReaderXlsx();

            $spreadsheet = $reader->load($templatePath);

            $sheetNames = $spreadsheet->getSheetNames();

            $sheetIndex = array_search($workSheetSymbols[0], $sheetNames);                                                                                                                                                                                                                                           

            if ($sheetIndex !== false) {
                // get the desired worksheet
                $worksheet = $spreadsheet->getSheetByName($workSheetSymbols[0]);
                // add/change values accordingly
                $worksheet->setCellValue('Q10', '500250');

                $writer = new WriterXlsx($spreadsheet);

                $newFileName = 'hello.xlsx';
                $savePath = storage_path("app/workingpaper/{$newFileName}");
                $writer->save($savePath);

                return response()->download($savePath);
            }
        } else {
            return response()->json(['message' => 'No schedules found!'], 500);
        }
    }
}