Academic Company Events NI Developer Zone Support Solutions Products & Services Contact NI MyNI

Document Type: Example Program
NI Supported: Yes
Publish Date: Sep 14, 2009


Feedback


Yes No

Related Categories

Related Links - Developer Zone

Related Links - Products and Services

TDM Excel Add-In for Microsoft Excel Download

27 ratings | 4.70 out of 5
Print

Downloads

Filename: tdm_excel_add_in_31.exe
Requirements: View

Using the FREE TDM Excel Add-in for Microsoft Excel, you can load and work with TDM and TDMS files in Excel.

Supported Features:

  • The TDM Excel Add-In supports Excel 2003 and Excel 2007.
  • The TDM Excel Add-In supports TDMS 1.0 files and TDMS 2.0 files.
  • Each group in the TDM file is loaded onto a separate Excel Worksheet.
  • Each TDM file loaded into Excel creates a new Excel Workbook.
  • COM-API to load TDM/TDMS files into Excel using VBA


FILE EXTENSION: *.TDM; *.TDMS
DIRECTION: Read / ---
LAST CHANGE: September 08, 2009 [3.1.0.25]

 

 

 

Installation Instructions

  1. Download the attached file referenced in this document titled tdm_excel_add_in_31.exe.
  2. Double-click on the file tdm_excel_add_in_31.exe.
  3. Follow the installation dialogs.
  4. After the installation of the TDM Excel Add-In on Microsoft Vista you need to start Microsoft Excel at least once using administrator privileges.

 

Related Links:
TDM Excel Add-In for Microsoft Excel User Guide
TDM Excel Add-In: COM Automation
Learn more about the TDM and TDMS format
Manage and process TDM and TDMS files with NI DIAdem
TDM Add-In for OpenOffice.org Calc

Requirements


Filename: tdm_excel_add_in_31.exe

Software Requirements


Application Software: DIAdem Development System 10.2, Measurement Studio Standard Edition 8.6, LabWindows/CVI Base Development System 9.0, LabVIEW Base Development System 2009
Additional Software: Microsoft Excel

 
27 ratings | 4.70 out of 5
Print

Reader Comments | Submit a comment »

Does not fully support excel 2007 row limit
Excel 2007 supports up to a million rows (1,048,576) While Excel 2003 and below only supported roughly 65,000 rows. The tdms importer limits you to the old 65,000 rows and doesnt allow the new limits! While this is an improvement over the older version of the plugin which would simply crash if you tried to import more than 65,000 values, this still needs to be fixed. I want to import a big tdms file into excel. I am recording at 200Hz for an hour. That's 720,000 rows. Excel can handle it. TDMS importer cannot.
- kyle.ramsdell@dot.state.fl.us - Sep 21, 2009

Is this supposed to work with Excel 2007?
I can't get it to install (I have Excel 2007). The installation runs, I accept the license agreement, then at the next screen it says "No software will be installed". No options to continue.
- Jeffrey Scharpf, Milwaukee Electric Tool. jeffrey.scharpf@milwaukeetool.com - Apr 6, 2009

For some reasons, the Add-Ins tab doesn't show up for me in Excel 2007 even though the addin appears to have been read at startup. Any idea why the Add-Ins tab is not showing up? Note, I disabled the addin, removed the addin, rebooted, re-installed, and reran Excel but this didn't work.
- Anthony Marshall, Intel Corporation. anthony.marshall@intel.com - Feb 11, 2009

Should be available for Excel 2000
This should really be available for 2000 as well.
- braden Giacobazzi, NASA GRC. bgiacoba@mtu.edu - Jan 28, 2009

how to allow all users to use tool?
Is there a way to make it so that non-administrator users can use the tool? From what I've seen only the installer (admin) can access the tool. I'd like all users to be able to use the tool once it has been installed by an admin.
- Nov 17, 2008

needs option to not load certain data
It would be very helpful if there was a property you could set that would cause it not to load particular data. For example, I have a file that has my spreadsheet data saved in it, but I also save images as a byte array. If there was a special group property you could set that would disable this application from loading the image data then it would stop excel from loading massive amounts of data.
- Sep 25, 2008

TDM Excel Add-in Capabilities
The currently posted TDM Excel Add-in works with Excel versions "2003 and higher", which includes version 2007. The currently posted TDM Excel Add-in does correctly import date/time channels into Excel-- note that Excel tracks date/time as the number of fractional days since about 1900. You may need to change the formatting of the datetime channel column in Excel to see the datetime information the way you want it. An error report has been entered for the TDM Excel Add-in for the 256 column limitation in Excel 2007. Hopefully a new version will be posted soon which removes this artificial limitation.
- Brad Turpin, National Instruments. brad.turpin@ni.com - Sep 24, 2008

How about a version for Excel 2007
- Sep 12, 2008

256 Channel limit
Note that there is a 256 channel limit (per tab) in Excel. This add-in will only display the first 256 channels. You can probably get around this by writing code to split the TDM file into multiple smaller files or create your own Excel converter VI that would place 256 channels per tab. Or you could just use DIAdem...you know you want to...all the cool people are doing it. (-;
- Andrew Soukup, SpaceX. asoukup@spacex.com - Mar 18, 2008

Exporing Data
I think it would be useful to have the possibility to build the excel file directly from LabView. Regards.
- LUCIANO MANARA, PERONI POMPE SPA. lucianomanara@peronipompe.it - Nov 20, 2007

Needs Timestamp Data (#2)
I confirm that a time stamp data column would be very useful, if not necessary, also for my company (we manufacture hydraulic pumps, mainly for chemical or oil and gas companies); in fact, also for legal/contract issues, we have to recall the exact time in which a variation of the conditions happens. Thank you very much for your attention.
- Luciano Manara, Peroni Pompe SpA. luciano.manara@peronipompe.it - Oct 31, 2007

Needs timestamp data
This would be very helpful for my application, but the file data is transported to excel without any timing information, making it difficult to graph the results correctly. It would be great if the first column on every sheet contained timestamp data for each row. I don't suppose the source code is available so that we can add improvements ourselves?
- Jason Dunham, SF Industrial Software, Inc.. dunham@sfis.com - Sep 6, 2007

 

Legal
This example program (this "program") was developed by a National Instruments ("NI") Applications Engineer. Although technical support of this program may be made available by National Instruments, this program 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 program with each new revision of related products and drivers. THIS EXAMPLE PROGRAM 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/).