Originally posted by: CplexCui

Hallo, I am new user of ILOG CPLEX Optimization Studio. How to import and export data from ILOG CPLEX Optimization Studio to Excel on a 64bit Windows 7? Thanks in advance.
#CPLEXOptimizers
#DecisionOptimization

Originally posted by: SystemAdmin

Please take a look at the user manual. The following sections may be among those of interest:

• Excel integration
• Creating a connection to spreadsheets
• The oil sheet example.

#CPLEXOptimizers
#DecisionOptimization

Originally posted by: CplexCui

Thanks Daniel.
#CPLEXOptimizers
#DecisionOptimization

Originally posted by: 1876_Niousha_Mesbah

I have the same question,

Please help me,

Niousha

#CPLEXOptimizers
#DecisionOptimization

And did you read the chapters in the user manual I suggested to read? Did they not help?

#CPLEXOptimizers
#DecisionOptimization

Originally posted by: ps_jayadev

I would like to know if the data import from excel can be done without mentioning the range. I want the whole sheet to the imported whatever be the range. This is because the excel data changes dynamically and I don't want to modify the .dat file everytime it is to be imported.

Also can that data be brought to .dat file without mentioning the ranges again  ?

Someone pls help me with this.

Thanks.

#CPLEXOptimizers
#DecisionOptimization

Hi,

have you had a look at https://www.ibm.com/developerworks/community/forums/html/topic?id=e3987f3a-9c07-4a0a-b281-720cbec45080&ps=100 ?

Plus what you could also do is SheetRead a very big array of strings A1:ZZ100  and then in OPL process that array.

Regards

#CPLEXOptimizers
#DecisionOptimization