LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

I can't get small numbers (E-6)to display in spreadsheet. They appear as zeros

I am attempting to write a program that will take conductivity measurements at regular temperature intervals. I am hoping to have the program control the temperature and then trigger the conductivity measurement at certian temperatures. I want all the temperature and conductivity data to be stored in a spreadsheet form that can be accessed when the entire test is completed. I have written the conductivity measurement portion and the values come up on the front panel, but they appear as zeros in the spreadsheet. I can add a multiplication step before building the array and then they are visible, but I don't want to have to change them all back each time. I also don't know how to get multiple sets in the spreadsheet without just copying over the first. Thanks for your time.

 

PS. Is there a way to save the whole vi and sub vis together? So it can be posted as one attachment? I am very new to labview so I will apoligize ahead of time for the newbie questions.  

0 Kudos
Message 1 of 2
(2,592 Views)

I am assuming you are using the Write to Spreadsheet File, which actually creates a text file, not an actual Excel spreadsheet. In this case you simply need to change the default format string. If you do not wire a format string, then the default is %.3f, which is 3 decimal places. Simply wire a string constant to whatever precision you need.

 

As for your other question: you can create a source distribution from a project and make the target an LLB, though it's usually easier to simply zip everything up. 

0 Kudos
Message 2 of 2
(2,586 Views)