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.
    Directory.GetFiles(Directory.GetCurrentDirectory(),"*.xls")
    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

Regards,
Arivu :slight_smile:

1 Like