LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

saving to excel

I know this is probably a tired topic but i cannot find any answers that dont involve buying the toolkit. I have 4 outputs, G's, accel, position and velocity. I want to write it to an excel file or csv.  I did find one topic showing how ot but it required the "bring to front excel.vi" and I dont have that. Can someone please help me, I know it cant be too hard to do this.

0 Kudos
Message 1 of 4
(2,439 Views)

If you are just needing to write to a csv file then look under "File I/O" "write to spreadsheet file". The functions are not very clean (no error in/out for instance) but they do work. There are also descriptions in the LabVIEW Help/Find examples that use ActiveX, rather than requiring the toolkit you refered to.

Putnam
Certified LabVIEW Developer

Senior Test Engineer North Shore Technology, Inc.
Currently using LV 2012-LabVIEW 2018, RT8.5


LabVIEW Champion



0 Kudos
Message 2 of 4
(2,434 Views)

I try to get my data inthere but it tells me I have an issue, 32 bit source and 64 bit sink. How can I combine all my data so that I have 4 colouns

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

There are missing sub-vi's in your attached code, so I don't know exactly what is missing, but if you want to record the data for a period of measurements you need to move the "save to spreadsheet" outside the loop and enable indexing, wiring the result to the 2D array input. If it is formated wrong (4 rows vs 4 columns), then you can use Array/Transpose 2D Array to reshape it . When you say "it tells you" that there is an issue, what is "it"? You are trying to build an array of double precision numbers and single precision numbers and at least the "G-Forces" value is actually a single (SGL) value as it is connected to the output of the "Read Sensor.vi" which appears to be a single precision as well, and is identical to ACCELERATION. But, presuming that the problem causing the error message is with the build array, then you need to convert the SGL numbers to DBL or the DBL to SGL which can be done with the "Numeric/Conversion" functions.

Putnam
Certified LabVIEW Developer

Senior Test Engineer North Shore Technology, Inc.
Currently using LV 2012-LabVIEW 2018, RT8.5


LabVIEW Champion



0 Kudos
Message 4 of 4
(2,421 Views)