ENH: Default for Excel sheetname

[clarkfitzg]

Excel workbooks have 'Sheet1' as the default sheet. Can pd.read_excel have this as a default? pandas.io.excel.read_excel(io, sheetname='Sheet1', **kwds)

This makes pandas more accessible to the user transitioning from Excel by avoiding the common error below:

In [9]: test = pd.read_excel('/Users/clark/Desktop/test.xlsx')
---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
<ipython-input-9-14880f6f18e4> in <module>()
----> 1 test = pd.read_excel('/Users/clark/Desktop/test.xlsx')

TypeError: read_excel() takes exactly 2 arguments (1 given)

[jreback]

hmm...seems reasonable...PR for this?

[clarkfitzg]

Sure, I'll submit a PR tonight.

[hayd]

Probably the default should be 0 (I think these can be accessed by number rather than name now?)

[jreback]

yep that is right!

[clarkfitzg]

Then the first sheet will be loaded even if it doesn't have the name 'Sheet1'. Smart.