Format: String;
The Format property determines format of the source file.
Available values:
XLS. Binary file format Microsoft Excel 97 - Excel 2003 (BIFF8).
XLSX. Standard file format Microsoft Excel 2010 and Microsoft Excel 2007 based on the XML language. Do not save macro code Microsoft Visual Basic for applications (VBA) and macro sheets Microsoft Office Excel 4.0 (XLM) in this format.
XLSM. Microsoft Excel 2010 and Microsoft Excel 2007 format based on XML with macro support. Allows to save macro code VBA and macro sheets Microsoft Excel 4.0 (XLM).
XLT. Binary file format Microsoft Excel 97 - Microsoft Excel 2003 (BIFF8) for Excel templates storage.
XLTX. Standard file format Microsoft Excel 2010 and Microsoft Excel 2007 for Microsoft Excel templates. Does not allow to save macro code VBA, and also macro sheets Microsoft Excel 4.0 (XLM).
XLTM. Microsoft Excel 2010 and Microsoft Excel 2007 format for Microsoft Excel templates with macro support. Allows to save macro code VBA and macro sheets Microsoft Excel 4.0 (XLM).
The example of use is given in description of the IDtExcelProviderEx.File property.
See also: