XLSX: Support GEOMETRY creation option

[Mike Taves]

This feature request is for the XLSX driver to add geometry information similar to the CSV driver with types specified by (e.g.) OGRCSVGeometryFormat in ogr_csv.h.

This way, a user could (e.g.) convert Locations.kmz to Locations.xlsx file with X and Y columns using:

ogr2ogr -f XLSX -lco GEOMETRY=AS_XY Locations.xlsx Locations.kmz

On an implementation side-note, perhaps a higher-level approach for this type of layer creation option should be shared by multiple OGR drivers, including CSV, XLSX, ODS and potentially other creation-enabled geometry-less drivers.

[Even Rouault]

You can use the Spatialite ST_X() and ST_Y() functions to do that:

ogr2ogr -f XLSX test.xlsx test.kmz  -sql "SELECT ST_X(geometry) AS X, ST_Y(geometry) AS Y, * FROM test" -dialect sqlite