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?