Bug report #20126
Importing Excel *.xlsm files as well
| Status: | Closed | ||
|---|---|---|---|
| Priority: | Normal | ||
| Assignee: | - | ||
| Category: | Data Provider | ||
| Affected QGIS version: | 2.18.24 | Regression?: | No |
| Operating System: | Easy fix?: | No | |
| Pull Request or Patch supplied: | No | Resolution: | no timely feedback |
| Crashes QGIS or corrupts data: | No | Copied to github as #: | 27947 |
Description
- QGIS can recognize *.xlsx files by dragging and dropping however it doesn't recognize *.xlsm (Macro Enabled) files (despite that it has the same xlsx structure) unless the extension is renamed to *.xlsx
- When importing an Excel file, QGIS recognize the headers only if the second row was not empty and contains a number in the 2nd row, can this "Has header" be an optional check in the sheet import dialog instead of auto detect?.
History
#1
Updated by Giovanni Manghi over 5 years ago
- Status changed from Open to Feedback
does OGR (try ogrinfo) recognize such format?
#2
Updated by Jürgen Fischer over 5 years ago
Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.
#3
Updated by Giovanni Manghi about 5 years ago
- Resolution set to no timely feedback
- Status changed from Feedback to Closed