Decision Optimization

Decision Optimization

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

 View Only
  • 1.  variable range reading spreadsheet

    Posted Tue July 10, 2018 06:29 AM

    Originally posted by: Janisch


    Hey,

    Is there a possibility in a sequence control to read in different Excel sheets as data input and to write the result into the corresponding Excel file?

    As an example, I want to read production program 1 from excel sheet1 and write the solution in the Excel sheet 1, then comes the next excel sheet with the production program 2, etc ...

     

    regards


    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: variable range reading spreadsheet