calling the recorded excel files

[Monireh]

Hello

I am measuring some physical quantities and record them into excel file day by day using LabVIEW. now I want to call the recorded data for each day and find the average for each day and then I would like to sketch the variation of that quantity in each day and each month(based on the average of each day). I would be very grateful if you can please guide me

Looking Forward to recieving from You

[Matteo_Bax]

Hi,

use the Read From Spreadsheet File VI read from your Excel Files. The LV help desribes pretty good how to use this VI.

 

Message Edited by teobax on 01-25-2010 03:15 AM

[Monireh]

Hi,

Thanks for helping me; but can you please also tell me how can I find the average of the read file? because the output of read from spreadsheet.vi is 2D array.

Looking Forward to Recieving from You

[Dennis_Knutson · Accepted solution]

First, if you are still using the code in your previous post, stop calling them Excel files. As you were told, you are creating a text file.

Second, you would use the Index Array function to get the row or column that you want. Just wire the result up to the Mean function.