IDtExcelProviderEx.Format

Fore Syntax

Format: String;

Format: string;

The Format property determines format of the source file.

Available values:

XLS. Binary files format Excel 97 - Excel 2003 (BIFF8).
XLSX. Standard files format Excel 2010 and Excel 2007, based on 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. The Excel 2010 and Excel 2007 format on basis of XML with macro support. Allows to save macro code VBA and macro sheets Microsoft Excel 4.0 (XLM).
XLT. Binary file format Excel 97 - Excel 2003 (BIFF8) for Excel templates storage.
XLTX. Standard files format Excel 2010 and Excel 2007 for Excel templates. Does not allow to save macro code VBA, and also macro sheets Microsoft Excel 4.0 (XLM).
XLTM. Files format Excel 2010 and Excel 2007 for 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.