LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

SpreadsheetToArray

Solved!
Go to solution

Hello i need help with spreadsheet to array i recive data from serial and i wanna use function spreadsheet to array to have all values in array instead of string but i lose floating points in the process but before that function it is all okay i tried to change represatation of array display but it doesnt work

Adweqweq_0-1708545210889.png

 

0 Kudos
Message 1 of 9
(845 Views)

Try changing the format string from %g to %f.

0 Kudos
Message 2 of 9
(828 Views)

If your data is separated by commas all you need to do is this:

 

SS2ACapture.PNG

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 3 of 9
(818 Views)

i tried that also didnt work i also tried setting %5.3f to display 3 floating point numbers but also didnt work 

0 Kudos
Message 4 of 9
(816 Views)

 


@Adweqweq wrote:

i tried that also didnt work i also tried setting %5.3f to display 3 floating point numbers but also didnt work 


Post your code and a sample of the data string you are receiving.

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 5 of 9
(808 Views)

Are you from Germany or another region that uses a decimal comma as default decimal character?

Rolf Kalbermatter
My Blog
0 Kudos
Message 6 of 9
(770 Views)

What does that have to do with a manure spreader?

Message 7 of 9
(724 Views)
Solution
Accepted by Adweqweq

maybe try to set %.;%f

0 Kudos
Message 8 of 9
(704 Views)

Thank you very much brudka_kotlet_cardinale this worked for me !

0 Kudos
Message 9 of 9
(693 Views)