read and write in openoffice calc using Teststand

[ElodieG]

I would like tu use Open Office Calc :

- to enter parameters/variables for my sequence test,

- to write anwser/data from my sesuce test in the same Calc file.

I use dynamic link libraries (DLL) for my sequence test. These DLL are created in LabWindows/CVI. I would like to create a DLL for OpenOffice Calc.

I know there is a Word Excel function panel that exists. Is it the same funtionning for OpenOffice Calc ? Where can I find the function panel for OpenOffice Calc ?

[RayFarmer]

There is an Addin for TDM which you might beable to use in TestStand see link - http://zone.ni.com/devzone/cda/epd/p/id/5951

Maybe you can use an ActiveX interface to read and write from an Open Ofiice document.

[ElodieG]

I installed TDM on my laptop.

When you say "use ActiveX interface", should I use it in TestStand or in my DLL LabWindows/CVI.

If I want to create a DLL to open and write in a OpenOffice Calc fil (moreover, is-it a .calc file or .tdm file or .tdms file?), which library should I use : ActiveX Library, DIAdem Coonectivity Library, or TDM Streaming Library ?

Regards,

Elodie G.

[RayFarmer]

If you are using TDM then TestStand has an interface to TDM (checkout example in TestStand Folder).

When I said "use ActiveX interface" I did mean in TestStand. Checkout examples that read and write to a Microsoft excel file, I would image it would be similar.

[ElodieG]

I have found one example with Excel : PropertyLoader\LoadingLimits\LimitsFromExcelFile\UsingCVI.

I don't understand, it uses a specific DLL and there isn't a TDM file, neither an ActiveX action used in the sequence test. Could you please tell me which example is the best for my problem ?

Best regards,

Elodie G.

[asbo]

It looks like the LoadingLimits example doesn't use ActiveX automation, it uses a property loader instead. Maybe the property loader didn't always support XLS.

In any case, the advice in this post appears to still be true, I didn't find any ActiveX-based examples in a cursory search.

[RayFarmer]

after a bit of searching i found this example

http://zone.ni.com/devzone/cda/epd/p/id/5318

Do you have LabVIEW?

[ElodieG]

@ asbo : the link in the post doesn't work anymore...

@ Ray Farmer : I don't have LabView. I want to find a solution with TestStand - LabWindows/CVI - OpenOffice Calc

[asbo]

Oops! I should spot-check what I link 😉

Ray found exactly what you need, however. The sequence uses Excel 9.0 and TestStand 3.0 but opened fine in TS 4.2 with Excel 12.0 - a few prototypes need to be updated, but the example should demonstrate the general idea for you.

[RayFarmer]

OK, I'll check for CVI example, in the mean time checkout that example I posted. It's just TestStand.