Create upload file test with laravel excel

Hi everyone,

I use Spatie Laravel Data and maatwebsite Laravel Excel.

My test need use specific xlsx file stored inside my tests folder. I've seen a lot of test used fake files but I can't use one because it's special template.

I try to create test to upload file with Laravel Excel. But I always this error :

   FAIL  Tests\Feature\Pages\Settings\Preparation\CreateTest
  ⨯ it can import an preparation list                                                                                                     0.57s  
  ✓ it can not possible to upload a file with a wrong format                                                                              0.38s  
  ─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────  
   FAILED  Tests\Feature\Pages\Settings\Preparation\CreateTest > it can import an preparation list                         ValidationException   
  The file field must be a file.

  at vendor/laravel/framework/src/Illuminate/Support/helpers.php:328
    324▕     function throw_if($condition, $exception = 'RuntimeException', ...$parameters)
    325▕     {
    326▕         if ($condition) {
    327▕             if (is_string($exception) && class_exists($exception)) {
  ➜ 328▕                 $exception = new $exception(...$parameters);
    329▕             }
    330▕ 
    331▕             throw is_string($exception) ? new RuntimeException($exception) : $exception;
    332▕         }

      +3 vendor frames 
  4   app/Http/Controllers/PreparationController.php:28
      +52 vendor frames 
  57  tests/Feature/Pages/Settings/Preparation/CreateTest.php:24


  Tests:    1 failed, 1 passed (2 assertions)
  Duration: 1.06s

My test :

it('can import an preparation list', function () {
    Excel::fake();
    $preparation = new UploadedFile(
        preparationListPath(),
        'preparation.xlsx',
        'application/vnd.ms-excel.sheet.macroenabled.12',
        null,
        true
    );

    $this->withoutExceptionHandling();

    asAdmin()->post(action([PreparationController::class, 'store']), [
        'file' => $preparation,
    ])->assertRedirect(action([PreparationController::class, 'edit'], ['preparation' => 1]));

    assertDatabaseCount('preparations', 1);
})->only();

Tests Helpers :

function preparationListPath(): string
{
    return base_path('tests/Files/preparation.xlsx');
}

Controller store function :

 public function store(CreatePreparationFormRequestData $request): RedirectResponse
    {
        $request->validate([
            'file' => 'mimes:xlsx,xls,csv,xlsm',
        ]);

        Excel::import(new FirstSheetImport, $request->file);

        toast('Fichier importé', 'Le fichier a bien été importé.');

        return Redirect::action([PreparationController::class, 'edit'], ['preparation' => 1]);
    }

DTO :

<?php

namespace App\Data;

use Illuminate\Http\UploadedFile;
use Spatie\LaravelData\Attributes\Validation\File;
use Spatie\LaravelData\Data;
use Spatie\TypeScriptTransformer\Attributes\TypeScript;

#[TypeScript]
class CreatePreparationFormRequestData extends Data
{
    public function __construct(
        #[File]
        public UploadedFile $file,
    ) {
    }
}

What I tried :

1. Remove validtion rules. Work when I upload file to my application to real situation. If I keep its, unwork.
2. To my test I make new instance of UploadFile, I tried DD it and it file type. But same if I remove or keep validation to my controller, the errors stay.
3. I tried to remove validation rules to my DTO but one error is occured : function rules can be called staticly'

Thank you in advance for your help