Microsoft Office Tutorials and References
In Depth Information
Excel 97-2003 Template (XLT)
This is a legacy template format used by previous
versions of Excel.
Excel Add-In (XLAM) This is a special type of VBA-enabled workbook that can be
loaded as a supplemental program in Excel.
Excel 97-2003 Add-In (XLM) This is a legacy type of VBA-enabled workbook that
can be loaded as a supplemental program in Excel.
In addition to these “XL” file types, there are two XML file types that are somewhat related.
XML Spreadsheet 2003 (XML) is the previous XML file format provided as an option in Excel
2003. Another format, XML Data (XML), shares the same extension but produces entirely
different results. This format is a proprietary XML format that requires specific
programmatic data maps to be present before you can even save the file. You’ll know if you need it.
INSIDE OUT What is XML?
The Excel 2013 (and Excel 2010 and 2007) file format is based on XML, which was
created as a way for structured data to be interpreted and was originally envisioned for
use on the web. Excel 2003 introduced XML as an optional file format; Excel versions
from 2007 through 2013 use XML as their default format, indicated by the file name
extension .xlsx . Based on a file format specification called SpreadsheetML , Microsoft’s
implementation of XML has undergone significant improvements since being
introduced. At first, the format didn’t have, shall we say, sufficient language skills to
interpret all of what Excel could do, including objects such as charts and graphics. Now,
SpreadsheetML can handle everything Excel can dish out and does so in a much more
efficient manner than the old XLS format, resulting in significantly smaller file sizes. The
new XML formats also provide improved recovery of damaged files and better overall
security. And because SpreadsheetML is part of an overall extensible Open XML format
initiative, it’s easier for developers to create ways to hook things together.
For some additional information about XML, see “Working with XML files” in Chapter
25, “Working with external data.”