Bug report #20126
Importing Excel *.xlsm files as well
|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|
- 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?.