NULL value to Excel from 2D Array.

[Huub Severin]

Hi,

I use LabVIEW for some speed measurements. Sometimes it happens that my
software was not able to calculate a speed or it finds the found value not
worth mentioning, and that is OK.

And after the measurements I write the results to Excel in a 2D array using
DDE. But when there is no speed recorded Labview fills up the empty spaces
with zero values. But I don't want that because it will affect my statistics
like the mean.

Is there a way to write NULL (empty) values to excel instead of the 0?

Thanx in advance.

Illustration:

(x) (y) VALUE
1 2 23.5
2 3 45.78
3 4 <----- Here I don't want LabVIEW to put a
zero (0) but an empty space.
4 5 12.23

[Marshall GaTech]

Don't post the same question twice, especially when it has already been answered.
http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=506500000008000000B14A0000&USEARCHCONTEXT_CATEGORY_0=_49_%24_6_&USEARCHCONTEXT_CATEGORY_S=0&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0

🙂