I want to copy array of values that is located in Excel to TestStand FileGlobals

[Marta1402]

I have a little table of parameters in Excel file.

For example it seems so:

Modulation_mode	Upconversion_mode
1	3
2	4

And I have 2 FileGlobals in my sequence: Modulation_mode (array of numbers) and Upconversion_mode (array of numbers).

I want to copy a table from Excel table to my FileGlobals accordingly.

How can I do it  ?

[RayFarmer]

Hi,

Try using the property loader step type.

Attached is an example.

Regards

Ray Farmer

[Marta1402]

Hi, Roy, thank you for example, it works.

But a table in .xls file became to be terrible.

I have to have this file in simple mode (for user) such as

Modulation_mode

1

2

4

without "terrible" string

Modulation_mode

<Prop Name='Modulation_mode' Type='Array' LBound='[0]' HBound='[1]' ElementType='Number'><Value ID='[0]'>1</Value><Value ID='[1]'>2</Value></Prop>

Is this any way to do it beatiful ?

Just values in the table?

[RayFarmer]

Hi,

Yes it is a bit messy.

Try this example.

There is a down side to defining every element of the array.

Look at the PropertyLoader step properties between the two steps.

Regards

Ray Farmer

[Marta1402]

Ok, Ray, Thank's.

[SeanJ]

Hi Ray,

Is this still the only way of loading a set of variables using excel, or do any of the later versions of TestStand have the capacity to read an excel file without all the formatting?

Sean

[IronSem]

Hi SeanJ,

I used LabView to do this. I had a table of parameters in excel and I build a VI that extract this parameters in different way. This isn't the faster way to extract information (you need to open a file with LabView and than read your variables) but it works wery well because you can customize everything.

Otherwise, you can format the excel file like a text file with tabulation and than read the text file with TestStand, but I think that you have to re-format the information with a VI or similar for use that easily.

Good work,

Sem

[siddheshk]

Replying so I can check this thread on another machine.