search

camptocamp / QGIS-SpreadSheetLayers

QGIS plugin to load layers from spreadsheet files (*.ods, *.xls, *.xlsx)
GNU General Public License v3.0
21 stars 7 forks source link

No Layers are shown after importing a spreadsheet-file #14

Open ghost opened 6 years ago

ghost commented 6 years ago

Hi, First of all, I think the idea is quite great. I am running 2.18 and when importing a *.xlsx file I cannot get any other layers to show. (So Step-wis it looks like 1) import sreadsheet 2) import vector layer --> I cannot get a vector layer to show!)

Second: When I import after importing say vector layers I can only show the second entry of my *.xlsx-file.

eoparada commented 6 years ago

I am in the same situation. I have both v2.18 and v3.2 installed and using the plugin plots points in v3.2 but not in v2.18.

ghost commented 6 years ago

In 3.2 I also can only plot ONE point (the second entry ....) so this plugin still unusable for me ... and the creator(s) do not seem to care ...

arnaud-morvan commented 6 years ago

I just make a test, seems like everything works with my example spreadsheet files. Could you give some example spreadsheet file to reproduce the issue please.

ghost commented 6 years ago

Test.xlsx

only the second entry can be viewed, although they all are the same. It is the file I converted to a csv when I was working on my master thesis .... (had to use csv-file in order for doing what I wanted to do, since the plugin wasn't working)

arnaud-morvan commented 6 years ago

I've loaded this file in QGIS 2.18 under Ubuntu 16.04 and everything seems to work as expected.

ghost commented 6 years ago

weird.

I am using Windows 10. Might this be part of the issue? However, I cannot switch to Ubuntu mid-project ... -.- Or any configuration I changed? :-/

However, last time I even reinstalled QGIS 2.18

arnaud-morvan commented 6 years ago

Note that GDAL use environment variables, see http://www.gdal.org/drv_xlsx.html You can check your current environment in system tab in settings dialog. I've checked that I have no one of OGR ones in my environment.

ghost commented 6 years ago

I actually cannot follow you! You're at the whole refering to QGIS, aren't you?

arnaud-morvan commented 6 years ago

The readme file will give you more information about GDAL/OGR environment variables : https://github.com/camptocamp/QGIS-SpreadSheetLayers/blob/master/README.rst

ghost commented 6 years ago

I added a custom environment variable: (sceenshot!) grafik but to no avail: grafik

I think this is rather weird! can you help me any further?

FeroEQ commented 6 years ago

On Windows 7 (QGIS 2.18.21) plugin stops (at 23:10) working correctly. I am using it every day. Sometimes it cannot show labels, sometimes cannot see points.

FeroEQ commented 6 years ago
  1. ODS files - same problem.
  2. New lines in ods/xls/xlsx are not accepted.
  3. Plugin does not accept custom variable.
FeroEQ commented 6 years ago

One small step - XLSX file works when all columns in the first line have data (number, string). Today :(