NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

Load String from Excel with Property Loader

Hi,
I want to read in some strings from an Excel File using the Property Loader.
Everything works fine except the import of a string with a leading zero. E.g. '01 isn't read as string but as a number. I always get  the 1 in Teststand and not the 01.
The only way I found out is to write the string in Excel in inverted commas ("01") but that isn't very convenient to edit.
 
Is this functionality missing in Teststand or do I have to activate any flag or set a property.
I work with Teststand 4.0
 
regards,
Stephan
0 Kudos
Message 1 of 3
(3,445 Views)

Hi,

You probably need to format the cell(s) in excel to be text rather than General.

Regards

Ray Farmer

Regards
Ray Farmer
0 Kudos
Message 2 of 3
(3,444 Views)

Hi Stephan,

I tried formatting the cell as text but the property loader lost the leading 0.

It needs to be in the format "01" in the excel cell to be input into TestStand as 01.

I dont think has changed in any way in TestStand 4.0.

Regards

Ray Farmer

Regards
Ray Farmer
0 Kudos
Message 3 of 3
(3,441 Views)