09-22-2014 03:09 AM
Hi all,
Currently I am using NI USB 6255 to acquire data from a power supply.
I would like to collect the voltage of the power supply at every seconds. Currently, I am able to do so if the file path is to a .txt file. However, I want to record all my data directly into excel. Does anyone knows how to do it? I appreciate you help very much.
Hereby I attached my vi. A million thanks!
Regards,
Vanessa
Solved! Go to Solution.
09-22-2014 03:16 AM - edited 09-22-2014 03:17 AM
Hi Vanessa,
WriteToSpreadsheetFile does what it's name implies: it writes data to spreadsheet files.
Excel can open these spreadsheet files, when the measurement has finished.
When you want to input "live" data into an Excel sheet you need to use ActiveX remote control of an Excel application. You will find examples in the forum, it may be worth to look for that special Excel thread…
09-22-2014 03:24 AM
I would do something like this if the rate of data recording is as slow as you said.
09-22-2014 06:35 AM
If you want a true xlsx file, then try using the Write Measurement File express VI. It doesn't look like it uses ActiveX, but it will write files in the xlsx format.
09-22-2014 07:55 AM
Hi GerdW,
Perhaps my question is not clear enough. Yup, I want to view my data after the programme has stopped. When I tried to open using Excel file, it says the data is unrecognizable. However, if I open using a text file, I could see my data clearly.
In that case, what changes should I made to my current program?
Thank you so much!
Regards,
Xin Wen
09-22-2014 07:56 AM
Two comments:
09-22-2014 07:57 AM
Hi Anand,
My problem is not the rate of data recording. I am unable to retrieve my data using Excel.
Vanessa
09-22-2014 08:00 AM
If you save the data as a .csv file as I have shown in my example, I am sure you will be able to open the file using Excel. I do it all the time.
09-22-2014 08:25 AM
Hi Anand,
Do you mind to share your vi? I couldn't find some of the block. I am still learning LabVIEW anyway. Thanks! 🙂
Vanessa
09-24-2014 02:59 AM
Hi Anand,
Do you mind to tell me what is the array block (whereby the output is connected to write to text file) you have used in your design? I really appreciate your help. Thanks!
Vanessa