Originally posted by: SystemAdmin

I use CPLEX Optimization Suite 12.2 with Windows XP.
I tried to use the connection with the spreadsheet, but it does not work.
Even the original oil example does not work.
The error message is :

Description Resource Path Location Type
Exception from IBM ILOG Concert: Problem accessing the Excel file oilSheet.dat oil 12:37-38 C:\ILOG\CPLEX_Studio_AcademicResearch122\opl\examples\opl\oil\oilSheet.dat OPL Problem Marker

Any suggestion ?
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Do you have Microsoft Excel installed on your computer?
Are you working with 32-bit or 64-bit?
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Yes I have office 2010. I use a 32 bit CPU INTEL core duo.
COncerning the OPL examples I did not modified the excel file, or saved it. I just used the files provided witgh the installation.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

Based on Detailed hardware and software requirements for V12.2, Microsoft Office 2010 is not supported with CPLEX Optimization Studio V12.2. I would encourage you to upgrade your installation to V12.3 with which Microsoft Office 2010 is supported (see CPLEX Studio V12.3 software requirements)
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: SystemAdmin

I have update OPL to version 12.3
I tried to solve both the original OIL example provided with version 12.2 and that provided with version 12.3 (I have installed the examples into different directories).
The result is the same

Description Resource Path Location Type
Exception from IBM ILOG Concert: Problem accessing the Excel file. oilSheet.dat /oil 12:36-37 C:\Documents and Settings\utente\Application Data\IBM\ILOG\CPLEX_Studio_Academic123\opl\examples\opl\oil\oilSheet.dat OPL Problem Marker
In my opinion it does not depend on the version of office since (I suppose) OPL should read directly the excel file and these sample files (version 12.2 and version 12.3) have not beeen manipulated by me.

The other strange fact is that I cannot copy-and-paste from the scripting log (of other examples).
The copy item in the edit menu remains gray and the right bottom of the mouse provides only Clear Scripting Log, Scroll Lock and Preferences menu voices.
#DecisionOptimization
#OPLusingCPLEXOptimizer