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?