Decision Optimization

Decision Optimization

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

 View Only
Back to discussions
Expand all | Collapse all

Is it possible to import data from excel using a .dat file on a Mac?

  • 1.  Is it possible to import data from excel using a .dat file on a Mac?

    Posted Thu October 29, 2020 05:57 PM

    I set my students a problem to formulate requiring that they use a .dat file to get data from an excel file. Unfortunately I have a Mac user who is getting the error message "sheet not supported on this platform" or something like that.






    #DecisionOptimization
    #Support
    #SupportMigration


  • 2.  RE: Is it possible to import data from excel using a .dat file on a Mac?

    Posted Mon November 02, 2020 10:58 AM

    Dear patrick14,

    It is probably because the .dat imports data from excel sheets that cannot be read on Mac.

    A possible solution is to export your data as csv and then import them as suggested in :

    https://stackoverflow.com/questions/48231980/connecte-excel-file-to-cplex

    I hope this helps.






    #DecisionOptimization
    #Support
    #SupportMigration


  • 3.  RE: Is it possible to import data from excel using a .dat file on a Mac?

    Posted Mon November 02, 2020 01:56 PM

    Thanks. I can see how that would work. Currently I have a single excel file with numerous tables that OPL reads through named ranges. I assume I would have to create a separate CSV file each table and convert into the format suggest in the post? With 6 or 7 tables that becomes pretty cumbersome code. Does OPL have any long term solutions? It is not like Mac computers are rare.






    #DecisionOptimization
    #Support
    #SupportMigration