Thursday 23 November 2017

qgis - How to install Python libs for XYtools to read Excel files


I need to use the XYtools plugin to read an Excel file. After choosing the XYtools incon and indicating an Excel file to read in, a message appears "there is a problem with loading a python module which is needed to read/write Excel files. ... see documentation/help on how to install the xlw and xlwd libraries." I found the site where the Python items reside but I cannot understand at all what to do next. Apparently the needed Python libraries are not installed with XYtools. I would appreciate being pointed to somewhere that might give some help with exactly what to do to get XYtools to work with Excel files.

Thanks -



Answer



To continue the suggestion by Alister on the qgis-users maillist, since you've installed using the OSGeo4W installer, then just



  • rerun the osgeo-setup.exe, and choose "Advanced Install" in the first window.

  • Click Next->Next a few times till you get to the "Select Packages" window.

  • Here you click on the '+' in the Libs section to open the full list. Scroll down to find the python-xlrd and python-xlwt packages, and select them to be installed (click on the double cirular arrow symbol).

  • After it finishes, open QGIS, and try the XYTools plugin. Should be OK...


No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...