search

okfn / opendataeditor

No-code application to explore and publish all kinds of data: datasets, tables, charts, maps, stories, and more. Forever free and open source project powered by open standards and generative AI.
http://opendataeditor.okfn.org
MIT License
150 stars 18 forks source link

File with multiple sheets #379

Open romicolman opened 1 month ago

romicolman commented 1 month ago

Problem description

Let's say you download the xls version of this data.

Check file here.

You then go to the ODE and:

The ODE will only show the first sheet.

Captura de pantalla 2024-05-09 a la(s) 11 32 07

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.

romicolman commented 1 month ago

@roll comment: "Will be included in v2: https://datapackage.org/specifications/table-dialect/#spreadsheet"