tdms files in excel

[adamharden25]

I have used a NI c-RIO 9075 to log data in a TDMS file. The wirte to a Measurement file was used and all the data saved to a file of my choice. The issue is that when i open the file in excel each data point is saved in a different worksheet and there is so much data that it takes several minutes to open the file. Is there a way around this issue without redoing the tests? 

[PaulG.]

Save your TDMS file as an Excel file. Report tool kit gives you the ability to open a workbook and get data from one sheet. Take the sheets of data and save each sheet as a seperate excel file.

[crossrulz]

---

adamharden25 wrote:  The issue is that when i open the file in excel each data point is saved in a different worksheet and there is so much data that it takes several minutes to open the file. Is there a way around this issue without redoing the tests? 

---

That sounds like you wrote the file wrong.  Each wooksheet should be a different Group.  So if you change your group for each sample, you will get a different worksheet for each sample.

Can you post any code and/or a TDMS file for us to look at?

[Hooovahh]

If you want to automate the TDMS to XLSX conversion I made a tool.

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

Of course after this import is done you may want to manipulate the data some more.  It sounds like you aren't satisifed with how TDMS is displayed in Excel and I suspect the root of your problem is with how the TDMS is made, and has nothing to do with Excel.

Post the part of your code doing the logging if you are having issues.