tfileInputExcel - reading all Sheets with certain word in their names (using Regex?)

[Moro]

Hallo,

I would like to read (tFileInputExcel) all Sheets with "Bill" in their names. Sheet names looking like this: "Bill 01", "Bill 02",...

I tried the following:

tFileInputExcel - Basic Setting

Sheet list: "Bill (\\d(2))"

Use Regex (activated)

It doesnt work though. It starts reading from Sheet "Bill 02" and then some other Bill Sheets but not all and I dont know why. Do you have any advice for me please?

Thank you so much.

Mara

[Anonymous · Accepted solution]

Hello,

Please try the Sheet list : "Bill \\d+" as the below , it should be working

[Moro]

perfect! Thank you! 🙂