Originally posted by: SystemAdmin

Hello,

Is there a way to store parameter files that can be loaded quickly for an optimization instance? Currently, each time I run my code it takes quite some time to load the parameters. This is what my .dat file looks like:

SheetConnection sheet("Data.xlsx");
N from SheetRead(sheet,"n_names"); // "n_names" is a dynamically named range within the Excel file
// About 20 other sets and parameters are loaded similarly.

Is there a smarter way to store parameters? Perhaps another file type such as .csv is faster read from than .xls or .xlsx.

Any help would be greatly appreciated.
#DecisionOptimization
#OPLusingCPLEXOptimizer

Hi,

let me call mod.mod and dat.dat your model and data file.
What you can try is

oplrun -de exporteddat.dat mod.mod dat.dat

which will export the content of your excel content into a data file and then you can do

oplrun mod.mod exporteddat.dat

Alex
#DecisionOptimization
#OPLusingCPLEXOptimizer