Originally posted by: StefanWeiser

Hi,

is there any way to export postprocessing results to en Excel file?

I want to do an divided by / calculation of two values that is, as far as I know, only valid in postprocessing.

regards

Hi,

in OPL you can do that with SheetWrite. (In .dat files)

regards

Originally posted by: StefanWeiser

Hi Alex,

thanks for your response. I additionally need to do a calculation before exporting a value with SheetWrite. 

Something like this (1- Value1[t]/Value2[t]) to SheetWrite(my_sheet, "Value3"). What is not possible. And if I am trying to calculate this within dexpr float there will be an error as well.  

regards

Hi,

you should store the computed value in the .mod like

float value=(1- Value1[t]/Value2[t])

and then in the .dat you would write

value to SheetWrite(my_sheet,"A1:A1")

if you want to update the cell A1

regards