Is there support for addressing worksheets within a spreadsheet?

[ptsefton]

The Table Schema spec mentions spreadsheets, but makes no mention of the fact that spreadsheet formats (usually?) include multiple tables/worksheets - is there a way to describe a table in a spreadsheet/workbook?

[fjuniorr]

tldr

If you are using frictionless-py you can use the dialect.sheet property:

{
  "profile": "tabular-data-package",
  "resources": [
    {
      "name": "spreadsheet",
      "path": "data.xlsx",
      "dialect": {
        "sheet": "sheet1"
      }
    }
  ]
}

Not every tool is going to support this. frictionless-r for example doesn't.

Longer version

The table schema spec does not address the question of where the data is physically located (eg. excel spreadsheet, CSV file, RDBMS table), so I think the mention of spreadsheets on the table schema spec is only conceptual.

The tabular data resource spec on the other hand says that the data the tabular data resource describes MUST, if non-inline, be a CSV file. Although there is a fine proposal to change this in https://github.com/frictionlessdata/specs/issues/697, I think is fair to say that the frictionless specs don't support data in spreadsheets as of today.

However, the frictionless-py python package does have a ExcelDialect that allows you to do this.

[roll]

Thanks! It will be handled in the Table Dialect Spec - https://github.com/frictionlessdata/specs/issues/697