From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Logging data into and Excel file

I have designed the VI attached to achieve a working sensor. I have been on it for weeks.

 

I want to save data into an excel file for every 5 seconds, continuously. I am very new to Labview so i have no idea where and how to start on it.

I know i can use a few "Write to ......" but I don't know how to make it work.

 

Where do i go from here please? 

0 Kudos
Message 1 of 6
(2,477 Views)

First, let's fix what is wrong with your code now.

1.  Monitoring spelled wrong on the front panel.

2.  While loops that only iterate one time because of the True constant.  (Replaced with a stop button.)

3.  4 unneeded while loops.  All code merged into 1.

4.  Extra unused shared variables in each loop.  (Eliminated unused variables.)

5.  Ugly color background on loops.  Fixed color.

 

Now if you want to write to an Excel file, search the forums.  This has been asked thousands of times before.  There are basically two choices.  1.  Write to Spreadsheet File creates a text file that can be imported into Excel.  2.  Use ActiveX nodes for Excel properties and methods to load data directly into an Excel spreadsheet.

0 Kudos
Message 2 of 6
(2,469 Views)

Can you help me correct the problems that i made?

0 Kudos
Message 3 of 6
(2,454 Views)

See attached.

0 Kudos
Message 4 of 6
(2,437 Views)

I understand that i can use "Write to spreadsheet file".

But the thing is that i'm totally clueless on how do i connect them all together since there are a few terminals.

0 Kudos
Message 5 of 6
(2,424 Views)

You take your 4 individual wires and use Build Array to create an array.  Then wire that into the Write to Spreadsheet File.

 

I would recommend looking at the online LabVIEW tutorials
LabVIEW Introduction Course - Three Hours
LabVIEW Introduction Course - Six Hours

0 Kudos
Message 6 of 6
(2,419 Views)