I need to read each excel in this directory: C:\DBK\Testes RPA Envio
So I tried this:
Assign: string > directory.GetFiles(“C:\DBK\Testes RPA Envio”,"*.xlsm",SearchOption.AllDirectories)
It worked, however in each directory, I have 2 sobfolders, “WP_DAA_PENDING” and “WP_DAA_PROCESSED”
But, I need only read the excel file from the folder “WP_DAA_PENDING”
Anyone could help me with this?
Thanks for your attention