Subscribe Bookmark RSS Feed

Script for pull data out

blue1994

Contributor

Joined:

Feb 27, 2017

Hello,

How can I extract out the data from excel file?
Now i want to extract my F_D and parameters out. Which meant here, S_GX_F40 using I_P2A and I_N2A parameters etc.(attach photo )

 

dtExcels = open ("<path of excel file>", "invisible");


 For(j = 1, j <= N Rows(dtExcels), j++,
 	Eval(
 		Expr(__familydevice__), dtExcels : F_D[j],
 		Expr(__param_), dtExcels :Parameters[j]
 	)
 );

photo3.png

1 REPLY
blue1994

Contributor

Joined:

Feb 27, 2017

So, may I know is it possible to summarize out by using JSL?