Originally posted by: williamode

Hello,

I want to publish results to a EXCEL sheet when I dynamically create a model using the function "IloOplModelSource()", "IloOplModelDefinition()", "IloOplModel()" and "IloOplDataSource()".

The tutorial offers an example use the "ODBC" at item "Data elements and data publishers". It seems that the same procedure doesnot work using the function "sheetconnect".

How can I work it not use "ODBC"? Or I have to connect to EXCEL using "odbc"? Can someone offer an example to do this, I am not familier with using "ODBC" connect to 'excel'.

Thanks a lot.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: GuangFeng

It is possible to use Excel sheets as ODBC datasource. The link below:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q195951

Try to follow the instructions to "Create an ODBC System Data Source Name (DSN) pointing to the ADOTest.xls file".

You need to define the cells you need to access as named ranges and use the named ranges as tables in SQL statement in ODBC.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Originally posted by: williamode

Thanks a lot.
#DecisionOptimization
#OPLusingCPLEXOptimizer