LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Write to spreadsheet 2D gives me zeros?

Solved!
Go to solution

I have an array that I built going into a write to spreadsheet and although the first column comes out allright, the next three are all zeros? Could this be because they are such small numbers? and if so How do I remedy this. Here is my VI 

0 Kudos
Message 1 of 7
(3,133 Views)

the subvis are missing. Can you upload the subvis too?

0 Kudos
Message 2 of 7
(3,123 Views)

Read the help for the function and change the format input.

0 Kudos
Message 3 of 7
(3,121 Views)

Hey Pazmush

 

I'm trying to open your VI to see whats going on, but missing some sub VIs, can you attach them for me?

0 Kudos
Message 4 of 7
(3,118 Views)
Solution
Accepted by topic author Pazmush

@Pazmush wrote:

I have an array that I built going into a write to spreadsheet and although the first column comes out allright, the next three are all zeros? Could this be because they are such small numbers? and if so How do I remedy this. Here is my VI 


1) press crtl-h to open the help window.

 

2) Float over the write to spreadsheet function.

 

3) Observe input at the top labled "format".

 

4) Right click on SS function and choose show help.

 

5) Read explanation about the format input.

 

6) Change the format input by creating a constant and editing same for your needs.

 

If the format is not the issue. create a probe for that data and check to see what your real data is. It just may be zero.

 

Ben

Retired Senior Automation Systems Architect with Data Science Automation LabVIEW Champion Knight of NI and Prepper LinkedIn Profile YouTube Channel
0 Kudos
Message 5 of 7
(3,114 Views)

here you are

Download All
0 Kudos
Message 6 of 7
(3,077 Views)

never mind, ben is the winner! I am a fool!

0 Kudos
Message 7 of 7
(3,072 Views)