Look for an excel sheet with a specific name in the folder

Learning Hub Academy Feedback
1

Is it possible to look for an excel file with a particular name within the folder.
Example.If I have a id say JHY456 and firstly I want to look for a file name within a folder starting with the same name as my id JHY456 and want to open it and then write the data within that file.
Could anyone guide me a bit …as how to do this ?

1 Like
2

Hi @kartik_sareen

Yes you can use

 Directory.GetFiles("yourDirectoryPath","*.pdf or excel")

This will return an array of file names, then have a for each loop and apply if condition in it something like this

image

Then you can do the operations further accordingly

Thanks,
Prankur

3 Likes
3

thanks a lot Prankur…

1 Like