2 Microsoft Excel Input
This section describes the Microsoft Excel input format for the optimiser.
The Excel input must be 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 can contain sheets other than those recognised by the OLM-Excel format. Such extra sheets are ignored by the OLM.
Unless otherwise noted, sheets recognised by the optimiser may contain columns other than those required by the OLM-Excel format. Such extra columns are ignored by the OLM.
Columns recognised by the OLM may appear in any order.
All sheets must have a non-empty first row.
The OLM 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 OLM. All of the unsupported functions are listed in Appendix A.

