This section describes the Microsoft Excel input format for the optimiser.
Excel input must be either an Office Open XML workbook (.xlsx) or macro-enabled workbook (.xlsm). Office Open XML binary workbooks (.xlsb) are not currently supported. Workbooks in the old Excel binary file format (.xls) are not supported.
The workbook should contain the sheets described in the following sections. Those sheets that are specified as “required” must be present in the workbook. The workbook may contain sheets other than those recognised by the DTO-Excel format. Such extra sheets are ignored by the optimiser.
Unless otherwise noted, sheets recognised by the optimiser may contain columns other than those required by the DTO-Excel format. Such extra columns are ignored by the optimiser.
Columns recognised by the optimiser may appear in any order.
All sheets must have a non-empty first row.
The optimiser will evaluate any formulas used in the workbook when it is loaded. Formulas must not refer to sheets in other workbooks.
Not all Excel functions are supported by the optimiser; appendix C lists the unsupported Excel functions.