Does a contents sheet actually need to be supplied by the user?

[matt-dray]

Currently the user must add a sheet with sheet_type of "contents". Why? Surely this can be entirely auto-generated; there's nothing extra a user should put in this sheet that isn't already provided (i.e. tab_title and sheet_title).

[matt-dray]

Perhaps because the user may want to add additional information to the table beyond just the tab and sheet titles.

For example, see the Labour Market Overview demo spreadsheet in the best practice guidance, which says:

Note: In this spreadsheet the table of contents includes a column for: publication date, next publication date and source.

This is needed for this spreadsheet as the dates for the next publication date vary and the sources are not all the same.

If all your tables will get updated on the same date and they are all from the same source you can put this information on the cover sheet, you do not need to add these columns to the table of contents.

[matt-dray]

Also it's conceptually easier when using create_a11ytable() to see that you're supplying a number of objects that matches the number of sheets in the output, right? Might seem odd to have one fewer than the user might expect to provide.

[matt-dray]

This is a duplicate of #38.