okfn
File with multiple sheets
Problem description
Let's say you download the xls version of this data.
Check file here.
You then go to the ODE and:
- Click on ADD.
- Select the file from your laptop.
The ODE will only show the first sheet.
Suggested solution
Option 1: after the user uploads an Excel file with multiple sheets, the ODE can display a pop-up message warning the user that the tool will only show information contained on the first sheet.
Option 2: display a pop-up message warning the user that the file contains multiple sheets and give him/her/they the opportunity to select which sheet to show on the preview.
Option 3: allow the ODE to display different previews (one per sheet) on within the tool.
@roll comment: "Will be included in v2: https://datapackage.org/specifications/table-dialect/#spreadsheet"