Excel file converter, About the mts excel file converter, Appendix 20 – MTS Series 793 Application User Manual
Page 557: Excel file converter 557, Ion, see, Appendix 20, “excel file converter
About The MTS Excel File Converter
MTS MultiPurpose TestWare®
Excel File Converter
557
Appendix 20
Excel File Converter
About The MTS Excel File Converter
The MTS Excel File Converter is a utility that optimizes MPT data files for
viewing with Microsoft
®
Excel.
When this utility is installed and enabled, Microsoft Excel can interpret
MultiPurpose TestWare (and Basic TestWare) data files more intelligently than it
normally interprets text files.
For example, the MTS Excel File Converter can be used to:
•
Permit loading an unlimited number of rows of data—up to the memory
capacity of your system. (Microsoft Excel has a limit of 65,535 rows of data
on each sheet.) The converter splits the data into multiple sheets.
•
Scan the data file for certain labels and use smart processing to determine
when data should be written to a new worksheet. (This keeps your data
organized more efficiently.)
•
Enable .dat, .t31, and .f31 files to be browsed and opened directly from the
Microsoft Excel Open window.
Compatible data file
formats
The Excel File Converter works best with tab-delimited data files (Excel format).
If you want to use the Excel File Converter, you should make sure your data files
are written in the Excel format.
Comma-delimited data files (Lotus format) can be processed by the converter,
but the format of the resulting spreadsheet may not be desirable. Space-delimited
data files (Plain format) will not be processed by the converter.
Note
Files in "Lotus" format will be read in, but the format of the resulting
spreadsheet may not be desirable. If your Windows operating system’s
regional settings specify that decimal points should be commas (as is
typical in parts of Europe) the "Lotus" format will not be readable. Use
the "Excel" format whenever possible.
For more information
For more about MPT data files, see