/pandas

New issue

read_excel with sheetname=None or sheetname=[0,1,”Sheet5”] should preserve sheets order #9930

Closed
scls19fr opened this Issue Apr 18, 2015 · 1 comment

Comments

Assignees
No one assigned
Labels
API Design Difficulty Novice Effort Low IO Excel
Projects
None yet
Milestone
  0.20.0
3 participants
@scls19fr @jreback @jorisvandenbossche
@scls19fr
Contributor

scls19fr commented Apr 18, 2015

Hello,

I noticed in http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html#pandas.read_excel
that read_excel can have a parameter sheetnameset to None or a to a list

In such a case a dictionary of DataFrame is returned.

Maybe it should output an OrderedDict of DataFrame to preserve sheets order.

Kind regards

This was referenced Apr 18, 2015

Closed
Closed

@jreback jreback added Difficulty Novice API Design Excel Effort Low labels Apr 20, 2015

jreback added this to the Next Major Release milestone Apr 20, 2015

scls19fr referenced this issue Nov 3, 2016

Merged

ENH: return an OrderedDict from read_excel with sheetname=None #14571

3 of 4 tasks complete

jorisvandenbossche closed this in #14571 Nov 11, 2016

@jorisvandenbossche jorisvandenbossche modified the milestone: 0.20.0, Next Major Release Nov 11, 2016

@scls19fr
Contributor

scls19fr commented Nov 11, 2016

Thanks @jorisvandenbossche for merging
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment