Bug report #20126

Importing Excel *.xlsm files as well

Added by Haitham Shatti about 2 years ago. Updated almost 2 years ago.

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 about 2 years ago

  • Status changed from Open to Feedback

does OGR (try ogrinfo) recognize such format?

#2 Updated by Jürgen Fischer almost 2 years ago

Please test with QGIS 3.4 - QGIS 2.18 reached it's end of life.

#3 Updated by Giovanni Manghi almost 2 years ago

  • Resolution set to no timely feedback
  • Status changed from Feedback to Closed

Also available in: Atom PDF