Excel application Scope with wild card

Hi I want to read a excel file from Excel application Scope with a pattern 2019-01-19 XXXXXXX Test.xls

XXXXXXX can be any random number how can I read the file with the wild characters ? or *

When I tried the wild characters but it thown error as illegal characters.

Please help

@nagarjunvv try pattern regex like below.

“2019-01-19 [\d]{6} Test.xls”

Thanks for the quick response.

I am getting the below error but none of the characters present in my file name
Excel Application Scope: The file could not be accessed. Try one of the following:

• Make sure the specified folder exists.
• Make sure the folder that contains the file is not read-only.
• Make sure the file name does not contain any of the following characters: < > ? [ ] : | or *
• Make sure the file/path name doesn’t contain more than 218 characters.

Hi @nagarjunvv,

i think you can’t do directly. try below steps.

  1. Using below code you can get all the xls files.
    2.using for each activity to loop the record
  2. inside for each activity use matches activity to check with below pattern
    Pattern : 2019-01-19 \D{7} Test\.xls
    if true use Excel application scope to open the excel file

Arivu :slight_smile:

1 Like