1.. _vector.xls: 2 3XLS - MS Excel format 4===================== 5 6.. shortname:: XLS 7 8.. build_dependencies:: libfreexl 9 10This driver reads spreadsheets in MS Excel format. GDAL/OGR must be 11built against the FreeXL library (GPL/LPL/MPL licensed), and the driver 12has the same restrictions as the FreeXL library itself as far as which 13and how Excel files are supported. (At the time of writing - with FreeXL 141.0.0a -, it means in particular that formulas are not supported.) 15 16Each sheet is presented as a OGR layer. No geometry support is available 17directly (but you may use the OGR VRT capabilities for that). 18 19Configuration options 20--------------------- 21 22- OGR_XLS_HEADERS = FORCE / DISABLE / AUTO : By default, the driver 23 will read the first lines of each sheet to detect if the first line 24 might be the name of columns. If set to FORCE, the driver will 25 consider the first line will be taken as the header line. If set to 26 DISABLE, it will be considered as the first feature. Otherwise 27 auto-detection will occur. 28- OGR_XLS_FIELD_TYPES = STRING / AUTO : By default, the driver will try 29 to detect the data type of fields. If set to STRING, all fields will 30 be of String type. 31 32See Also 33-------- 34 35- `Homepage of the FreeXL 36 library <https://www.gaia-gis.it/fossil/freexl/index>`__ 37