How to read and write data from Excel to TestStand without using LabVIEW VIs

[JBacker]

Hi,

How can I read in columns of data from Excel into a TestStand array and write columns of data to Excel from TestStand without using LabVIEW VIs?

I don't think the Property Loader custom step type in TestStand will work because the data I would like to read in from Excel is in a column that is thousands of rows long and the data has to be in the proper format to use the Property Loader to load in an array from Excel.

Thanks for your help.

[snowpunter]

Yes, using ActiveX.

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

[Niraj2810]

Hello,

Can you please recommend some example other than what has been mentioned in

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

I have a requirement where I need to read the data from xls file and update another xls file which will store the results. I am not supposed to use LabVIEW for this, I have to do only using TestStand.

I am using  NI TestStand 2010, and Microsoft Excel 2007.

Thanks and Regards,

Niraj.

[snowpunter]

That example does not use LabVIEW and it does about 40% of what you need to do by calling Excel through ActiveX. If you don't know how to use Excel through ActiveX then you'll need to brush up on that.

http://www.microsoft.com/en-us/download/details.aspx?id=16250

http://support.microsoft.com/kb/141759

http://support.microsoft.com/kb/302084

[Nisarg_Shah]

Link showing Error Page... 

Kindly share some other reference..

[GeraldM]

Hello Nisarg_Shah

I was able to find a few links that may be useful in your trying to read and write data from Excel to TestStand without using LabVIEW VIs. 

Getting Started with TestStand

https://www.ni.com/pdf/manuals/373436f.pdf

100 Best TestStand Videos

http://meta-guide.com/videography/100-best-teststand-videos

Also, if you have any more questions I would recommend making a new forum post. The post we are currently on is pretty old and creating a new post would get more attention/input from current members. 

[Nisarg_Shah]

Hi GeraldM,

Thanks for the quick Response.

I found the Solution using activex  to read Excel Data In Teststand.

Will Upload the solution in  new thread which can help community.

 and Share the Link Also Here.

Regards,

Nisarg Shah

[carlo78]

Hello Nisarg_Shah,

can you share your solution?