cexcelwindowsvb.netlabview

importing flow meter reading to excel via serial communication port

I'll be getting readings from an flow meter to serial port via serial communication.

I need to automatically collect incoming flow rate readings at 1 minute intervals for every hour.

Then i need to automatically calculate an average for each hour.

The hourly averages are calculated using the readings collected at 1 minute intervals.

The averages should then be displayed in MS excel.

  1. Can i use Visual basic for applications and excel or should i use NI lab view?
  2. Should i use another method?

What is the best proven way to perform this?

Solution

  • I will be suggesting to use NI LabVIEW to connect to RS trough VISA. There are build in and additional libs to work with RS there. To export to excel you can use write to spreadsheet .vi or to do it professionally go with NI Report Generation Toolkit for LabVIEW.

    Please let me know if you need more info.