If source file is not in current working directory or the path is not absolute path, "relativeToVRT" is necessary.
<SrcDataSource relativeToVRT="1">points.xls</SrcDataSource> Cheers, Minoru 2013/11/6 Minoru Akagi <akagi...@gmail.com>: > Hi Brent, Giovanni and Richard, > > I can open an excel sheet as a point layer with a VRT file. > An example of vrt file: > --- > <OGRVRTDataSource> > <OGRVRTLayer name="points"> > <SrcDataSource>points.xls</SrcDataSource> > <SrcLayer>Sheet1</SrcLayer> > <GeometryType>wkbPoint</GeometryType> > <LayerSRS>WGS84</LayerSRS> > <GeometryField encoding="PointFromColumns" x="lon" y="lat"/> > </OGRVRTLayer> > </OGRVRTDataSource> > --- > > XLS driver is read-only, but newly supported ODS [1] and XLSX [2] > drivers can also write. So we can edit spreadsheet directly in QGIS. > An tip to correctly add points into spreadsheet layer is including at > least one decimal in each x and y column in advance. Making x field > and y field uneditable in the properties dialog may lead to > comfortable editing. > > [1] http://www.gdal.org/ogr/drv_ods.html > [2] http://www.gdal.org/ogr/drv_xlsx.html > > Minoru _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
