Import data from Excel to AMPL

[Basma Ben Mahmoud]

Hi,

I would like to ask about the best way to import data from Excel sheet to AMPL model.

In fact, I read chapter 10 in the AMPL guide, but I see that it is not detailed enough to help me doing so. (I am beginner with AMPL)

I searched about tutorials, but I did not find anything. Most of the videos are about OPL language in Cplex.

Thank you if you have any important file or video about this topic or any information that could help me.

[AMPL Google Group]

You can learn more about AMPL's interface to spreadsheets on our AMPL Direct Spreadsheet Interface* page. It explains how to set up and test the spreadsheet table handler, and gives a series of examples.

* https://amplplugins.readthedocs.io/rst/amplxl.html

--
Robert Fourer

We're switching to a new, enhanced user forum.
Join it now at discuss.ampl.com.

{#HS:2376509017-119719#}