Save data in Excel

[manson]

I'm working on a pressure sensor VI. What's the simpliest way to continuously save my pressure and temperature data (versus time) into Excel, until I click the STOP button on the VI front panel? Thanks.

[Michael_Munroe]

You have two choices: text file or ActiveX.

If you want simplicity, just write the 3 columns (tab delimited) of data (time, pressure and temperature) to a spreadsheet file using the Write to Spreadsheet VI. If you name the file with and XLS extension, it will import into Excel with no questions asked. Be sure to write a row of headers first to identify the columns.

If you want to create an Excel file directly, then use ActiveX. Look in the examples for Excel and select the Write Table to XL VI. This VI will demonstrate how to open Excel, create a new workbook and write data to the sheet. If you want simplicity, just insert your pressure sensor VI inside the outer for loop and use the inner for loop to write the columns.

Michael Munroe

Certified LabVIEW Developer
www.abcdef.biz