This document provides an overview of the appropriate steps to follow in order to interactively edit Technical Data Management (TDM) or Technical Data Management Streaming (TDMS) files with Microsoft® Excel® using the TDM Excel Add-In. To download the free TDM Excel Add-In, please see TDM Excel Add-In for Microsoft Excel Download.
By using this procedural document as a guide, modifications made to TDM files using Excel will maintain the integrity of the data file’s original schema. This will enable you to save the edited data set as an Excel file and read all its data and properties using NI DIAdem or NI LabVIEW and the free ExcelTDM DataPlugin, which you can download for free at ni.com/dataplugins.
Occasionally after TDM data files are written, manual modifications or expansions to the data file must be made. Users can open TDM files in Excel using the free TDM Excel Add-In and save their edits to a new Excel file. As long as modifications made to the data or properties in the new Excel file continue to follow the original data layout (as outlined in this document), the new Excel file can then continue to be read from more appropriate postprocessing software such as NI DIAdem using the free ExcelTDM DataPlugin. This process of manual modification using Excel may be repeated indefinitely as long as the schema is maintained.
An overview of the architecture is displayed in Figure 1.Figure 1. Users can manually modify a TDM file in Excel using the TDM Excel Add-In and then read the modified Excel file using the ExcelTDM DataPlugin.
When TDM files are opened in Excel using the TDM Excel Add-In, all file properties are stored within the first worksheet of the workbook, as shown in Figure 2.Figure 2. File properties are stored at the top of the first worksheet of the workbook.
All file properties are stored in the first two rows of the worksheet as name-value pairs, where the name for the property is contained within the first row (Row 1) and the value for the corresponding name is stored within the same column in the second row (Row 2). In the example shown in Figure 2, the Title file property is given the value DIAdem example data set.
To add new file properties to the data file:
Figure 3. The manually added “Test_Fixture” property has been given the value “D174-A”.
When TDM files are opened in Excel using the TDM Excel Add-In, all group properties are stored within the first worksheet of the workbook, as shown in Figure 4.Figure 4. Group properties are stored immediately below file properties within the first worksheet of the workbook.
All group properties are stored immediately after the file properties in the worksheet. Like file properties, group properties are stored as name-value pairs, but since every TDM file may have an unlimited number of channel groups, it is possible for each name to have multiple value entries (each corresponding to the value of the property for a specific channel group).
Property names for group properties are stored in Row 4 in the first worksheet in the workbook, where the property in the first column (A) represents the name of the channel group represented by that row. Each subsequent row contains the values for the group properties for that row’s channel group. In the example displayed in Figure 4, the Test_Operator group property contains the value Paul for both the QT_32-1_Lower and QT_32-1_Upper channel groups.To add new group properties to the data file:
Note: to remove a single group property of an individual group, simply delete the content value in the cell located in the column corresponding to the desired property name and the row corresponding to the individual group.Figure 5. The manually added “Location” property has been given the value “Austin” for each of the two channel groups in the file.
When TDM files are opened in Excel using the TDM Excel Add-In, all channel properties are stored within the first worksheet of the workbook, as shown in Figure 6.Figure 6. Channel properties are stored immediately below group properties within the first worksheet of the workbook.
All channel properties are stored immediately after the group properties in the worksheet and are organized in the worksheet by channel group. Like file and group properties, channel properties are stored as name-value pairs, but since every TDM channel group may have an unlimited number of channels, it is possible for each name to have multiple value entries (each corresponding to the value of the property for a specific channel in the group).
In the example displayed in Figure 6, the Unit channel property contains the value °C for all ten channels in the QT_32-1_Lower channel group.
To add new channel properties to the data file:
Learn why you should move beyond Microsoft Excel for measurement data postprocessing
Collaborate with other users in our discussion forums
A valid service agreement may be required, and support options vary by country.