Writing a 2D array into Excel

[LeeBowers1]

I am using Labview 8.0 and using from the examples set cell value I am writing a 2D array into excel. The array is 3 coulumns by 6000 rows.

Works fine but take ages .......

I looks as if you can write an array rather than each point by point. Looking through the help it seems you can use the 'values' property as opposed to 'value2' property, but I cant seem to get to this. I am I belive setting the range property correctly by specifying the start i.e A1 and then A6001 and the value2 will seem to accept an array as well as a single point ?

What am I doing wrong ???

Any help would be great, thanks

Lee

[JeffOverton]

I'm not sure how you're using a property node to write a spreadsheet, but I would suggest you look at the Write to Spreadsheet vi. Just wire your 2D array and give it a path and name.

[LeeBowers1]

Thanks for the reply, but as always seem to be the case you end up working it out 2 minutes after you've asked the question. 🙂

Basically I had to use the 'cells' property in conjunction with the 'range' property to overcome this, and then I could correctly pass it a 2D array.