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

[Andreas Neumann]

 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