Originally posted by: SystemAdmin

Hi,

I'm very new to Cplex and am trying to solve a relatively large linear programming problem by importing data from excel. I'd like to import ALL data from excel. That is, import the matrix of constraints, right-hand side of each constraint, and objective function coefficients. I know how to pull data from a .xls file into a .dat file, but I'm not sure how to actually tell Cplex to solve.

Thus far in my experience, constraints and decision variables are made by first building strings. Given that I have a large number of constraints and decision variables coming from excel, I'd like to avoid this practice and iterate by row (or just tell cplex to line up each row of the matrix with its row in the right-hand side vector). Any suggestions?

Thanks.
#DecisionOptimization
#OPLusingCPLEXOptimizer