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
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
