LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to spreadsheet without prompting each time through a loop

Solved!
Go to solution

I think I might have confused you when I said "array to spreadsheet vi".

 

What I meant was to stay with the "write to spreadsheet file vi" that you were already using but try the %s format string

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 31 of 34
(735 Views)

That works to an extent but not fully. The readout becomes something like: 0.00000744.237301128.000000 which when split up is 7e-6, 44.23, and 128.0 So I guess my next question is do I have to change to formatting differently instead of the delimeter %s to format in such a way that the first number carries more than those 6 digits before the actual number? In other words it should read out something like 7.19e-6 or with all of the 0's in front instead of cutting off at the first digit of 7.

0 Kudos
Message 32 of 34
(721 Views)

With the small numbers yo uare working with I would (and gennerally always do) use Double-precision floating-point numbers.

 

As for the format, once you get in into Excel you can format the numbers anyway you want.

 

Select a colum or group of numbers, right click on it and select "format cells".

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 33 of 34
(715 Views)

Yeah it was not about formatting in excel it was how it was formatted in the spreadsheet text file. Using the scientific notation format instead of the %s format I am having no problems now. Thanks for all of your help. I believe all of my issues have been solved for now. Thanks again to all who helped.

0 Kudos
Message 34 of 34
(712 Views)