Importing variable number of sheets in groups of 3 sheets?

[Alhubing]

Hello, i need to know how to achieve this.
I have an excell with a variable number of sheets, following this structure.

EntityA Sheet1
EntityA Sheet2
EntityA Sheet3
EntityB Sheet1
EntityB Sheet2
EntityB Sheet3

I make the import specifying the 3 different types of sheet with the multiple sheet trait, but then the importer stops after reading the first 3 sheets and then stops, so only the entity A is imported.
I thought the importer should go on until it has no more sheets, iterating over the definition of the multiple sheets.
Thank you.

[patrickbrouwers]

Please show your code

[Alhubing]

`class GlobalImport implements WithMultipleSheets
{
public function sheets(): array
{
$sheets = [
new FirstSheet(),
new SecondSheet(),
new ThirdSheet(),
];

    return $sheets;
}

}
`

Ive got something like this, then i try to import an excell with six sheets for example.
1 and 4 imported with FirstSheet
2 and 5 sheet with SecondSheet
3 and 6 sheet with ThirdSheet

Now it works only for sheets 1, 2 and 3, then stops importing.

[patrickbrouwers]

Well you have specifically said that you only want to import 3 sheets, all sheet index that are not mapped to a sheet import will be ignored.

Try this:

new FirstSheet(),
new SecondSheet(),
new ThirdSheet(),
new FirstSheet(),
new SecondSheet(),
new ThirdSheet(),

[Alhubing]

The problem with this is that i have a variable number of sheets.
I mean i dont know if the file has 3, 6 or 9 sheets for example, the number of sheets is variable but always in groups of 3.
Thank you.

[patrickbrouwers]

Assuming there will be a maximum amount of sheets possible, you could define them all and skip non existing ones with https://docs.laravel-excel.com/3.1/imports/multiple-sheets.html#skipping-unknown-sheets