Bug: spreadsheets with headers that have extra, empty columns to right side cause sheet loading to fail with a TypeError

[pbeaucage]

Loading a spreadsheet with empty columns at the right side (as happens, e.g., if you scroll the sheet at all) causes a TypeError on opening. Deleting these empty columns is functionally impossible in Excel. Can the load be tolerant of these? I can find a sheet with this error if needed for testing.

[EliotGann]

this is tough - pandas loading is difficult to fix. We want to remain flexible to column order and potentially adding other columns for other arguments people may need, so there's no real way to find empty columns except selecting the whole column in excel and deleting

[EliotGann]

moving away from excel is the real answer to this, the less fiddling with excel after the initial sample entry the better