[Qgis-user] new xytools plugin: now open and save simple Excel files
Andreas Neumann
a.neumann at carto.net
Thu Dec 15 23:47:15 PST 2011
Hi Richard,
Thank you for the improved plugin! The Excel export was high on the
list of many people.
I tested now only the excel export and import. A few
ideas/observerations:
* whe exporting, I always get a double file extension: filename.xls.xls
- no matter whether I specify the filename with or without the extension
* when exporting, it would be nice to optionally offer additional x/y
columns for point geometries, or the option to export as wkt geometry.
These additional columns could be appended to the end of the attribut
columns.
* If the import would also support import of wkt, one could round-trip
data through export to excel --> editing of data in Office/Openoffice
(e.g. for people who do not have QGIS installed) and then import it
again.
* when importing data it would be nice if the importer allows a better
option to import data without a geometry or x/y columns. Currently one
can import data without x/y column, but only by clicking the "cancel
button". It would be good to have an additional button labeled "Import
without geometry".
These are mostly enhancement ideas, not bugs.
Thanks a lot for making these available!
Andreas
On Thu, 15 Dec 2011 21:33:26 +0100, Richard Duivenvoorde wrote:
> Hi List,
>
> I uploaded a new version of the xytools plugin. After some questions
> and
> discussion on the list about Excel files, I added simple capability
> to
> open and save excel files.
>
> It uses the python xlw and xlrd libs for that
> (http://www.python-excel.org/). Those are available for windows users
> in
> the osgeo4w package. Linux users can probably get it from there
> package
> manager. If all fails, go to http://www.python-excel.org/ and get it
> from there.
>
> In short: it can save the attributes of a vector layer to a simple
> (one
> worksheet containing) xls file.
> It can open an xls file and load it in a memory layer. You can either
> point to an x and y column, and those values will be used for the x
> and
> y of the Point features. Or you can cancel choosing the x and y, and
> the
> attribute data will just be loaded taking 0/0 as x and y coordinates.
>
> There is a help file availabe via the xytools plugin menu with more
> information.
>
> Let me know if you find problems with it or have ideas to improve
> (see
> docs for earlier ideas).
>
> plugin via plugin menu
> or
> http://plugins.qgis.org/plugins/xytools/
>
> source
> http://hub.qgis.org/projects/xytools/repository
>
> project page
> http://hub.qgis.org/projects/xytools
>
> Regards,
>
> Richard Duivenvoorde
>
> ps if you find the plugin really usefull, I'm also trying out paypal
> buttons on the project page :-) Half of the profit (?) goes to the
> qgis
> project for this one I promised Paolo and Tim...
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
More information about the Qgis-user
mailing list