LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write data from 12 element cluster to excel

Oh right, well with 'format into string' I have to do each value individually, now I'm using a number to decimal string which works for the array.

0 Kudos
Message 21 of 25
(647 Views)

Hi Xebe,

 

"Number to decimal string" converts into integer numbers - as the help explains.

You might want to use "Number to fractional string" instead…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 22 of 25
(646 Views)

Well the problem with fractional is that I get numbers like "414.320.000" which are millions while it should be hundreds.

 

 

Edit:

Solution lies in the conversion in excel. I overlooked that the first time around.

0 Kudos
Message 23 of 25
(641 Views)

Hi Xebe,

 

the problem with fractional is that I get numbers like "414.320.000" which are millions while it should be hundreds.

I really don't think it's a problem of the NumberToFractionalString function!

Could you attach the file you created using this function?

Instead I believe its a problem within Excel because of using different assumptions about formatting of numbers!

 

Lesson learned: When you talk about specific problems you should attach your VI and/or the files you think are formatted wrongly…

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 24 of 25
(638 Views)

Like I said in my edit (which you probably missed, but no problem for that), it was indeed an issue with the conversion of excel.
The problem is now solved correctly.

 

Once again, thanks for your help and patience.

 

(edit: attached is the latest csv file)

0 Kudos
Message 25 of 25
(635 Views)