The MetadataWizard is a useful tool designed to facilitate FGDC metadata creation for spatial and non-spatial data sets. It is a cross-platform desktop application built using an open-source Python architecture.
Describe the bug
Version 2.0.7 of the Metadata Wizard will not open an Excel file (xlsx) table. Saving the file to an older version of Excel (extension xls) does work. However, version 2.0.6 will open an xlsx file, so it's surprising that 2.0.7 cannot.
To Reproduce
Steps to reproduce the behavior:
Go to Entity and Attribute Section (Metadata Wizard version 2.0.7)
Click on 'Browse to Dataset' on one of the Detailed tabs
Choose an xlsx file from your machine to load into the Wizard
An error is given saying it could not extract the data from the file, and that Excel xlsx file is not supported.
Expected behavior
All the column labels from the Excel file should get loaded into the Wizard (as well as the enumerated categories), so the metadata descriptors can be added
Describe the bug Version 2.0.7 of the Metadata Wizard will not open an Excel file (xlsx) table. Saving the file to an older version of Excel (extension xls) does work. However, version 2.0.6 will open an xlsx file, so it's surprising that 2.0.7 cannot.
To Reproduce Steps to reproduce the behavior:
Expected behavior All the column labels from the Excel file should get loaded into the Wizard (as well as the enumerated categories), so the metadata descriptors can be added
Screenshots