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