Originally posted by: mbaddar1

Hello everybody

i have an OPL project .mod .ops .dat file , the .dat file uses external xls files to get the data , but the path of the input excel sheets is hard coded int the .dat file , i am developing a java application using OPL java interface , is there anyway to pass excel sheet file names and paths to .dat file

thanks in advace

This is a pure OPL question. Please turn to the OPL Forum with that.

In similar situations I have used one of the following strategies in the past:

1. In the .dat file replace the absolute path with something like @@DATAPATH@@, then at runtime patch up the .dat file with the correct path to the .xls files before running the project.
2. The IloOplModel class has a resolvePath() method that resolves path names relative to the model directory. This can come in handy when you need absolute paths to data in the model directory.