How can i use open office's excel with property loader in Teststand

[hedehodo]

Hi,

I have an application where i need to use property loader in TS. The data to be used is being prepared in Excel. But the TS is being working on a computer where only OpenOffice  can be used. Now my problem is to import data from Open Office's Calculator (excel) to my test sequence using property loader.

[Eric_B.]

hedehodo,

I don't have OpenOffice Calc on my computer, but I believe it can save to a .xls file.  Since TestStand's property loader can read .txt, .csv and .xls files, if you can save your OpenOffice spreadsheet to a .txt, .csv or .xls file, you can use TestStand's property loader with that file.  To make sure you're using the proper formatting, I'd recommend exporting some properties to the file type of your choice so you can see what the spreadsheet should look like.

[James_Grey]

TestStand uses Excel to read and write XLS files, so I don't think that will work on a machine without Excel. Tab delimited and CSV formats should work though.