Read and export from excel

[drmotsei]

Hi All

Can someone please assist me in this regard:

I have a VI that continuosly measure and log data from two frequencies, frequecy A and frequncy B interchangeably and then save the logged data in excel spreadsheet with a time stamp.

the problem i am having is that both frequncies and associated data, which differs, are logged vertically below each other and associated data horizontally in line with each frequency.

I would like to have a VI that can seperate these two frequncies like data from frequency A be looged in one tab of the spreadsheet and that from B on the other tab of the same spreadsheet.

[RahRahMirez]

Just checking, you're using LabVIEW and not Measurement Studio, correct?  I just see that your post is under MS for VC++.

This seems like a perfect application for TDMS.  You can log multiple channels of data into a spreadsheet which you can then access easily.  You'll need a plug-in for Excel (link below).  There's also plenty of community examples to help you figure out how to log multiple items.

1. TDMS Format Overview:

http://www.ni.com/white-paper/3727/en/

2.  TDM Excel Add-in:

http://www.ni.com/example/27944/en/

Look at the examples in LabVIEW help, they'll help you configure your TDMS channels correctly to write different datasets to different places in your spreadsheet.

[drmotsei]

Thank you for your assistance. 

I believe i did not phrase my question properly. Please allow me to rephrase.

I have a Labview system which acquires and log data from two frequencies (279750 Hz and 295750 Hz) and export it to excel as shown below.

As can be seen from the caption above, data from these two frequencies is presented in one excel sheet, one after the other. I would like to have a system that can help me separate data as shown in the two images below, which i did manually, whereby all data in associated with a frequency of 279750 Hz (black) is logged on one sheet of the spreadsheet and the one associated with 295750 Hz frequency (red)  on the other sheet of the same spreadsheet.

Please aasist.

[RahRahMirez]

I think I understand your question now, drmotsei.

What method are you currently using to log data to Excel?

[RahRahMirez]

In any case, I think the following link will help you find examples of writing data to multiple sheets within the same Excel file:

http://search.ni.com/nisearch/app/main/p/bot/no/ap/tech/lang/en/pg/1/sn/catnav:ex/q/excel%20write/

[drmotsei]

Thanks a lot Chris. much appreciated.

Will try to work around the examples you gave and will be in touch again.

Drmotsei