Decision Optimization

Decision Optimization

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


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
  • 1.  DOCPLEXCLOUD - Reading Matrix from Excel in the model

    Posted 06/18/20 04:51 AM

    Hello!


    I'm trying to read data from the matrix directly in the model (in IDE CPLEX) to run at DOCPLEXCLOUD.

    Could you help with syntaxis or examples of how to read matrixes from excel file directly in the model?

    (I found information only for 1d arrays).

    Thank you!




    ------------------------------
    Best regards,
    Olga
    ------------------------------

    #DecisionOptimization


  • 2.  RE: DOCPLEXCLOUD - Reading Matrix from Excel in the model

    Posted 06/18/20 08:30 AM
    Hi

    https://developer.ibm.com/docloud/blog/2015/10/01/use-a-microsoft-excel-workbook-to-provide-input-data-in-docloud/

    But if you want to use the IDE what I recommend is to generate the flat dat file for the data first and then do right click with the call to docplexcloud

    regards

    ------------------------------
    ALEX FLEISCHER
    ------------------------------



  • 3.  RE: DOCPLEXCLOUD - Reading Matrix from Excel in the model

    Posted 06/21/20 08:09 AM
    Dear ALEX FLEISCHER,

    Thank you!


    ------------------------------
    Best regards,
    Olga
    ------------------------------