topic Re: How to export the code result in excel file? in FlexSim Forum

How to export the code result in excel file?

aseem_s — Wed, 29 Nov 2017 10:39:40 GMT

[ FlexSim 7.5.4 ]

/**Custom Code*/
treenode item = parnode(1);
treenode current = ownerobject(c);
int port = parval(2);
string s = numtostring(getitemtype(item));
/*exittime1, entrytime1, die1 are global variables*/

if(stringcompare(s,die1))
{ 

	exittime1 = getentrytime(item);

}
	
else
{
	entrytime1 = getcreationtime(item);
	die1=s;
}<br>

Re: How to export the code result in excel file?

jing_chen — Thu, 30 Nov 2017 03:11:16 GMT

Hi, Assem.

Have you ever try to use excel commands like: excelopen(), excelsetsheet(), excelwritenum()? You can find more detail in user manual about excel.

Re: How to export the code result in excel file?

aseem_s — Thu, 30 Nov 2017 12:46:28 GMT

Hi,

What would be better writing it in the global table then exporting or directly exporting to the excel as you are saying?

Re: How to export the code result in excel file?

jeff_nordgren — Thu, 30 Nov 2017 18:21:24 GMT

@Aseem S,

Have you tried using the Excel Export option for a Global Table? If you select the global table, on the right of the screen in the Quick Properties window, you will notice a "Add Table to MTEE" button (see graphic). You can press that button to create the "basics" of a Global Table Excel export.

Then you would to to the Excel Interface, top row of icons, and go to the Export tab (see graphic). Then just fill in any information that is needed and press the Apply button. Then you can select the table(s) to be exported by checking the box next to the name of the Export and pressing the Export Tables button below the tables list.

Is this what your were looking for? Would this work for your situation?

Thanks.