Originally posted by: JKRATHORE

I have an excel sheet of flow matrix between various locations. How to read flow[I,j] from location i to location j directly from excel sheet without typing data in .dat file. A sample file is attached here.

Have you tried SheetRead? According to the reference documentation you use this function to "read spreadsheet ranges into OPL 1-D or 2-D arrays".

An OPL example that reads data from an Excel spreadsheet can be found here.

In general, OPL related questions should be asked on the OPL-Forum.