How to configure the export waveform to spreadsheet file?

[dolphin11]

Hello, I'm new using Labview (v 8.0). I'm exporting some data to a file using a loop. I would like 1) To change the format of the data column 2) To get each set of data without a space between them The file data is appended. I can't see where to configure the symbol "export waveform to spreadsheet file", to modify the default Please, advice me if it is possible.  

[Nishant]

Hiii, Dolphin

                Can you please post the jpg file of your vi, that can give more explaination wat is happening and just give the explaination in the vi, and then prepare the jpg file so that, i can understand the explaination.3

         As i understand you are storing the data into some file but you want the data format to be changed in the file and you dont want space between which, either between two records, or between the data columns of different data type? those are some questions which are doubtful for me, once if you can post the jpg file, then it is possible for me to change it.

Thanks,

Nishant

[dolphin11]

Hi Nishant

Thanks for your answer. I just modified slightly my VI. I still can't modify the default parameters of the "export waveform to file" or the VI to obtain  a single time series with the desired format. May you help me with that stuff?

I'm sending you both the data and the VI.


dolphin11

[Nishant]

Hiii,

         Ya now i got your problem, what you can do is instead of writing your waveform to the file, you can first convrt into the array and ten you can write it using Open, Write and Close express vis. i have attached a vi and show you how you can change the waveform into the saler and then you can write it into the excel file, with the express vis, and i also have given you explainaiton inside, which can help you, let me hope that it will you.

           If you are using LabVIEW 7.1 or earlier version, then please attach your vi, i want to analyse it once, and if possible i also can make changes into it.

Thanks,

Nishant

[dolphin11]

Hello Nishant,

Thanks by your answer again. I'm just learning how to handle waveforms. I realized from your VI, that is not so direct to write the data of a waveform to a single column file. Why is not so clear how to modify the format of the exported waveform in my VI?

dolphin11

Hiii,

         Ya now i got your problem, what you can do is instead of writing your waveform to the file, you can first convrt into the array and ten you can write it using Open, Write and Close express vis. i have attached a vi and show you how you can change the waveform into the saler and then you can write it into the excel file, with the express vis, and i also have given you explainaiton inside, which can help you, let me hope that it will you.

           If you are using LabVIEW 7.1 or earlier version, then please attach your vi, i want to analyse it once, and if possible i also can make changes into it.

Thanks,

Nishant

[Nishant]

Hiii, Dolphin

          As i explained yu, wat u can do is use convert from dynamic data express vi and then convert your waveform data into the 2D array and then write it into the excel file, and another thing you can do is please post me your vi, i will change your vi, which is easy for both me and you!!!

Thanks,

Nishant

[dolphin11]

Hello Nishant

Great! I didn't realized that the trick for exporting a "waveform" was  to use "convert from dynamic data express", then "transpose", and finally "write to spreadsheet" for obtaining a single column time series (instead of using "export waveform" vi). That was quite more easy solution than what I was trying to do previously.

Thanks!

dolphin11

[Nishant]

Hiii, Dolphin

              I am glad to see that, you have get something out of this post, but the thing is have you got the solution you want, and i am again forcing you to attach your vi if you havent got the solution and send me exact format you want so that i can modify your vi, as you want.

Thanks,

Nishant

[jasonhill]

dolphin11,

Back in your first example, if you right-click on the loop tunnel and select "Disable Indexing" you will get the data in one waveform.  I suspect (based on the sample data) that you want all the appended waveforms, in which case you should use the "all waveforms" terminal from the Read Waveform from File.

Your second example is pretty inefficient.  Array transforms can be very memory intensive for larger arrays, especially when you further specify that it be transformed again on the file write.  The little grey dot on the the Convert From Dynamic Data express vi represents a coersion.  The wrong datatype is being supplied (waveform rather than signal) and labview is having to reserve even more resources to accomodate an additional data conversion.  Waveform > Signal > 2D array.  It is possible to convert an array of waveforms into a 2D array using "Waveform to XY Pairs"  Since the data comes in as a 1D array of XY clusters, it can be a little complicated to get into a 2D array.  Let me know if you are interested in a possible solution.

I wonder why you are writing and then immediately reading the file on each iteration of the loop.  This can be pretty time intensive, as you are constantly accessing the harddrive.  If all you want is to append the current wavform to the previous iteration, use "Append Waveforms"  you can put it in a for loop to append each waveform in the array.

Message Edited by jasonhill on 05-31-2006 08:19 AM

[dolphin11]

Hello Nishant,

I'm sending you the vi