Decision Optimization

 View Only
  • 1.  Excel Error

    Posted Wed February 26, 2020 03:30 AM

    Originally posted by: bichou


    Hello

    I receive this error: Exception from IBM ILOG Concert: Problem accessing the Excel file when i try to read data from excel i don't know what is wrong 

    if any one have an idea please.


    #CPLEXOptimizers
    #DecisionOptimization


  • 2.  Re: Excel Error

    Posted Wed February 26, 2020 06:47 AM

    I think you asked the same question on stackoverflow here? Please don't cross-post. And if you feel you have to, please at least cross-reference those posts.

    Can you please double check that you have Excel installed and the referenced file exists? Please try again with the absolute path of the file. Can you please also show the offending .dat file?


    #CPLEXOptimizers
    #DecisionOptimization


  • 3.  Re: Excel Error

    Posted Wed February 26, 2020 08:37 AM

    Originally posted by: bichou


    i have cplex 12.6.1 i thought that a version of my Excel 2013 is incompatible i tried to convert file in format excel 2010 but it dosen't work  

    File.mod

    int n=...; 
    range A=1..n;
    tuple vol{
    string ID;
    string secteur;
    string orig;
    string dateD;
    string heureD;
    string dest;
    string dateA;
    string heureA;
    string duree;
    }
    vol v[A]=...;

    File.dat

     n=7;
     SheetConnection data("kiki.xls");
    v from SheetRead (data,"vols");


    #CPLEXOptimizers
    #DecisionOptimization


  • 4.  Re: Excel Error

    Posted Mon March 16, 2020 03:05 AM

    Have you tried upgrading your CPLEX version? 12.6.1 is a quite old version. It may have problems that are fixed by now.


    #CPLEXOptimizers
    #DecisionOptimization


  • 5.  RE: Excel Error

    Posted Tue March 07, 2023 02:11 PM

    Hello, did you solve this problem. I receive same error as well. I have used IBM ILOG CPLEX Optimization Studio 22.1.0.00 for a year. But this is the first time such a problem has occurred.



    ------------------------------
    meltem aksoy
    ------------------------------