For now, I can only import one excel sheet, at a time, into my CPLEX opl to solve my optimization problem.

How can I make this automated? I want to make my code run in a loop to access my excel sheet files one by one solving them and export the solution one by one as well.

Also, note that each excel sheet has a different cells range. Finally, all these excel sheets are in one excel file.

Any help, please?