ENH: support none in header list #37625
closes #37625
tests passed
read_excel funtion can now accept header={'Sheet1': 0, 'Sheet2': None} as dictionary with header for each sheet.

This pull request is stale because it has been open for thirty days with no activity. Please update or respond to this comment if you're still interested in working on this. closing as stale. if you want to continue, pls ping and can re-open.