do not display zeros in excel cells

[DanNatCorning]

I have an application that is almost finished. I am using an ActiveX control to open an Excel spreadsheet on the front panel, populate it with the contents of a template, add some arrays to it and then perform some calculations.  The only thing I can't figure out is how to blank the zeros that appear when there are no values for some calculations. It's easy to do in Excel, either by not displaying zeros or by changing the font to white if the value is zero.  I just can't seem to figure out how to accomplish this in LabVIEW, using the properties and methods. Any help out there?

[MikeS81]

Hi DanNatCor...,

you can write an empty string to the cells which shall be empty.

Mike

[Jon_S.]

Hello Dan,

The default value for a numeric is zero.  Moreover, any property that you set to an array element is going to be applied to all of the array elements.  If you have a numeric array you cannot have blank values.