LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to programatically save an Excel file

Solved!
Go to solution

I have been able to successfully open a tdms file in Excel using the tdms plug-in.  Now comes the question: how do I programatically save an Excel file?

0 Kudos
Message 1 of 4
(3,208 Views)

I found the examples from this page very helpful for excel reporting - hope this is what you're looking for.

 

http://digital.ni.com/public.nsf/allkb/EFCE1C25DCE7483E86256CAF00539451?OpenDocument

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

There is an active X interface for the TDMS Addon

I have never used it.  Post a nice example when you get it working will you?


"Should be" isn't "Is" -Jay
Message 3 of 4
(3,180 Views)
Solution
Accepted by topic author AT1

If you don't want a TDMS file and don't have the Report Generation Toolkit, then ActiveX would be your best bet.  A simple write to Excel takes less than 8 nodes. There is a very basic example in the LabVIEW help.  Just search the help for Excel and choose Excel - Write Table.vi.  Alternatively you can just find it here: C:\Program Files (x86)\National Instruments\LabVIEW 201x\examples\Connectivity\Excel

Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
Message 4 of 4
(3,058 Views)