LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Average excel column

Hi everybody!
I m reading different excel files and take data in to array.
Now i want to average each excel column separately.
Is there any method in Active x so i can directly average excel column?
or i want to average the array?
How to average the array?
 
Jenilia D
Canberra
Australia
Jenilia D'souza
0 Kudos
Message 1 of 3
(2,400 Views)

Hi

If you have the data in a 2D array in LV, you can easily use Mean.vi.

Just have a look at the attachment.

Hope this helps.

Thomas

Using LV8.0
--------------------------------------------------------------------
Don't be afraid to rate a good answer... 😉
--------------------------------------------------------------------
0 Kudos
Message 2 of 3
(2,393 Views)

Hi,

It can be simply done in programming Smiley Very Happy so why do you need a activeX for it,add the numbers in the array by putting it in a loop and divide it by the total number of elements .Smiley Wink

vicky

0 Kudos
Message 3 of 3
(2,392 Views)