LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

I need my spreadsheet data to be in floating point format.

I am logging onto a spreadsheet temperature data as well as the date and time the data was acquired. But the temperature data is in whole interger format and I need it in floating point format. How do I change the precision of my data string?
0 Kudos
Message 1 of 4
(2,633 Views)
If you are using the 'Write to spreadsheet file.vi' then set the format connector (on the top of the vi connection in pink). Its a string with a format

%[–][+][^][0][Width][.Precision][{unit}]Conversion Code

But is your source data to this VI already an integer ?

Perhaps you could post a diagram of your vi ?
0 Kudos
Message 2 of 4
(2,633 Views)
I use the array to spreadsheet string to take in the data, then I concatenate the date/time string to the end of the spreadsheet string, then I use the write characters to file vi. When I look at the data sheet I saved it under, the data is correct along with the date/time, but the data needs to be in floating point mode instead of whole intergers.
0 Kudos
Message 3 of 4
(2,633 Views)
And what is the format string that you're using? And how can the data in the saved file be correct if it's integers and what you are trying to write is floats? Stick a probe on the input to array to spreadsheet and one on the output. That way you now whether you have a problem with the format string or with the data you've collected.
0 Kudos
Message 4 of 4
(2,633 Views)