TDM Excel Add-In Tool for Microsoft Excel User Guide
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 and open Microsoft Excel and you will see the following custom toolbar:
Note: If you do not see the TDM Importer toolbar in Excel, click View»Toolbars»Customize and select TDM Importer. Excel then displays this 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 65 thousand values the TDM Excel Add-In permits you to choose the part of the file you want to work with in Excel. Maximum number of rows is one million for excel 2007, so there will not be a need to break TDM files with less than one million row.
Additional Information:
- The TDM Excel Add-In supports Excel 2003 and higher.
- Each group in the TDM file is loaded onto a separate Excel Worksheet.
- Each TDM file loaded into Excel creates a new Excel Workbook.
Print
Reader Comments | Submit a comment »
Legal
This tutorial (this "tutorial") was developed by National Instruments ("NI"). Although technical support of this tutorial may be made available by National Instruments, the content in this tutorial may not be completely tested and verified, and NI does not guarantee its quality in any way or that NI will continue to support this content with each new revision of related products and drivers. THIS TUTORIAL IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND AND SUBJECT TO CERTAIN RESTRICTIONS AS MORE SPECIFICALLY SET FORTH IN NI.COM'S TERMS OF USE (http://ni.com/legal/termsofuse/unitedstates/us/).