Originally posted by: SystemAdmin
As Daniel mentions, please post your OPL questions in the OPL forum so as to reach the appropriate folks:
> I have a problem with writing my results to an Excel File.
> Even though there is the result in the problembrowser, the Error:
> Exception from IBM ILOG Concert Error: The file is readonly
> appears and there is no result in the excel-sheet.
> Does anyone Know why the error comes up and how write the results out
> in an excel sheet wit
>
> x to SheetWrite ("A2:G3")
With regards to your question, as the error suggests, you may have the excel file already open (not in read only mode) in excel and thus OPL will not be able to write/save the results after the run leading to the message. Please make sure that the file is not open and is available to read/write by OPL. Your SheetWrite syntax looks fine, however, it may be better to also specify the sheet name before the cell range. Please find one such example in the oilSheet.dat file of the 'oil' sample which comes with the distribution.
Hope this helps.
#CPLEXOptimizers#DecisionOptimization