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
(843 Views)

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

0 Kudos
Message 2 of 9
(826 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
(816 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
(814 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
(806 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
(768 Views)

What does that have to do with a manure spreader?

Message 7 of 9
(722 Views)
Solution
Accepted by topic author Adweqweq

maybe try to set %.;%f

0 Kudos
Message 8 of 9
(702 Views)

Thank you very much brudka_kotlet_cardinale this worked for me !

0 Kudos
Message 9 of 9
(691 Views)