03-16-2012 06:02 AM
I have managed to import properties from an excel file which I have to modified (by adding balises <Locals> <FileGlobals> etc...) by using property loader.
I want to simplify the processs, is it possible to read an raw excel file (or csv) without adding balises ? What is the item Import/Export properties in tools menu ?
Thanks.
03-19-2012
08:25 AM
- last edited on
10-21-2024
02:21 PM
by
Content Cleaner
Without the balises how would you know where to put the data? They dictate which variables will be assigned the data. Are you using the Property Loader step?
The Import/Export Properties allows you to create the excel/csv file with the balises already there. You have the ability to select which variables or properties you want in the file. This is from the TestStand help: https://www.ni.com/docs/en-US/bundle/teststand-api-reference/page/tsref/import-export-properties-dia...
Generally users have the Import/Export Properties wizard create the file that they read in dynamically during the test using the Property Loader step.
If you are interested in an alternative I recommend using Property Object files. They are formatted like ini files in ASCII format. Look at the Write and ReadEx functions in the TestStand help to understand how to utilize them.
Regards,
03-20-2012 04:58 AM
Hi sfla,
I agree with jigawarax. You could also eventually creat a custom step type taht use a raw csv or excel file, parse this file and generate an intermediate file with balises to import properties.
But use of property.object.read ex seems to be easier as mentionned by Jigawarax.
regards
Romain DUVAL || RF & Semiconductor Staff System Engineer || CLA || CTA
National Instruments France