Property "Value" for XL spreadsheet not available in LabVIEW 8

[Will_Crowe]

Dear all,

I have a VI that writes a large array of data to a spreadsheet. It uses an invoke node to select the "Range" of the spreadsheet to write to. This Range is then wired to a property node. The array is then wired to the property "Value", which reads all of the numbers into the active spreadsheet. However, when I upgraded to labview 8, the property "Value" was no longer selectable. What property should I select in Labview 8 to get the same functionality?

Regards,

Will.

[Aitortxo]

Hi Will:

Did you upgrade only to LabView8?. May be you have also upgraded to Office2003, in which there is no VALUE property.

I haven't moved to LV8 yet, so I don't know if the problem can also be there, but I had that problem when upgrading to Office2003. In Office2k there were both VALUE and VALUE2.

Hope it helps,

[Will_Crowe]

Hi Aitortxo,

Thank you for your suggestion. Yes, I did recently upgrade to office XP as well. This may be the problem. The 'Value2' property is still available. Can I use this instead of 'Value'?

Barry

[Aitortxo]

Sorry, Will, I didn't mention in my previous post. Yes, VALUE2 is the property you want.

There was some distinction between value and value2, but for most of the cases was the same. I think MS thought nobody was using it yet. But we were.

Hope it helps,