Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.

 View Only
Back to discussions
Expand all | Collapse all

Opl External Excel filename

  • 1.  Opl External Excel filename

    Posted Thu December 15, 2016 07:30 AM

    Originally posted by: LuisPrado


    Good morning.

     

    I have a opl.dat with the line: 

     

    SheetConnection sheet1("data.xls");

     

    I'm working also with Java. Is posible that "data.xls" could be retrieved as parameter from Java code? Or maybe defining the filename in a .txt and reference it into the .dat?

     

    Regards

     

     


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: Opl External Excel filename

    Posted Thu December 15, 2016 11:21 AM

    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 do is write a file file.dat with

    SheetConnection sheet1("data.xls");

    inside.

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 3.  Re: Opl External Excel filename

    Posted Thu December 15, 2016 12:01 PM

    Originally posted by: LuisPrado


    Hi,

     

    In the .dat file I call at sheet1 object but the definition comes from another .dat that I create dynamically and I put the reference of this .dat before others.

     

    On this way I can define several .dat files with different names and use whatever I need. 

     

    All these come from a Java Server side development I don't want to modify the sources because could be dangerous but that solution worked for me.

     

    Thanks


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content