TDM Excel Add-In Tool for Microsoft Excel User Guide

Publish Date: Jun 27, 2017 | 37 Ratings | 3.86 out of 5 | Print

This application note outlines how to use the TDM Excel Add-In tool to load NI *.TDM and *.TDMS files into Microsoft Excel.

To download and install the TDM Excel Add-In go to the TDM Excel Add-In Download Page.

Operation: Install the TDM Excel Add-In and open Microsoft Excel and you will see the following custom toolbar:


Loading TDM files into Excel: Simply click on the symbol Import a TDM(S) File, this launches a file open dialog where you select which TDM file you wish to open in Excel.

Configuring the TDM Excel Add-In: You can choose which properties are loaded into Excel at the root, group and channel levels, this includes custom properties. To launch the configuration dialog pictured below, click on the symbol Configure TDM Importer.



Selective Loading:
For data files with more than one million values per row for Excel 2007, the TDM Excel Add-In permits you to choose the part of the file you want to work with in Excel.

 

Automation:
Use the TDM Excel Add-In COM-API to load TDM/TDMS files into Microsoft Excel using VBA.


Note:If you want to read the Excel files created with the TDM Excel Add-In and maintain the same worksheet layout, use the ExcelTDM DataPlugin.  Please refer to Editing TDM(S) files with the TDM Excel Add-In for more details.

 


Additional Information:

  • Use ‘Open with>>Excel Importer’ or double-click from Windows Explorer to open a TDM/TDMS file in Excel
  • Use VBA and the TDM Excel Add-In COM-API to automate loading of TDM and TDMS files into Excel
  • Each TDM/TDMS file loaded into Excel creates a new Excel Workbook
  • Each group in the TDM/TDMS file is loaded onto a separate Excel Worksheet
  • Each channel of a group is loaded as a separate column in the groups Worksheet

 

Related Links:
Download the TDM Excel Add-In for Microsoft Excel
TDM Excel Add-In: COM Automation
Learn more about the TDM and TDMS format
Editing TDM(S) Files with the TDM Excel Add-In
Moving Beyond Microsoft Excel for Data Analysis and Reporting
TDM Add-In for OpenOffice.org Calc
Manage and process TDM and TDMS files with NI DIAdem

 

Back to Top

Bookmark & Share


Ratings

Rate this document

Answered Your Question?
Yes No

Submit