Topic
1 reply Latest Post - ‏2013-02-07T20:33:38Z by UMQX_Olfat_ELMahi
UMQX_Olfat_ELMahi
UMQX_Olfat_ELMahi
56 Posts
ACCEPTED ANSWER

Pinned topic Save my Results to Excle file

‏2013-02-07T18:40:31Z |
Hello every one,

my model desion variables defined as intervals like this:
dvar interval aplAct1j in Ap1 ;

i need to save there results to excel sheet when i use the command :

SheetConnection sheetData("C:/Users/Results.xls");
aplAct1 to SheetWrite(sheetData,"aplAct1");

it give me error :
Data element "aplAct1" of type not supported for databases.

can any one help me?

Thanks
Updated on 2013-02-07T20:33:38Z at 2013-02-07T20:33:38Z by UMQX_Olfat_ELMahi
  • UMQX_Olfat_ELMahi
    UMQX_Olfat_ELMahi
    56 Posts
    ACCEPTED ANSWER

    Re: Save my Results to Excle file

    ‏2013-02-07T20:33:38Z  in response to UMQX_Olfat_ELMahi
    i got it i usd th main to writ it to th excl file"
    for (var i = 0; i < thisOplModel.noMPEGFrames; i++)
    f1.writeln(thisOplModel.aplAct1[i].start, "\t", thisOplModel.aplAct1[i].end, "\t", thisOplModel.aplAct1[i].size, "\t", thisOplModel.aplAct1[i].present);