LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel tdms add in not showing data in spreadsheet

I've succesfully installed the Excel TDM Add In on several computers.

 

The latest computer I tried to set up lets you select a TDMS file to import but the channel data does not appear. I've uninstalled and reinstalled several times with no luck. There are two example files attached. One from a successful import and another that is missing the data. Both files used the same source TDMS file which is also attached.

 

It is running Windows 7 64-bit with MS Office 2010 - no different from the computers that the add in works on.

 

Any idea what could be wrong?

0 Kudos
Message 1 of 14
(3,928 Views)

What you forgot to mention is what process did you do to import the one that worked, and the one that didn't work?

 

Was it the same process?

 

All I did was double click the TDMS file.  By default it will open it with the TDMS Importer and open it in Excel.  For me the import was fine and I had all the data that your Successful version did.

 

If you are interested in automating this feel free to try out my importer utility.

 

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

 

It relies on the TDMS Excel add-in but it allows for other formatting, and freezing rows/columns in the data as well as providing an alternative summary page.

0 Kudos
Message 2 of 14
(3,910 Views)

Hi Rnojima,

 

We are trying to reproduce the problem.

 

What was the version of your Excel TDM Addin?

Can you please delete the .tdms_index before doing the importing, then check if any .log file appears?

 

Did the machine have any other NI software installed, e.g. DIAdem, LabVIEW? Which version?

Can you please check if they can read the tdms file correctly?

 

Thanks,

Mavis

0 Kudos
Message 3 of 14
(3,889 Views)

I use Scout TDMS Editor, it's a good tool and it's free, and you can also export to Excel.

 

Hope it helps


We have two ears and one mouth so that we can listen twice as much as we speak.

Epictetus

Antoine Chalons

0 Kudos
Message 4 of 14
(3,878 Views)

Hoovah:

I did the same. Double clicked on the file and let the importer do its thing. I also tried using the TDMS add In button to open the file from within Excel with the same results - no data.

 

Mavis:

The computer had no NI software on it before installing the add in. I installed this NITDMEXCEL_3-5-1.exe.

0 Kudos
Message 5 of 14
(3,864 Views)

Not that I think it makes a difference but I used version 3.5.0.0.

 

Did you try deleting the Index file too?  I didn't have to but NI suggested it.  Also some times when an import fails the importer will make a text file in the same directory as the TDMS file that gives low level debugging information that NI can use to determine why it failed.  Did a new text file get made after the import failed?  If so post it.

0 Kudos
Message 6 of 14
(3,859 Views)

I'll try deleting the index file later today.

0 Kudos
Message 7 of 14
(3,858 Views)

Here's the text file created when I deleted the index file.

0 Kudos
Message 8 of 14
(3,833 Views)

The datatype of those problematic channels is extended-precision floating-point, that is found not supported by the standalone TDM Excel Addin 3.5.1.

We are working on a fix and will keep you updated. 

 

Thanks for reporting the issue.

 

Best Regards,

Mavis

0 Kudos
Message 9 of 14
(3,809 Views)

The new version is available for download. TDM Excel Add-In for Microsoft Excel Download

Please let us know if that works for you.

 

Thanks,

Mavis

0 Kudos
Message 10 of 14
(3,763 Views)