File extension recognition

[chrestick (kristina)]

Hello everyone!

I need to read all Excel files from a folder. How to filter them by extention or another way?

[aksh1yadav (AKSHAY YADAV)]

Hey @chrestick

You can use Path.GetExtention(item) =“.xlsx” or Path.GetExtention(item) =“.xls”

For more assistance check this out :

How to read Excel file dynamically?

Wants to read excel file dynamically as the file name is not fixed. today, If we get the file as abc06022017.xlsx, Tomorrow it will be abc06032017.xlsx

Regards…!!
Aksh

[Suchi3190 (Suchita Shaniware)]

when i am using this condition , its giving compiled error that “GetExtention is not member of system.IO.Path”.

Could you please suggest.

[vvaidya (Vinay Vaidya)]

@Suchi3190

GetExtention

Path.GetExtension

[aksh1yadav (AKSHAY YADAV)]

Hey @Suchi3190

@Suchi3190

“GetExtention is not member of system.IO.Path”.

Could you please suggest.

You have to import System.IO if Path is not reflecting in UiPath Studio Intellisense.

or

you can directly use System.IO.Path.GetExtension Directly as well but better to import namespace.

Regards…!!
Aksh

[vvaidya (Vinay Vaidya)]

@aksh1yadav

you can directly use System.IO.Path.GetExtention

GetExtension

[aksh1yadav (AKSHAY YADAV)]

Forgot to mention…

More better way to do this is you can use

Directory.GetFiles(folder_path,".xlsx",SearchOption.AllDirectories)

Regards…!!
Aksh

[Suchi3190 (Suchita Shaniware)]

thanks @aksh1yadav , yes it works better