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

[Filipe Silva Dias]

Thanks Richard. This tool was on my "Top ten list of things that would make
my work a lot less annoying".

Possible problem: exported the attribute table of a shapefile to an Excel
spreadsheet, but the values of the columns appeared formated as characters
(even though they're numbers). Anyonelse can confirm this?

Best regards
Filipe

On Thu, Dec 15, 2011 at 8:33 PM, Richard Duivenvoorde
<rdmailings at duif.net>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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20111215/e2542c70/attachment.html>