Loop through folders to read excel

[FloN]

Hello Community,

I have to automate a process, in which the bot has to read an excel file to Write the Data in SAP afterwards.

Unfortunately, i do Not have a Solution for looping through different folders, which includes the excel files. The excel files are Always in the same Form, but it has to be read one By one.

So my two questions are:

How do i loop through folders to Work with the excel files one by one?

How can i implement a Check if a excel file available or Not in a Single folder?

Best regards
Flo

[Lahiru.Fernando]

Hi @FloN

You can use the below template for your scenario. I think with a bit of tweaks you can make use of it to get your task done

Merge Content of Multiple Excel Files

[AshwinS2]

Hi @FloN

str var=Directory.GetFiles(InputFilePath)

Use for each item in var

use readrange in excel and use merge datatable

Thanks
Ashwin S

[FloN]

Hello @AshwinS2 and @Lahiru.Fernando ,

thank you your fast and kind help. I will try both of your solutions to learn from them, as i am a beginner

Best regards
Flo