[Qgis-user] Use excel spreadsheets for join to vector data

[Johan Nilsson]

I have problem to load an xls-file with gett this message:
----------------------------------------------------------------------------------------------
*An error has occured while executing Python code:*

*Traceback (most recent call last):
  File "/home/a/.qgis//python/plugins/xytools/xytools.py", line 138, in
excelOpen
    self.loadSheetAsLayer(provider)
  File "/home/a/.qgis//python/plugins/xytools/xytools.py", line 163, in
loadSheetAsLayer
    QMessageBox.warning(self.iface.mainWindow(), "Unable to open file",
"Unable to open file: " + unicode(filename))
NameError: global name 'filename' is not defined

Python version:
2.6.5 (r265:79063, Oct  1 2012, 22:19:00)
[GCC 4.4.3]


QGIS version:
1.8.0-Lisboa Lisboa, exported

Python path: ['/home/a/.qgis/python/plugins/elevation',
'/usr/share/qgis/python', '/home/a/.qgis//python',
'/home/a/.qgis//python/plugins', '/usr/share/qgis/python/plugins',
'/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2',
'/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old',
'/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages',
'/usr/lib/python2.6/dist-packages/PIL',
'/usr/lib/python2.6/dist-packages/gst-0.10',
'/usr/lib/pymodules/python2.6', '/usr/lib/python2.6/dist-packages/gtk-2.0',
'/usr/lib/pymodules/python2.6/gtk-2.0',
'/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode',
'/usr/local/lib/python2.6/dist-packages',
'/home/a/.qgis/python/plugins/qgis2kml',
'/home/a/.qgis/python/plugins/qgis2kml', '~/.qgis/python',
'/usr/share/qgis/python', '.',
'/usr/share/qgis/python/plugins/fTools/tools']*
-----------------------------------------------------------------------------------------------

I can't find python-openpyxl in my Ubuntu 10.04LTS systems repositories.
Have Ubuntugis unstable ppa.

Cheers

2013/1/17 Paolo Cavallini <cavallini at faunalia.it>

> python-openpyxl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20130117/7e87f152/attachment.html>