ckan / ckan/datapusher

Last sheet in Excel workbook is often blank

Open
#90 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
82
Forks
157
PR merge metrics
No merged PRs in 30d

Description

Datapusher selects the LAST sheet in an Excel workbook as the one to push. However according to [this user](https://stackoverflow.com/questions/33764220/error-uploading-xls-or-xlsx-files-to-datastore?noredirect=1#comment55334985_33764220) Excel adds 3 blank sheets to a new workbook, so in most cases the last sheet will be blank. This has caused grief.

I imagine that the last sheet was picked for cases where the first sheet is more of an index to the rest of the sheet - ONS uses this in the UK.

So it sounds like a bit of logic is needed to find the last sheet which is not empty.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.