Writing an array to a column in excel through automation without using set cell value.vi in a loop .

[sumitrishi]

is there any way of doing the above. It basically makes the operation too slow if the data is large and there are several columns to be filled . Can Range not take the array as input value ?

[Joe_Guo]

using method "Range" you can write a 1D or 2D array. It should be much faster than writing cell by cell.

Joe Guo

[sumitrishi]

Hi Joe,

Can you send me a working VI want to see it working I tried the same stuff but it dint work.I mean it dint give any error but it dint fill anything in there either .
Thanking you in anticipation.

[Joe_Guo]

The range inputs (cell1, cell2)must be valid.

Anyway, a subvi is attached, you can use it in your code.

If it still does not work, you could post your code here.

Joe

[sumitrishi]

Thanks a lot Joe!!
I was using value instead of value2. If I have to account for both excel versions (before 2000 as well) on which property should I base my case structure?

[Joe_Guo]

It is not possible to include two different versions of the same property in your code, as Labview load the registered COM from windows and there is only one Excel available for it, namely, the one most recently installed.

You could build your code on two machines, one with Excel 2000, and another one with Excel 97, and distribute them.

Or you can build it on the Excel 97 machine, it might work with Excel 2000. My colleague had done this, but I think we were just lucky. Remember that every Excel version has some new functions.

Joe