Import only one sheet with a dynamic name

[CarstenGazivoda]

Hello,

i would like to achieve the following scenario:

I have an Excel file which contains 40+ sheets. Some of them are hidden, some are visible.
Only one of these sheets i would like to import. The sheet name is dynamic, but i already created a regex to determine it.

Currently i do the following (perfectly working):

1. Excel::import() the file, utilize BeforeSheets in registerEvents() and call getTitle() to fill up an array with all sheet names. I can also add the condition "not hidden" by evaluating the getSheetState().
2. perform array_filter and regex on the returned array from step 1 to determine the desired sheet name
3. Excel::import() again with the determined sheet name in the constructor using WithMultipleSheets
4. Receive my desired output

I would like to perform only 1 Excel::import and use WithMultipleSheets and Events together to save runtime. Especially the first Excel::import() takes long as it seems to parse the 40+ sheets. The events seems not to get triggered when using WithMultipleSheets.

Is there any other possibility to achieve this?

BR