Making an excel Table

[Mick790]

Hello guys,

Having a bit of trouble with my labview program. Very new to using the software so not very sure on some things.

The program I have built is designed to measure strain when a load is applied to a steel tube. The load upon the steel tube will be increased in 500g weights which should hopefully lead to the program measureing a new strain reading.

I want the program to plot the strain values against the load values in an excel spreadsheet (In a Similar Style to the example below), however Im having trouble trying to make this work. Can anyone give me any clues or help on how I could make the program carry this out?

Cheers

Mike.

[NIquist]

You can't write to Excel like you would a standard CSV or TSV text file.  It's a proprietary format from MicroSoft.  You'll need to either buy the NI Report Generation Toolkit or use ActiveX calls to create a table in Excel.  It's generally much easier to dump the data to a text file, then open that file with Excel and make your own tables and graphs within Excel.

[Bob_Schor · Accepted solution]

About a month ago, I posted a "Revised Generate Excel Report Example" to this forum.  It uses (and requires) the Ofice Report Generator Toolkit, but does just what you describe.  A search of the Forum should find it.

Bob Schor

[Dennis_Knutson]

The latest version of LabVIEW and Write to Measurement File supports native Excel.

[Mick790]

Cheers for the help, found it and will adapt to suit my labview program.