LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Save Data in different Excel worksheet

Solved!
Go to solution

hello,
I'm writing a program to measure some parameters of human touch.
I'm trying to save the data from the post-process and from the sensors (2 sensors).
I save data in different Excel files in the same folder but it's quite heavy (one for post process data, one for the force sensor and one for the motion sensor) ...
I'd rather get all the data in the same Excel in different sheets but it seems impossible without the excel toolkit.

 

I saw different forum post that may appear to have had about the same topic but I did not understand the answer...

 

Thanks

 

0 Kudos
Message 1 of 4
(2,972 Views)

As long as you understand the ActiveX calls necessary to manipulate Excel from LabVIEW, you will be fine.

Using ActiveX calls is more "developer intensive" than using the toolkit; however, it will make you a better developer.

 

A lot of information regarding the parameters for the ActiveX properties and methods for Excel can be found in the VBA for Excel Help file; just open VBA from within Excel and go to the help file.

 

There are examples available explaning how to make ActiveX calls from LabVIEW; they may be a good starting point.

CLD | CTD
LabVIEW 2011 SP1 | TestStand 4.5
0 Kudos
Message 2 of 4
(2,970 Views)
Solution
Accepted by topic author demum

There is a user-written toolkit for Excel available in the Excel thread  that you may want to take a look at for reference (second post in the thread). NOTE: DO NOT POST QUESTIONS IN THE EXCEL THREAD. It is a thread used as a repository of links to examples only.

0 Kudos
Message 3 of 4
(2,965 Views)

I finaly used the toolkit recommended by Smercirio (a slightly recent : http://forums.ni.com/t5/LabVIEW/problem-using-ActiveX-for-excel-app-to-determine-row-col-no-s/m-p/19... )

It's quite easy to use if you take a look at the examples (if someone wants my solution please let me know) .

 

I agree with you Ccornish, use active X would be the wisest solution but i have 2 week to finish my program ..

 

Thank you both for your help

 

0 Kudos
Message 4 of 4
(2,936 Views)