[AMPL 24810] Import data from Excel to AMPL

Google Group Mirror
1

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.

2

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.