Read TDMS File and convert to Excel

[Birdy830]

I am using a vi which outputs a TDMS file, I would like some help or a copy of a vi which would read my TDMS file and convert it to a Excel file. Regards Birdy830

[.aCe.]

Try these:

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

https://decibel.ni.com/content/docs/DOC-22639

[Hooovahh]

Doing the process manually is much for flexable then using the TDMS Excel Add-in but also much slower.  When ever possible I use the Add-in version for speed, and then modify the excel file using ActiveX after the import is complete.

Here is a thread talking about how this can be done using the Add-in http://forums.ni.com/t5/LabVIEW/Convert-Import-TDMS-to-Excel/td-p/1088746

[Birdy830]

Hi, I succesfully installed the add in to convert the TDMS file to Excel, as you can see from the image I dfont have any "Timestamp" relating to the recorded data. Can anybody shed any light on this ?

[Hooovahh]

---

@Birdy830 wrote:

Hi, I succesfully installed the add in to convert the TDMS file to Excel, as you can see from the image I dfont have any "Timestamp" relating to the recorded data. Can anybody shed any light on this ?

---

Well did you write any timestamp data to your file?  If I write a string to a TDMS file how is it supposed to know what time that string should have associated with it?  For this reason I usually write my own TimeStamp channel with an array of times that correlates to the array of data values read.

If you wrote the data as a Waveform then you should know that the T0 and DeltaT is contained in the waveform data type.  This information is stored but not as channel data, it is stored as TDMS properties.  If you go to the first worksheet in the XLXS file you should see tables that are a little criptic I admit, but it should state the start time of the samples, and the delta between samples which from this you can infer when each sample was taken.  Again for me I like to see the time as a the first channel so I write it my self.  Then I will lock the first Column and Row in Excel that way you can always see the signal names at the top and the times they were taken on the left.

[Dennis_Knutson]

Don't mark the thread as solved if you still have questions. Remove that or stay a new thread.

Posting an image of an Excel file says nothing of how you are writing. You've been told how to do a write and if you don't understand, at least post an image of the block diagram or the actual VI.