How to use Read Range activity with two possible file extensions?

[bp777]

Hi,

I need to use Read Range activity for an excel file that could be either .xlsm or .xlsx.
The extensions depend on whether macro has opened a file or not.

Any suggestions?
Thanks in advance.

[nikhil.girish]

Hi @bp777

i would suggest you to go with workbook readrange for both the extensions

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@bp777
Use Workbook read range activity for reading the files.

[Vaibhav_Rajpoot_17 (Vaibhav Rajpoot)]

@bp777
Use Workbook read range activity for reading the files.

[varunk (Varun Kumar)]

Hi,

In for each activity give the syntax as Directory.GetFiles(“Provide the folder path”)
Then you will get a file use workbook read range activity to read a file.

It will work try now

Regards,
Varun

[Shikhar_Tandon]

Hi @bp777,

You can use Excel Application Scope → Read range activity to read the files. It will read it easily.

Thanks

[NervYerem]

If it exists in its own Dir, You can use a wildcard to find the file into an array and use for each to read it.

Wildcard file path

@damonyl We can’t use wildcards in reading file. Try this way. strExcelFiles [] = Directory.GetFiles("C:\Users\user\Documents\testenviroment\","test*.xlsx") The above expression will read all matching files and will give output as string array. Then use For Each loop activity to read one by one file.