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!
Solved! Go to Solution.
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…
I would do something like this if the rate of data recording is as slow as you said.
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.
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!
My problem is not the rate of data recording. I am unable to retrieve my data using Excel.
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.
Do you mind to share your vi? I couldn't find some of the block. I am still learning LabVIEW anyway. Thanks!
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!