LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to save values and information in a spreadsheet?

Here is a snippet of a vi I made that I use after I have taken a series of measurements.

 

This takes on line of data, in the form of a 1D array, timestamps it, converts it to a spreadsheet string and writes it to a file.

 

This creates a TAB delimited file that can be opened directly by Excel if you give the file a .xls extention.

 

If you want colum headers you will have to put them on the file first

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 11 of 15
(891 Views)

Hey mate,

 

I'm using LabVIEW 8.5 so I had to make your code here... in the file path I have to put only the destination right?

I'm putting like "c:\"  and it's appearing that:

 

 Possible reason(s):

LabVIEW:  Unexpected file type.

c:\

 

 

Thanks for the help

0 Kudos
Message 12 of 15
(872 Views)

EduU wrote:

Hey mate,

 

I'm using LabVIEW 8.5 so I had to make your code here... in the file path I have to put only the destination right?

I'm putting like "c:\"  and it's appearing that:

 

 Possible reason(s):

LabVIEW:  Unexpected file type.

c:\

 

 

Thanks for the help


 

You have to put the entire path and file name.

 

C:\directory name\datafile name.xls

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 13 of 15
(871 Views)

Hey, 

I am new at this labview stuff. I have been looking at various examples and I got this vi and modified to my own need. 

It would retrieve the data generated and transfere it to excel, but I have a tiny problem with this vi. I would like the program to place the each values that were retrive into appropriate cells (like a delimiter). So far its retrieving the data and putting all of them into cell A1. can some one help me please??

 

Thanks,

0 Kudos
Message 14 of 15
(626 Views)

You really should have started a new thread.

 

The reason it puts it all into A1 because that is the way it is programmed.  It is hardcoded for cell A1.

0 Kudos
Message 15 of 15
(614 Views)