[Qgis-user] new xytools plugin: now open and save simple Excel files

[Richard Duivenvoorde]

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...